Re: [GENERAL] Empty SELECT result at simultaneous calls

2010-09-09 Thread Craig Ringer
On 09/10/2010 03:33 AM, Stefan Wild wrote: Thanks for the good Idea! Unfortunately it is old data (already inserted since some days) so this cannot be the reason... Is there any chance you can provide a self-contained example that includes both a populated database and the complete, compilab

Re: [GENERAL] Empty SELECT result at simultaneous calls

2010-09-09 Thread Stefan Wild
> Is this freshly inserted data you're having issues with? > > If so, I suspect you're running into issues where the data > has been written in another transaction but that transaction > has not yet committed. The data is **NOT** visible to other > transactions until the writing transaction commi

Re: [GENERAL] Empty SELECT result at simultaneous calls

2010-09-08 Thread Craig Ringer
On 8/09/2010 11:40 PM, Stefan Wild wrote: Hello, as already stated: "When I'm working with delays in the servlets, everything works fine." the same selects on the same id work fine if delayd. So the data should not be the problem. Is this freshly inserted data you're having issues with? If

Re: [GENERAL] Empty SELECT result at simultaneous calls

2010-09-08 Thread Stefan Wild
> Excerpts from Stefan Wild's message > of mié sep 08 11:40:25 -0400 2010: > > Hello, > > > > as already stated: "When I'm working with delays in > the servlets, everything works fine." the same selects on > the same id work fine if delayd. So the data should not be > the problem. > > So why are

Re: [GENERAL] Empty SELECT result at simultaneous calls

2010-09-08 Thread Alvaro Herrera
Excerpts from Stefan Wild's message of mié sep 08 11:40:25 -0400 2010: > Hello, > > as already stated: "When I'm working with delays in the servlets, everything > works fine." the same selects on the same id work fine if delayd. So the data > should not be the problem. So why are you blaming Po

Re: [GENERAL] Empty SELECT result at simultaneous calls

2010-09-08 Thread Stefan Wild
Betreff: Re: [GENERAL] Empty SELECT result at simultaneous calls > An: "Stefan Wild" > CC: "pgsql-general@postgresql.org" > Datum: Mittwoch, 8. September, 2010 01:27 Uhr > Stefan Wild > writes: > > I have a problem with my web application and postgres.

Re: [GENERAL] Empty SELECT result at simultaneous calls

2010-09-07 Thread Tom Lane
Stefan Wild writes: > I have a problem with my web application and postgres. I have several > servlets on a page which results in severeal simultaneous data base calls > kind of: > SELECT d.id, d.aa, d.ab, ts.ac, d.ad, d.af, d.ag, d.ah, d.ai, d.aj, d.ak, > d.al, d.am, d.an, d.ao, d.ap, d.ar,

[GENERAL] Empty SELECT result at simultaneous calls

2010-09-07 Thread Stefan Wild
Hello guys, I have a problem with my web application and postgres. I have several servlets on a page which results in severeal simultaneous data base calls kind of: SELECT d.id, d.aa, d.ab, ts.ac, d.ad, d.af, d.ag, d.ah, d.ai, d.aj, d.ak, d.al, d.am, d.an, d.ao, d.ap, d.ar, d.as, d.at, d.au, d