Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
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".

GPG key ID E4071346 @
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

In response to


pgsql-general by date

Next:From: Grzegorz JaśkiewiczDate: 2009-02-04 18:36:24
Subject: Re: Pet Peeves?
Previous:From: John DeSoiDate: 2009-02-04 17:39:42
Subject: Re: Pet Peeves?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group