Vick Khera <vivek@xxxxxxxxx> writes: > On Mon, Feb 28, 2011 at 9:37 AM, Borek Lupomesky <borek@xxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general