Re: Plpgsql search_path issue going from 9.3 to 9.6

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: George Woodring <george(dot)woodring(at)iglass(dot)net>
Cc: pavel(dot)stehule(at)gmail(dot)com, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Plpgsql search_path issue going from 9.3 to 9.6
Date: 2018-11-13 15:32:53
Message-ID: 46fb30be-ffc3-2a7c-7e93-4dc9944d2d7d@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message George Woodring 2018-11-13 15:37:28 Re: Plpgsql search_path issue going from 9.3 to 9.6
Previous Message George Woodring 2018-11-13 14:54:38 Re: Plpgsql search_path issue going from 9.3 to 9.6