Re: [SQL] Insane behaviour in 8.3.3

2012-06-14 Thread Richard Huxton
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) dy

Re: [SQL] Insane behaviour in 8.3.3

2012-06-14 Thread Adrian Klaver
On 06/14/2012 01:39 AM, Achilleas Mantzios wrote: > Hello,one remote user reported a problem and i was surprised to witness the > following behaviour. > It is on postgresql 8.3.3 > > dynacom=# BEGIN; > BEGIN > dynacom=# > dynacom=# > dynacom=# insert into xadmin(appname,apptbl_tmp,gao,id,comment)

[SQL] Insane behaviour in 8.3.3

2012-06-14 Thread Achilleas Mantzios
Hello,one remote user reported a problem and i was surprised to witness the following behaviour. It is on postgresql 8.3.3 dynacom=# BEGIN; BEGIN dynacom=# dynacom=# dynacom=# insert into xadmin(appname,apptbl_tmp,gao,id,comment) dynacom-# values('PMS','overhaul_report_tmp','INSERT',nextval('o