Re: Wrong select results after transaction (HELP PLS)

From: Tino Wildenhain <tino(at)wildenhain(dot)de>
To: go <go(at)ugnn(dot)ru>
Cc: Postgresql-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Wrong select results after transaction (HELP PLS)
Date: 2005-06-10 19:15:25
Message-ID: 1118430925.30233.1.camel@Andrea.peacock.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am Freitag, den 10.06.2005, 08:42 +0400 schrieb go:
> Hi,
>
> Help me please to resolve the problem:
> Just After commiting transaction - writing ,say 90 rows,I try to select
> the same 90 rows - and get wrong set of rows (some of them: 1-2 replaced
> by unknown data). But after 10-20 seconds the result of selecting
> the neccessary 90 rows return right result.
> Tell me pls what to do.

You should start with explaining in detail what you do, and what you
use to write and query.

E.g. how do you insert, and how do you select "the same 90 rows"

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-06-10 19:49:12 Re: index xyz is not a btree
Previous Message David Parker 2005-06-10 19:02:57 index xyz is not a btree