Re: unlock rows - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: unlock rows
Date
Msg-id 20030313213501.GA27771@wolff.to
Whole thread Raw
In response to Re: unlock rows  (Dennis Gearon <gearond@cvc.net>)
List pgsql-general
On Thu, Mar 13, 2003 at 10:58:57 -0800,
  Dennis Gearon <gearond@cvc.net> wrote:
> What about if one is using a row as a semaphore?
>
> For example, a script accessing the database needs to know if a certain table has any rows in it
> with 'appoved::bool' equal to false before it inserts a row that WILL have that set to false.
> that way, it will generate an email to the site owner to go and look at items in that table and
> approve them.
>
> I wouldn't want an email for each line added.

When you do the query to see who to email you can should have it combine
all of the items for a given site into one message.

pgsql-general by date:

Previous
From: Jean-Luc Lachance
Date:
Subject: Re: Function in selection?
Next
From: Adam
Date:
Subject: functional indexes and their costs