Thread: help on create view...

help on create view...

From
Benjamin Gonay
Date:
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 !!!!!  _/
---------------------------------------------------------------------------