Postgres Pro
Downloads
Home   >   mailing lists

RE: Re: Foreign Key Validation after Reference Table Ownership Change - Mailing list pgsql-general

From Battuello, Louis
Subject RE: Re: Foreign Key Validation after Reference Table Ownership Change
Date
Msg-id 20180321083033.f495bf0537e129b62c3edf58e37f64ff.23347c6e15.mailapi@email02.godaddy.com
Whole thread Raw
In response to Re: Foreign Key Validation after Reference Table Ownership Change  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Re: Foreign Key Validation after Reference Table Ownership Change  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
So, user_2 needs usage on the schema containing its newly owned reference table even though user_1 is performing the insert on a table in the other schema? Interesting. I though the validation was only dependent on user_1's ACL.
 
--------- Original Message ---------
Subject: Re: Foreign Key Validation after Reference Table Ownership Change
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: 3/21/18 11:23 am
To: "Battuello, Louis" <louis.battuello@etasseo.com>
Cc: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>

On Wednesday, March 21, 2018, Battuello, Louis <louis.battuello@etasseo.com> wrote:

What permission is being violated at the schema level?

USAGE
 
 
David J.

pgsql-general by date:

Previous
From: HORDER Phil
Date:
Subject: RE: Foreign Key locking / deadlock issue.... v2
Next
From: Alessandro Aste
Date:
Subject: Postgresql 10.3 , query never completes if LIMIT clause is specifiedand paralle processing is on