Re: select view definition from pg_views feature request - Mailing list pgsql-general

From George Neuner
Subject Re: select view definition from pg_views feature request
Date
Msg-id 9fh3seh2i2h0p9hd13mj01j90fgmqvrpsa@4ax.com
Whole thread Raw
In response to select view definition from pg_views feature request  (Michael Shapiro <mshapiro51@gmail.com>)
List pgsql-general
On Tue, 5 Nov 2019 14:29:00 +1300, David Rowley
<david.rowley@2ndquadrant.com> wrote:


>See https://www.postgresql.org/docs/current/sql-set.html
>
>"SET only affects the value used by the current session."
>
>Also:
>
>"The effects of SET LOCAL last only till the end of the current transaction"
>
>Neither affects other sessions.


Ok, so you need to "ALTER DATABASE ..." for the change to affect
everyone.  Thanks for the clarification.

George




pgsql-general by date:

Previous
From: rihad
Date:
Subject: Re: Upgrade procedure
Next
From: Kevin Brannen
Date:
Subject: RE: Upgrade procedure