problem with select after updating

From: "Raul DAVIDOVICH" <R(dot)DAVIDOVICH(at)cvitkovic-ac(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: problem with select after updating
Date: 2001-12-10 16:07:03
Message-ID: OF831B3279.EF611D5E-ONC1256B1E.0058541B@cvitkovic-ac.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I'm having a problem when updating a row.. after comiting the change,
the row appears at the end of the list, and from there on, it stays there
until the next update.
This happens when using both JDBC or psql. Normally, rows shouldn't
change the order after updates. Am I messing it up with the indexes?

thank you very much in advance

---------------------------------------------------
Raul Davidovich
Responsable Informatique
Cvitkovic & Associés Consultants

(33) 1 45 15 40 68
(33) 1 45 15 40 41 Fax
-------------------------------------------------------
http://www.caconcology.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Frank Joerdens 2001-12-10 16:09:46 Re: use BLOBS or use pointers to files on the filesystem?
Previous Message Tom Lane 2001-12-10 15:39:39 Re: lost system tables: any hope?