[7.4] "permissions problem" with pl/pgsql function - Mailing list pgsql-hackers

From Marc G. Fournier
Subject [7.4] "permissions problem" with pl/pgsql function
Date
Msg-id 20040119154535.L15422@ganymede.hub.org
Whole thread Raw
Responses Re: [7.4] "permissions problem" with pl/pgsql function  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [7.4] "permissions problem" with pl/pgsql function  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Lamar Owen
Date:
Subject: Old binary packages.
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Old binary packages.