Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id 5E112CE6EB
	for <pgsql-sql@postgresql.org>; Fri, 15 Jun 2012 04:24:06 -0300 (ADT)
Received: from escher.rsise.anu.edu.au ([150.203.208.146])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <bob@cs.anu.edu.au>) id 1SfQt2-00050p-Ej
	for pgsql-sql@postgresql.org; Fri, 15 Jun 2012 07:24:05 +0000
Received: from localhost (localhost [127.0.0.1])
	by escher.rsise.anu.edu.au (Postfix) with ESMTP id BC5EE1496F
	for <pgsql-sql@postgresql.org>; Fri, 15 Jun 2012 17:23:47 +1000 (EST)
X-Virus-Scanned: Debian amavisd-new at rsise.anu.edu.au
Received: from escher.rsise.anu.edu.au ([127.0.0.1])
	by localhost (backend3.rsise.anu.edu.au [127.0.0.1]) (amavisd-new,
	port 10024)
	with ESMTP id 0SijXSc1C177 for <pgsql-sql@postgresql.org>;
	Fri, 15 Jun 2012 17:23:44 +1000 (EST)
Received: from [150.203.160.52] (littleblue.anu.edu.au [150.203.160.52])
	(Authenticated sender: bob)
	by escher.rsise.anu.edu.au (Postfix) with ESMTP
	for <pgsql-sql@postgresql.org>; Fri, 15 Jun 2012 17:23:43 +1000 (EST)
Message-ID: <4FDAE2FF.4080004@cs.anu.edu.au>
Date: Fri, 15 Jun 2012 17:23:43 +1000
From: Robert Edwards <bob@cs.anu.edu.au>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.9.2.27) Gecko/20120216 Thunderbird/3.1.19
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Re: Insane behaviour in 8.3.3
References: <201206141139.35601.achill@matrix.gatewaynet.com>
In-Reply-To: <201206141139.35601.achill@matrix.gatewaynet.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -4.2 (----)
X-Archive-Number: 201206/37
X-Sequence-Number: 36691

On 14/06/12 18:39, Achilleas Mantzios wrote:

> dynacom=# SELECT id from items_tmp WHERE id=1261319 AND xid=currval('xadmin_xid_seq');
>   id
> ----
> (0 rows)
> dynacom=# -- THIS IS INSANE

Have you tried:

SELECT id from items_tmp WHERE id=1261319 AND 
xid=currval('xadmin_xid_seq'::text)

or even:

SELECT id from items_tmp WHERE id=1261319 AND 
xid=currval(('xadmin_xid_seq'::text)::regclass)

Bob Edwards.