2011/8/24 Merlin Moncure <mmoncure@xxxxxxxxx>: > On Wed, Aug 24, 2011 at 9:30 AM, Pavel Stehule <pavel.stehule@xxxxxxxxx> wrote: >> Hello >> >> 2011/8/24 Gauthier, Dave <dave.gauthier@xxxxxxxxx>: >>> Does PG support the use of an init script or procedure? I'm looking for >>> something that'll run unconditionally every time someone makes a DB >>> connection. This script will create a temp table and stuff some data in it >>> for general use within that session. >>> >> >> no, there is nothing similar. You have to call a own procedure after >> login explicitly > > We could really use this. It's kinda sorta possible to script SQL on > connection close via C hook through dblink but not on session startup. > It's not always possible for the client know when a backend session is > fired up -- for example in connection pools. connection pooling is problem every time. This is not task for server, but for connection pooling maintainer. Once we used a workaround - on a start every function we tested if session is well initialized, and if not, then we called a init function. But it has a problem with pooling, so we changed to explicitly call a init function. Regards Pavel Stehule > > merlin > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
