> 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?
No, you have to have the usecatupd field set to true in your pg_shadow
row to be able to modify the catalogs. This is automatically assigned
to a superuser, not the database owner. (Otherwise it's trivial to munt
someone else's database by deleting from pg_database or pg_shadow...)
Chris