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