Re: [GENERAL] When is commited data available

2011-05-26 Thread Merlin Moncure
On Thu, May 26, 2011 at 9:33 AM, Fredric Fredricson wrote: > Hi, > I wonder when the committed data is available to other connections, or more > specifically if there is a delay after COMMIT return successfully and the > data will appear in SELECTs made by other connections. > > A more detailed de

Re: [GENERAL] When is commited data available

2011-05-26 Thread Vick Khera
On Thu, May 26, 2011 at 10:33 AM, Fredric Fredricson wrote: > I wonder when the committed data is available to other connections, or more > specifically if there is a delay after COMMIT return successfully and the > data will appear in SELECTs made by other connections. Check what your isolation

Re: [GENERAL] When is commited data available

2011-05-26 Thread Tom Lane
Fredric Fredricson writes: > I wonder when the committed data is available to other connections, or > more specifically if there is a delay after COMMIT return successfully > and the data will appear in SELECTs made by other connections. No, there's no delay. regards, t

[GENERAL] When is commited data available

2011-05-26 Thread Fredric Fredricson
Hi, I wonder when the committed data is available to other connections, or more specifically if there is a delay after COMMIT return successfully and the data will appear in SELECTs made by other connections. A more detailed description of my problem: I use postgresql as backend to a REST ser