[postgis-users] schema support patch 2
strk at keybit.net
Tue Dec 23 01:11:18 PST 2003
This is a big change, please give it a try.
AddGeometryColumn AND DropGeometryColumn have been
moved from 'common' to 'version-specific' enabler scripts.
For versions prior 7.3 schema argument is just discarder.
For versions 7.3 and 7.4 schema argument is checked for existance
and set to current_schema() if empty or invalid (raising a notice
in the latter case).
fix_geometry_columns(), called at the end of every addgeometrycolumn()
call, will set to 'empty' every invalid f_table_schema, with no notice.
DropGeometryColumn will not find any record with an empty f_table_schema,
so people will need to store a valid schema name in the geometry_columns
table if they want to be able to use dropgeometrycolumn.
NOTE: shp2pgsql has not been patched yet, so it will continue to
produce AddGeometryColumn calls with 'invalid' schema_name.
(handled by the procedure).
More information about the postgis-users