Re: Q: Executing functions at connect/disconnect? - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Q: Executing functions at connect/disconnect?
Date
Msg-id 20030704185533.GA15206@wolff.to
Whole thread Raw
In response to Re: Q: Executing functions at connect/disconnect?  ("Darko Prenosil" <Darko.Prenosil@finteh.hr>)
List pgsql-general
On Thu, Jul 03, 2003 at 20:37:08 +0200,
  Darko Prenosil <Darko.Prenosil@finteh.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.

pgsql-general by date:

Previous
From: "Darko Prenosil"
Date:
Subject: Re: Q: Executing functions at connect/disconnect?
Next
From: Andrew Sullivan
Date:
Subject: Re: any body using Solaris8 with postgresql 7.3.3