[postgis-users] shp2pgsql and schemas

Carl Anderson carl.anderson at vadose.org
Fri Jul 4 17:57:23 PDT 2003


On 2003.07.04 14:06 Paul Ramsey wrote:
> Carl Anderson wrote:

>> 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?

Well as soon a shp2pgsql gets changed something like qgis will have to
support users in the old (current) style and users in the new style.

as soon as non bogus data is in f_table_schema apps will have to
know how to differentiate the old bogus info from the new non bogus 
info.  or have a strategy to deal with both.

the method to try with f_table_schema as meaningful and failover to try
as bogus (if f_table_schema == the database name) seems to be a
fairly easy way to deal with the issue.


C.



More information about the postgis-users mailing list