Re: Strange security issue with Superuser access

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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
>
> On 03/10/2015 05:41 AM, Stephen Frost wrote:
>
> * Andrzej Pilacik (cypisek77(at)gmail(dot)com
> <mailto:cypisek77(at)gmail(dot)com>) 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(dot)9010704(at)__lupomesky(dot)cz
> <http://www.postgresql.org/message-id/4D6BB33F.9010704@lupomesky.cz>
>
>
> Thanks,
>
> Stephen
>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com