Re: Permission denied when inserting - Mailing list pgsql-general

Vick Khera <vivek@khera.org> writes:
> On Mon, Feb 28, 2011 at 9:37 AM, Borek Lupomesky <borek@lupomesky.cz> wrote:
>> � �"permout_site_fkey" FOREIGN KEY (site, cp) REFERENCES out2cp(site, cp) ON
>> DELETE CASCADE

> 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.

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

            regards, tom lane