Re: [GENERAL] Means to emulate global temporary table - Mailing list pgsql-general

From Pavel Stehule
Subject Re: [GENERAL] Means to emulate global temporary table
Date
Msg-id CAFj8pRBb21Ev3O0XMcx4F+fnp3okUHNvJNP5Wi0gsLL=LJrD1g@mail.gmail.com
Whole thread Raw
In response to [GENERAL] Means to emulate global temporary table  (Ian Lewis <ilewismsl@gmail.com>)
List pgsql-general
Hi

2017-01-12 10:06 GMT+01:00 Karsten Hilbert <Karsten.Hilbert@gmx.net>:
On Wed, Jan 11, 2017 at 05:54:11PM -0700, David G. Johnston wrote:

> I don't see where "call a setup function immediately after connecting"

Sounds like a "login trigger", more generally an ON CONNECT
event trigger, which we don't have at the moment as far as I
know.

One of the main arguments against it was that a failing
trigger function might prevent all access while the suggested
solution to that (I think by Tom Lane) was to auto-disable ON
CONNECT triggers when starting up as --single.

Unfortunately, I don't know what came of it by now.


Regards

Pavel


Karsten
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: [GENERAL] Means to emulate global temporary table
Next
From: Berend Tober
Date:
Subject: Re: [GENERAL] Means to emulate global temporary table