Re: Permission denied when inserting (SOLVED) - Mailing list 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.

Borek