Re: [SQL] Insane behaviour in 8.3.3

2012-06-15 Thread Raj Mathur (राज माथुर)
On Friday 15 Jun 2012, Samuel Gendler wrote: > On Fri, Jun 15, 2012 at 1:24 AM, Achilleas Mantzios < > > ach...@matrix.gatewaynet.com> wrote: > > And i forgot to mention, minicom term emulation quality sucks, even > > giving simple > > shell commands is a PITA, upgrading the whole fleet would mean

Re: [SQL] Insane behaviour in 8.3.3

2012-06-15 Thread Scott Marlowe
Well, I'd see about finding a way to upgrade to 8.3.19. 8.3.3 has know data eating bugs. On Fri, Jun 15, 2012 at 9:32 AM, Achilleas Mantzios wrote: > On Παρ 15 Ιουν 2012 18:03:26 Scott Marlowe wrote: >> Not talking about going to something after 8.3.19, just updating to >> the latest 8.3 version

Re: [SQL] Insane behaviour in 8.3.3

2012-06-15 Thread Richard Huxton
On 15/06/12 16:32, Achilleas Mantzios wrote: On Παρ 15 Ιουν 2012 18:03:26 Scott Marlowe wrote: Not talking about going to something after 8.3.19, just updating to the latest 8.3 version. On most systems it's a simple: sudo apt-get upgrade or similar and sit back and watch. Thanx, unfortunat

Re: [SQL] Insane behaviour in 8.3.3

2012-06-15 Thread Achilleas Mantzios
On Παρ 15 Ιουν 2012 18:03:26 Scott Marlowe wrote: > Not talking about going to something after 8.3.19, just updating to > the latest 8.3 version. On most systems it's a simple: > > sudo apt-get upgrade > > or similar and sit back and watch. Thanx, unfortunately we dont have TCP/IP connectivity

Re: [SQL] Insane behaviour in 8.3.3

2012-06-15 Thread Scott Marlowe
Not talking about going to something after 8.3.19, just updating to the latest 8.3 version. On most systems it's a simple: sudo apt-get upgrade or similar and sit back and watch. On Fri, Jun 15, 2012 at 2:24 AM, Achilleas Mantzios wrote: > On Παρ 15 Ιουν 2012 10:28:20 Scott Marlowe wrote: >> Y

Re: [SQL] Insane behaviour in 8.3.3

2012-06-15 Thread Achilleas Mantzios
On Παρ 15 Ιουν 2012 12:29:38 Samuel Gendler wrote: > On Fri, Jun 15, 2012 at 2:28 AM, Samuel Gendler > > wrote: > > On Fri, Jun 15, 2012 at 1:24 AM, Achilleas Mantzios < > > > > ach...@matrix.gatewaynet.com> wrote: > >> And i forgot to mention, minicom term emulation quality sucks, even > >> givi

Re: [SQL] Insane behaviour in 8.3.3

2012-06-15 Thread Achilleas Mantzios
On Παρ 15 Ιουν 2012 12:28:21 Samuel Gendler wrote: > On Fri, Jun 15, 2012 at 1:24 AM, Achilleas Mantzios < > > ach...@matrix.gatewaynet.com> wrote: > > And i forgot to mention, minicom term emulation quality sucks, even > > giving simple > > shell commands is a PITA, upgrading the whole fleet woul

Re: [SQL] Insane behaviour in 8.3.3

2012-06-15 Thread Samuel Gendler
On Fri, Jun 15, 2012 at 2:28 AM, Samuel Gendler wrote: > > > On Fri, Jun 15, 2012 at 1:24 AM, Achilleas Mantzios < > ach...@matrix.gatewaynet.com> wrote: > >> >> And i forgot to mention, minicom term emulation quality sucks, even >> giving simple >> shell commands is a PITA, upgrading the whole fl

Re: [SQL] Insane behaviour in 8.3.3

2012-06-15 Thread Samuel Gendler
On Fri, Jun 15, 2012 at 1:24 AM, Achilleas Mantzios < ach...@matrix.gatewaynet.com> wrote: > > And i forgot to mention, minicom term emulation quality sucks, even giving > simple > shell commands is a PITA, upgrading the whole fleet would mean bast case > scenario > minimum 21K USD for the whole f

Re: [SQL] Insane behaviour in 8.3.3

2012-06-15 Thread Achilleas Mantzios
On Παρ 15 Ιουν 2012 10:28:20 Scott Marlowe wrote: > You do realize you're missing four years of bug fixes right? On Πεμ 14 Ιουν 2012 11:39:35 Achilleas Mantzios wrote: > Unfortunately the remote installations are neither physically accessible > nor by TCP/IP accesible (comms are done via UUCP and

Re: [SQL] Insane behaviour in 8.3.3

2012-06-15 Thread Scott Marlowe
You do realize you're missing four years of bug fixes right? -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql

Re: [SQL] Insane behaviour in 8.3.3

2012-06-15 Thread Achilleas Mantzios
On Παρ 15 Ιουν 2012 09:34:16 Richard Huxton wrote: > 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=#

Re: [SQL] Insane behaviour in 8.3.3

2012-06-15 Thread Robert Edwards
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: SE