[7.4] "permissions problem" with pl/pgsql function

From: "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: [7.4] "permissions problem" with pl/pgsql function
Date: 2004-01-19 19:47:05
Message-ID: 20040119154535.L15422@ganymede.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2004-01-19 20:00:25 Re: Old binary packages.
Previous Message Lamar Owen 2004-01-19 19:35:57 Old binary packages.