From: | Benjamin Gonay <us066182(at)ltlg1(dot)is(dot)belgacom(dot)be> |
---|---|
To: | pgsql-admin(at)postgreSQL(dot)org |
Subject: | help on create view... |
Date: | 1999-01-27 21:56:07 |
Message-ID: | Pine.LNX.3.96.990127224952.27154A-100000@ltlg1.bc |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)Gonay(at)ltlg1(dot)is(dot)belgacom(dot)be _/
_/ ~~ Soyons realistes, exigeons l'impossible. (E. Che Guevara) ~~ _/
_/ - - [Belgium - Liege] - - - - - - - - - - - - - - - - - - - - - - - _/
_/ linux forever...Linux Forever...LINUX Forever...LINUX FOREVER !!!!! _/
---------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Adam Di Carlo | 1999-01-27 22:21:53 | web page error |
Previous Message | Senthil Kumar Narayanasamy | 1999-01-27 19:37:54 | Error in creating the database |