On Mon, Mar 10, 2008 at 7:47 PM, Alban Hertroys <dalroi@xxxxxxxxxxxxxxxxxxxxxxxxxxxx> 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
