On 03/10/2015 08:20 AM, Andrzej Pilacik wrote:
I see the issues that this person might be having. I am not doing a restore or working on an existing issue.
I know, but the thread actually covers the same ground. If you want to learn exactly what happens with FKs and users in Postgres read Tom Lanes responses in the thread. They will explain what you are seeing.
My setup is very vanilla, anyone can create these tables and test, will get the same permission error... (I did it in a brand new environment)
What I am asking here is why does a SUPERUSER not able to insert the data when the constraint is introduced. On Tue, Mar 10, 2015 at 10:16 AM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>> wrote: On 03/10/2015 05:41 AM, Stephen Frost wrote: * Andrzej Pilacik (cypisek77@xxxxxxxxx <mailto:cypisek77@xxxxxxxxx>) wrote: Can anyone explain how the FK constraint function works? Is it executed as the owner of the object. That is the only thing that would make sense for me. Yes. This brought back a memory. For the hows and whys see this thread : http://www.postgresql.org/__message-id/4D6BB33F.9010704@__lupomesky.cz <http://www.postgresql.org/message-id/4D6BB33F.9010704@xxxxxxxxxxxx> Thanks, Stephen -- Adrian Klaver adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general