| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Dennis Gearon <gearond(at)cvc(dot)net> |
| Cc: | jose antonio leo <jaleo8(at)storelandia(dot)com>, "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: unlock rows |
| Date: | 2003-03-13 21:35:01 |
| Message-ID: | 20030313213501.GA27771@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Mar 13, 2003 at 10:58:57 -0800,
Dennis Gearon <gearond(at)cvc(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adam | 2003-03-13 21:36:42 | functional indexes and their costs |
| Previous Message | Jean-Luc Lachance | 2003-03-13 20:01:17 | Re: Function in selection? |