Re: has_table_priviledge

On Thu, 24 Apr 2003, Tom Lane wrote:

> 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).

version
-----------------------------------------------------------
PostgreSQL 7.2 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)

it seems to work for me on 7.3.2 though...

strange.

-a

--
====================================
| Ara Howard
| NOAA Forecast Systems Laboratory
| Information and Technology Services
| Data Systems Group
| R/FST 325 Broadway
| Boulder, CO 80305-3328
| Email: ara(dot)t(dot)howard(at)fsl(dot)noaa(dot)gov
| Phone: 303-497-7238
| Fax: 303-497-7259
====================================