Re: has_table_priviledge - Mailing list pgsql-general

From Tom Lane
Subject Re: has_table_priviledge
Date
Msg-id 29292.1051223984@sss.pgh.pa.us
Whole thread Raw
In response to Re: has_table_priviledge  (ahoward <ahoward@fsl.noaa.gov>)
Responses Re: has_table_priviledge  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: has_table_priviledge  (ahoward <ahoward@fsl.noaa.gov>)
List pgsql-general
ahoward <ahoward@fsl.noaa.gov> writes:
> create table advisory_lock
> (
>   relname text,
>   constraint c check
>     (has_table_privilege(user, relname, 'update'))
> );
> insert into advisory_lock values ('pg_class');

> psql:lock.sql:7: ERROR:  text_oid: error in "pg_class": can't parse "pg_class"

> shouldn't this work?

It does work, for me.  What PG version are you using, exactly?  How did
you build it?  I see no problem using 7.3 branch tip (so it could be
that the problem is fixed by some post-7.3.2 patch, but I can't think
of any that might be relevant).

Can anyone else try this case?

            regards, tom lane


pgsql-general by date:

Previous
From: ahoward
Date:
Subject: Re: has_table_priviledge
Next
From: Stephan Szabo
Date:
Subject: Re: has_table_priviledge