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 по дате отправления: