has_table_priviledge - Mailing list pgsql-general

From ahoward
Subject has_table_priviledge
Date
Msg-id Pine.LNX.4.53.0304241914550.8186@eli.fsl.noaa.gov
Whole thread Raw
Responses Re: has_table_priviledge  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general

postgresql'rs-

i can't, for the live of me, figure out why this does not work?

grib_tables=# \d btrel
       Table "btrel"
 Column  | Type | Modifiers
---------+------+-----------
 relname | text | not null
Primary key: btrel_pkey
Triggers: RI_ConstraintTrigger_5481788,
          RI_ConstraintTrigger_5481786,
          RI_ConstraintTrigger_4557550,
          RI_ConstraintTrigger_4557548

grib_tables=# select has_table_priviledge('ahoward',"btrel",'update');
ERROR:  Attribute 'btrel' not found

grib_tables=# select has_table_priviledge('ahoward','btrel','update');
ERROR:  Function 'has_table_priviledge(unknown, unknown, unknown)' does not exist
        Unable to identify a function that satisfies the given argument types
        You may need to add explicit typecasts

grib_tables=# select has_table_priviledge('ahoward',btrel,'update');
ERROR:  Attribute 'btrel' not found

am i doing something completely stupid here?

-a


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

pgsql-general by date:

Previous
From: Jeff Eckermann
Date:
Subject: Re: ODBC & Access [Try 2]
Next
From: Robert Treat
Date:
Subject: Re: [SQL] rewriting values with before trigger