Skip site navigation (1) Skip section navigation (2)

Re: Permission denied when inserting (SOLVED)

From: Borek Lupomesky <borek(at)lupomesky(dot)cz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Permission denied when inserting (SOLVED)
Date: 2011-02-28 16:25:11
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
On 28.2.2011 17:02, Tom Lane wrote:
>> you don't have permissions to verify the FK constraint. the query you
>> see in the error is exactly this test.
> Right.  But actually, that query will be run with the permissions of the
> owner of the table, so it's that user (not necessarily the one doing the
> INSERT) who lacks permissions.

    Ah! That's the piece information I didn't know. Yes, after doing 
'ALTER TABLE out2cp OWNER TO "borelupo"' all is fine and dandy.
    Thank a lot, Tom.

> It sounds like the dump-and-restore process was pretty incomplete.
> How was it done exactly?  Not with pg_dumpall, I'm guessing.

    I used pg_restore and didn't use the right set of switches... I 
know, silly me.


In response to

pgsql-general by date

Next:From: Adrian KlaverDate: 2011-02-28 17:06:05
Subject: Re: Permission denied when inserting
Previous:From: Tom LaneDate: 2011-02-28 16:17:07
Subject: Re: Permission denied when inserting

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group