Question about isolation

From: Samuel Tardieu <sam(at)rfc1149(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Question about isolation
Date: 2004-01-28 17:58:53
Message-ID: 87fze0lztu.fsf@beeblebrox.enst.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)rfc1149(dot)net -- http://www.rfc1149.net/sam

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message j knight 2004-01-28 19:18:27 Re: Aggregate function error in 7.4
Previous Message Tom Lane 2004-01-28 16:49:12 Re: [SQL] postgres timeout.