"David G. Johnston" <david.g.johnston@xxxxxxxxx> writes: > On Wed, Mar 21, 2018 at 8:30 AM, Battuello, Louis < > louis.battuello@xxxxxxxxxxx> wrote: >> 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. > It was the only thing that made sense, given the error, though I agree it > seems a bit odd. The point is you can't resolve a name like "schema_1.something" unless you have USAGE on schema_1. So the RI-checking query, which is run as the owner of the table, fails at parse time. regards, tom lane
