CSN <cool_screen_name90001@xxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
