Re: Pet Peeves?

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Pet Peeves?
Date: 2009-02-04 17:48:17
Message-ID: 20090204174817.GC4041@merkur.hilbert.loc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Feb 04, 2009 at 12:37:31PM -0500, Guy Rouillier wrote:

> Karsten Hilbert wrote:
>>>> Craig, what kind of "events" are you thinking about? Triggers are
>>>> already pieces of code that run upon "certain events", namely
>>>> insert, update or delete events. What others do you have in mind?
>>> That's a good point, actually. I can't think of much you can't do
>>> with a trigger (SECURITY DEFINER if necessary) on a table. Not
>>> thinking straight.
>>
>> I would find ON CONNECT/DISCONNECT triggers very useful. Probably
>> this is more similar to database-wide assertions.
>
> But a job scheduler would not help with that. Perhaps you intended your
> comment to fall into the "pet peeves" bucket rather than the "job
> scheduler" bucket.

Yep, just like the Subject suggested ;-)

The logic is a bit twisted but I was thinking "other kinds
of events - oh, I'd like to be able to make something happen
on this event".

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2009-02-04 18:36:24 Re: Pet Peeves?
Previous Message John DeSoi 2009-02-04 17:39:42 Re: Pet Peeves?