has_table_priviledge

Поиск
Список
Период
Сортировка
От ahoward
Тема has_table_priviledge
Дата
Msg-id Pine.LNX.4.53.0304241914550.8186@eli.fsl.noaa.gov
обсуждение исходный текст
Ответы Re: has_table_priviledge
Список 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 по дате отправления:

Предыдущее
От: Jeff Eckermann
Дата:
Сообщение: Re: ODBC & Access [Try 2]
Следующее
От: Robert Treat
Дата:
Сообщение: Re: [SQL] rewriting values with before trigger