From: Aaron Bono <postgresql@aranya.com>
To: Robert Edwards <bob@cs.anu.edu.au>
Cc: pgsql-sql@postgresql.org
Subject: Re: on connect/on disconnect
Date: Sun, 10 Sep 2006 23:28:43 -0500
Message-ID: <bf05e51c0609102128u7a6d98e3g9faf634a71736bd@mail.gmail.com> (raw)
In-Reply-To: <4504B474.9010801@cs.anu.edu.au>
References: <4504B474.9010801@cs.anu.edu.au>
On 9/10/06, Robert Edwards <bob@cs.anu.edu.au> wrote:
>
> (this is my first post to this list...)
>
> I am wondering if Postgres, and/or SQL in general, has a facility to
> run a function at connection set-up time (after a successful connection
> attempt) and/or at session completion (or disconnect)?
>
> I want to pre-populate a table (actually an INSERT rule on a view)
> with some user-specific data that is unlikely to change during the
> session and which is "difficult" to process (ie. affects performance
> to do it too often).
>
> Clearly, I can do this manually anyway as the first operation after
> a connection is established, but I would like also to clear it out
> when the session terminates (so, I guess I am really interested in
> a "trigger" of some sort on end-of-session).
>
> Purely session/connection-based temporary tables would also do what
> I need, but temporary tables don't seem to be able to work that way.
What kind of operation are you wanting to do? Would it work if an
application like a web site used connection pooling - thus sharing the
session across application users and rarely if ever
connecting/disconnecting?
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.comhttp://codeelixir.com
==================================================================
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: postgresql@aranya.com, bob@cs.anu.edu.au
Subject: Re: on connect/on disconnect
In-Reply-To: <bf05e51c0609102128u7a6d98e3g9faf634a71736bd@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox