ahoward <ahoward(at)fsl(dot)noaa(dot)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