Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: [7.4] "permissions problem" with pl/pgsql function
Date
Msg-id 10240.1074544185@sss.pgh.pa.us
Whole thread Raw
In response to [7.4] "permissions problem" with pl/pgsql function  ("Marc G. Fournier" <scrappy@hub.org>)
Responses PostGIS dropgeometrycolumn function (Was: Re: [7.4] "permissions problem" with pl/pgsql function )  ("Marc G. Fournier" <scrappy@postgresql.org>)
List pgsql-hackers
Tree view 
"Marc G. Fournier" <scrappy@hub.org> writes:
> 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

Can't tell much about this without seeing the contents of the function ...
in particular, what SQL command is it trying to execute when it chokes?
        regards, tom lane

pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Old binary packages.
Next
From: Tom Lane
Date:
Subject: Re: Old binary packages.