[postgis-users] shp2pgsql and schemas

[Paul Ramsey]

Carl Anderson wrote:

> On 2003.07.04 11:55 Paul Ramsey wrote:
> 
>> Now that schemas actually *exist* in pgsql, our behavior is in wrong. 
>> The schema idea can be literally and correctly translated into pgsql 
>> terms. So AddGeometryColumn should be dumbed down to just
>>
>> AddGeometryColumn( <tablename>, <columnname>, <srid>, <type>, <dim> )
>>
> 
> There would need to be a period of transition so that client apps can 
> work with the old (current) or newer (schema sensitive) style.

Isn't it likely that client apps currently ignore the 'schema' column, 
since it is patently useless? (we should have just left it blank, oh 
well). I mean, if you are connected to database 'foo', will you ever 
look at the schema column to confirm that the table you want is in fact 
in database 'foo'?


-- 
       __
      /
      | Paul Ramsey
      | Refractions Research
      | Email: pramsey at refractions.net
      | Phone: (250) 885-0632
      \_