Re: unlock rows

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: unlock rows
Дата
Msg-id 20030313213501.GA27771@wolff.to
обсуждение исходный текст
Ответ на Re: unlock rows  (Dennis Gearon <gearond@cvc.net>)
Список 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 по дате отправления:

Предыдущее
От: Jean-Luc Lachance
Дата:
Сообщение: Re: Function in selection?
Следующее
От: Adam
Дата:
Сообщение: functional indexes and their costs