Re: Plpgsql search_path issue going from 9.3 to 9.6 - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Plpgsql search_path issue going from 9.3 to 9.6
Date
Msg-id 46fb30be-ffc3-2a7c-7e93-4dc9944d2d7d@aklaver.com
Whole thread Raw
In response to Re: Plpgsql search_path issue going from 9.3 to 9.6  (George Woodring <george.woodring@iglass.net>)
Responses Re: Plpgsql search_path issue going from 9.3 to 9.6
List pgsql-general
On 11/13/18 6:54 AM, George Woodring wrote:
> The tickets view restricts which tickets can be seen by the schema.
> 
> 9.3 must have created the view in the same column order as the table 
> (which is the case looking at one of our 9.3 databases which we have not 
> updated yet), which is why we never saw the issue before.

What is the view definition?

> 
> George
> iGLASS Networks
> www.iglass.net <http://www.iglass.net>
> 



-- 
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: George Woodring
Date:
Subject: Re: Plpgsql search_path issue going from 9.3 to 9.6
Next
From: George Woodring
Date:
Subject: Re: Plpgsql search_path issue going from 9.3 to 9.6