Re: has_table_priviledge - Mailing list pgsql-general

From Stephan Szabo
Subject Re: has_table_priviledge
Date
Msg-id 20030424154530.X6293-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Re: has_table_priviledge  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Thu, 24 Apr 2003, Tom Lane wrote:

> 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?

It seemed to work for me on a 7.3.1 machine I tried it on.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: has_table_priviledge
Next
From: ahoward
Date:
Subject: Re: has_table_priviledge