help on create view...

Поиск
Список
Период
Сортировка
От Benjamin Gonay
Тема help on create view...
Дата
Msg-id Pine.LNX.3.96.990127224952.27154A-100000@ltlg1.bc
обсуждение исходный текст
Список pgsql-admin
Hi all,

And first, let me tell you all congratulations for your work for
this wonderful RDBMS package... which Postgres is.

Just a little question: I'd like create a view, but i get the following
error message :
test=> create view v_aff_csc as select nom,prenom from cc_adr;
ERROR:  pg_rewrite: Permission denied.

I've looked in man pages of create_view, but infos are never in worst
case... :-)
My grants are:
relname     |relacl
------------+------------------
cc_adr      |{"=","gonay=arwR"}

It seems i missed something.. :-)  but what ?
Thanks to light me. :-)

Cybersalutations.
Benjamin Gonay
---------------------------------------------------------------------------
_/        Email internet : Benjamin.Gonay@ltlg1.is.belgacom.be           _/
_/  ~~ Soyons realistes, exigeons l'impossible.    (E. Che Guevara)  ~~  _/
_/  - - [Belgium - Liege] - - - - - - - - - - - - - - - - - - - - - - -  _/
_/  linux forever...Linux Forever...LINUX Forever...LINUX FOREVER !!!!!  _/
---------------------------------------------------------------------------


В списке pgsql-admin по дате отправления:

Предыдущее
От: Senthil Kumar Narayanasamy
Дата:
Сообщение: Error in creating the database
Следующее
От: Adam Di Carlo
Дата:
Сообщение: web page error