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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
