Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: BUG #18527: Imported data using a csv file and made a latest entry into same table using a form. Got an issue!
Date
Msg-id CAKFQuwaCcNC=iOo=bXty+8JKiwN-LiFtjRV_n_q8Vv6+G_ocPg@mail.gmail.com
Whole thread Raw
In response to BUG #18527: Imported data using a csv file and made a latest entry into same table using a form. Got an issue!  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
Tree view
On Mon, Jul 1, 2024 at 8:32 AM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      18527
Logged by:          Vishnu Vardhan Vithanala
Email address:      vishnu.vardhann05@gmail.com
PostgreSQL version: 16.3
Operating system:   Windows
Description:       

When I bulk uploaded some data using a csv file, it was all good. There were
543 rows in order and it went into the table and sat cleanly!

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.

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #18527: Imported data using a csv file and made a latest entry into same table using a form. Got an issue!
Next
From: Erik Wienhold
Date:
Subject: Re: BUG #18527: Imported data using a csv file and made a latest entry into same table using a form. Got an issue!