Re: select view definition from pg_views feature request

Поиск
Список
Период
Сортировка
От George Neuner
Тема Re: select view definition from pg_views feature request
Дата
Msg-id 9fh3seh2i2h0p9hd13mj01j90fgmqvrpsa@4ax.com
обсуждение исходный текст
Ответ на select view definition from pg_views feature request  (Michael Shapiro <mshapiro51@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: rihad
Дата:
Сообщение: Re: Upgrade procedure
Следующее
От: Kevin Brannen
Дата:
Сообщение: RE: Upgrade procedure