Re: Q: Executing functions at connect/disconnect?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Darko Prenosil <Darko(dot)Prenosil(at)finteh(dot)hr>
Cc: Mattias Kregert <mattias(at)kregert(dot)se>, pgsql-general(at)postgresql(dot)org
Subject: Re: Q: Executing functions at connect/disconnect?
Date: 2003-07-04 18:55:33
Message-ID: 20030704185533.GA15206@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jul 03, 2003 at 20:37:08 +0200,
Darko Prenosil <Darko(dot)Prenosil(at)finteh(dot)hr> wrote:
>
> But unfortunately, I think that triggers and rules are not working on system
> objects.

You can't put triggers on system tables. I am not sure about rules, but I
would expect the same limitation.

You probably need a monitoring process that notices when backends go away.
At worst you could have it check every so often. I don't know if notify
works with system tables. If it does you could have the process wake up
on the events of interest.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-07-04 19:18:43 Re: PostgreSQL vs. MySQL
Previous Message Josh Berkus 2003-07-04 18:37:58 Re: PostgreSQL vs. MySQL