Question about isolation - Mailing list pgsql-sql

From Samuel Tardieu
Subject Question about isolation
Date
Msg-id 87fze0lztu.fsf@beeblebrox.enst.fr
Whole thread Raw
Responses Re: Question about isolation
List pgsql-sql
If in a transaction I call an embedded function in Pl/PgSQL, in which
I have:
 delete from t where condition; for e in select distinct on (f) * from t where ... loop    ... end loop;

Do I have the guarantee that, in any event, rows deleted from table t
by the delete won't reappear in the select result?
 Sam
-- 
Samuel Tardieu -- sam@rfc1149.net -- http://www.rfc1149.net/sam



pgsql-sql by date:

Previous
From: Przemysław Słupkowski
Date:
Subject: managing users in postgresql 7.4.1
Next
From: j knight
Date:
Subject: Re: Aggregate function error in 7.4