On 12/03/2008, Kynn Jones <[EMAIL PROTECTED]> wrote: > If one can set up this insert operation so that it happens automatically > whenever a new connection is made, I'd like to learn how it's done. But if > not, then I don't see how performing the insert "manually" every time one > connects would be any easier than simply executing the perl_setup() > procedure directly. After having thought about this for a few seconds <BEG> you could conceivably use some OS/DB integration to achieve this. Just make sure postmaster writes new connections to a log, monitor that log from a script, and if it sees a "connect" have that insert a value into "special table" of yours that then can do the trigger you looked for? Of course I may not have quite understood how that "this procedure adds useful definitions, mostly subs, to Perl's main package. This needs to be done for each connection" is meant to work.
Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
