Re: has_table_priviledge

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