Just had a client point this out to me, and am wondering if its supposed
to happen:
420_test=> select
dropgeometrycolumn('420_test','lroadline61','roads61_geom');
ERROR: permission denied for relation pg_attribute
CONTEXT: PL/pgSQL function "dropgeometrycolumn" line 19 at execute statement
the database was created as:
CREATE DATABASE <db> WITH OWNER = <owner>
and I'm connected to the database as the owner ... shouldn't the "system
tables" also be owned by the owner?
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664