From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | CSN <cool_screen_name90001(at)yahoo(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: About dropped notifications |
Date: | 2005-08-29 18:00:54 |
Message-ID: | 11309.1125338454@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
CSN <cool_screen_name90001(at)yahoo(dot)com> writes:
> I'm considering setting up a script that listens for
> notifications for a table and if a row is deleted the
> script will delete that row's corresponding files. If
> there are thousands of rows in the table, and I do
> "delete from table", or even "delete from table where
> id >1000 and id<2000", will the script be notified of
> the deletion of each and every row (and subsequently
> be able to delete that row's files), or will only one
> notify event be received (or some number less than the
> actual number of rows deleted)?
Depends where you are doing the notify from ... but I think
with the current implementation, a transaction will emit only
one notify per notify event name, even if NOTIFY is executed
many times within the transaction.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-08-29 19:00:39 | Re: max_connections |
Previous Message | John D. Burger | 2005-08-29 17:59:16 | max_connections |