Re: Trigger to run @ connection time?
От
Kynn Jones
Тема
Re: Trigger to run @ connection time?
Дата
Msg-id
c2350ba40803111135y5b648c4eta2896bf798d818b8@mail.gmail.com
Ответ на
Re: Trigger to run @ connection time? (Alban Hertroys)
Список
Дерево обсуждения
Trigger to run @ connection time? "Kynn Jones" <kynnjo@gmail.com>
Re: Trigger to run @ connection time? Alban Hertroys <dalroi@solfertje.student.utwente.nl>
Re: Trigger to run @ connection time? "Kynn Jones" <kynnjo@gmail.com>
Re: Trigger to run @ connection time? Tom Lane <tgl@sss.pgh.pa.us>
Re: Trigger to run @ connection time? "Daniel Verite" <daniel@manitou-mail.org>
Re: Trigger to run @ connection time? "Dawid Kuroczko" <qnex42@gmail.com>
Re: Trigger to run @ connection time? "Marko Kreen" <markokr@gmail.com>
Re: Trigger to run @ connection time? "Dawid Kuroczko" <qnex42@gmail.com>
Re: Trigger to run @ connection time? "Marko Kreen" <markokr@gmail.com>
Re: Trigger to run @ connection time? Erik Jones <erik@myemma.com>
Re: Trigger to run @ connection time? "Marko Kreen" <markokr@gmail.com>
Re: Trigger to run @ connection time? Robert Treat <xzilla@users.sourceforge.net>
Re: Trigger to run @ connection time? Erik Jones <erik@myemma.com>
Re: Trigger to run @ connection time? "Kynn Jones" <kynnjo@gmail.com>
Re: Trigger to run @ connection time? Karsten Hilbert <Karsten.Hilbert@gmx.net>
Re: Trigger to run @ connection time? btober@ct.metrocast.net
Re: Trigger to run @ connection time? Alban Hertroys <dalroi@solfertje.student.utwente.nl>
Re: Trigger to run @ connection time? Berend Tober <btober@ct.metrocast.net>
Re: Trigger to run @ connection time? Alban Hertroys <dalroi@solfertje.student.utwente.nl>
Re: Trigger to run @ connection time? "Andrej Ricnik-Bay" <andrej.groups@gmail.com>
Re: Trigger to run @ connection time? "Kynn Jones" <kynnjo@gmail.com>
Re: Trigger to run @ connection time? "Greg Sabino Mullane" <greg@turnstep.com>
On Mon, Mar 10, 2008 at 7:47 PM, Alban Hertroys <dalroi@solfertje.student.utwente.nl> wrote:
You can't define triggers on system tables.
Oh, well... :-/ Thanks for the reality check!
> If not, is there some other way to set up a trigger that
Oops. I guess a cut-and-paste error in my original message must have caused some text to be lost. I meant to write
> If not, is there some other way to set up a trigger that will run whenever a new connection to my_db is
> established?
One could be forgiven for not being able to figure out what I was asking, but, if, in spite of the huge typo, you were in fact able to guess what I had meant to ask, then I'm confused by your suggestion here:
Closest thing I can think of is defining a table that you insert a
record in as soon as you connect and put a trigger on that.
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.
Kynn
В списке pgsql-general по дате отправления
От: A. Kretschmer
Дата:
