X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4EA97D1B449 for ; Wed, 28 Jan 2004 18:01:53 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 16951-03 for ; Wed, 28 Jan 2004 14:01:23 -0400 (AST) Received: from main.gmane.org (main.gmane.org [80.91.224.249]) by svr1.postgresql.org (Postfix) with ESMTP id 677C2D1CAF0 for ; Wed, 28 Jan 2004 14:00:54 -0400 (AST) Received: from list by main.gmane.org with local (Exim 3.35 #1 (Debian)) id 1Altzg-0000AN-00 for ; Wed, 28 Jan 2004 19:00:52 +0100 Received: from willow.rfc1149.net ([81.56.47.149]) by news.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed Jan 28 18:00:52 2004 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-sql@postgresql.org Received: from sea.gmane.org ([80.91.224.252]) by main.gmane.org with esmtp (Exim 3.35 #1 (Debian)) id 1Altzd-0000AE-00 for ; Wed, 28 Jan 2004 19:00:49 +0100 Received: from news by sea.gmane.org with local (Exim 3.35 #1 (Debian)) id 1Altzd-0003aA-00 for ; Wed, 28 Jan 2004 19:00:49 +0100 From: Samuel Tardieu Subject: Question about isolation Date: Wed, 28 Jan 2004 18:58:53 +0100 Organization: Avian Carrier & Friends Lines: 14 Message-ID: <87fze0lztu.fsf@beeblebrox.enst.fr> Mime-Version: 1.0 (generated by SEMI 1.14.5 - "Awara-Onsen") Content-Type: text/plain; charset=US-ASCII X-Complaints-To: usenet@sea.gmane.org Gmane-NNTP-Posting-Host: willow.rfc1149.net User-Agent: T-gnus/6.16.2 (based on Gnus v5.10.2) (revision 02) SEMI/1.14.5 (Awara-Onsen) FLIM/1.14.5 (Demachiyanagi) APEL/10.6 Emacs/21.3 (i386--freebsd) MULE/5.0 (SAKAKI) Cancel-Lock: sha1:JV5KC9xEP+0fiW33eXE2/fBPWe0= X-Leafnode-NNTP-Posting-Host: 3ffe:304:103:a2:200:39ff:fe25:3aa2 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/238 X-Sequence-Number: 16631 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