Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] Big IN() clauses etc : feature proposal - Mailing list pgsql-hackers

From Jim C. Nasby
Subject Re: [PERFORM] Big IN() clauses etc : feature proposal
Date
Msg-id 20060510184035.GN99570@pervasive.com
Whole thread Raw
In response to Re: [PERFORM] Big IN() clauses etc : feature proposal  (PFC <lists@peufeu.com>)
List pgsql-hackers
Tree view 
On Tue, May 09, 2006 at 11:33:42AM +0200, PFC wrote:
>     - Repeating the query might yield different results if records were
>     added  or deleted in the meantime.

BTW, SET TRANSACTION ISOLATION LEVEL serializeable or BEGIN ISOLATION
LEVEL serializeable would cure that.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-hackers by date:

Previous
From: Mike Benoit
Date:
Subject: Re: BEGIN inside transaction should be an error
Next
From: Zdenek Kotala
Date:
Subject: [TODO] Allow commenting of variables ...