Re: BUG #18527: Imported data using a csv file and made a latest entry into same table using a form. Got an issue!

There is no such thing as "in order" when it comes to the contents of a table.

The rest of what you posted I cannot follow but unless you can distill this down to a test case whereby you only use psql and server features it is not going to be recognized as a bug in PostgreSQL.

If you need help writing programs using PostgreSQL the -general mailing list is where to seek it.  Right now it seems you have made incorrect assumptions and built on top of those.  That will require some work on your end to redesign things to work in a manner consistent with the non-ordering of tables in PostgreSQL.  Usually just adding an order by clause to your queries solves the issue.

David J.