On Feb 28, 2011, at 8:07 PM, Borek Lupomesky wrote: > spam=> INSERT INTO permout ( site, cp, owner, descr, creat_who ) VALUES ( > 'vin', '3035.1', 'borelupo', 'test', 'borelupo' ); > ERROR: permission denied for relation out2cp > CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."out2cp" x WHERE > "site"::pg_catalog.text OPERATOR(pg_catalog.=) $1::pg_catalog.text AND > "cp"::pg_catalog.text OPERATOR(pg_catalog.=) $2::pg_catalog.text FOR SHARE OF > x"
Try to give SELECT privileges to user on table "public"."out2cp" Thanks & Regards, Vibhor Kumar EnterpriseDB Corporation vibhor.ku...@enterprisedb.com Blog:http://vibhork.blogspot.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
