Horton

Re: Insane behaviour in 8.3.3

Richard Huxton <dev@archonet.com>

View thread View on postgr.es
From: Richard Huxton <dev@archonet.com>
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Cc: pgsql-sql@postgresql.org
Date: 2012-06-15T06:34:16Z
Lists: pgsql-sql 
On 14/06/12 09:39, Achilleas Mantzios wrote:
> dynacom=# SELECT id from items_tmp WHERE id=1261319 AND xid=61972;
>     id
> ---------
>   1261319
> (1 row)
> dynacom=# -- ok this is how it should be
> dynacom=# SELECT id from items_tmp WHERE id=1261319 AND xid=currval('xadmin_xid_seq');
>   id
> ----
> (0 rows)
> dynacom=# -- THIS IS INSANE

Perhaps just do an EXPLAIN ANALYSE on both of those. If for some reason 
one is using the index and the other isn't then it could be down to a 
corrupted index. Seems unlikely though.

-- 
   Richard Huxton
   Archonet Ltd