help on create view...

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 !!!!! _/
---------------------------------------------------------------------------

Browse pgsql-admin by date

  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