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 Klaver||Date: 2011-02-28 17:06:05|
|Subject: Re: Permission denied when inserting|
|Previous:||From: Tom Lane||Date: 2011-02-28 16:17:07|
|Subject: Re: Permission denied when inserting |