has_table_priviledge

From: ahoward <ahoward(at)fsl(dot)noaa(dot)gov>
To: pgsql-general(at)postgresql(dot)org
Subject: has_table_priviledge
Date: 2003-04-24 19:17:44
Message-ID: Pine.LNX.4.53.0304241914550.8186@eli.fsl.noaa.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)t(dot)howard(at)fsl(dot)noaa(dot)gov
| Phone: 303-497-7238
| Fax: 303-497-7259
====================================

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Treat 2003-04-24 19:22:24 Re: [SQL] rewriting values with before trigger
Previous Message Dennis Gearon 2003-04-24 19:10:39 Re: [SQL] rewriting values with before trigger