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
====================================
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 |