I'm pretty sure that postgresql doesn't change your data itself.
How do you prove that no other app changes the data between 1st an 2nd query?
Mit freundlichen Grüßen
Martin Stöcker ----------------------------------------- ETL Datenservice GmbH Widdersdorfer Str. 415 | D-50933 Köln Telefon: +49(0)2219544010 Fax: +49(0)2219544015 Email: Martin.Stoecker@etl-datenservice.de
ETL Datenservice GmbH Widdersdorfer Str. 415 · 50933 Köln Geschäftsführer: Dr. Dirk Goldner, Michael Kleinert, ppa Melanie Lillich Amtsgericht Köln · HRB 75439 · USt.-Id: DE 122 805 685 www.etl-datenservice.de Email: info@etl-datenservice.de
Die STB Datenservice ist jetzt ETL Datenservice. Sie erreichen uns nun unter dem Zusatz @etl-datenservice.de
Von: Sarita Sharma <saritakumarisharma61@gmail.com> Gesendet: Donnerstag, 3. März 2022 17:45:53 An: pgsql-sql@lists.postgresql.org Betreff: Bug in tables column data in postgres database
Hi Team,
I am a backend(server side) developer and I am using postgres database for storing my data to database. I have find a big challenge working with postgres database(version 13) as I have find major issue working with column in table of database as data keep toggling its value.
eg::
if I have stored data into table
bike_table
======================================
bike_name bike_prefix bike_line
V111 V 111
W222 W 222
X333 X 333
===========================================
if some other time if query is made for same table data might look like this
bike_table
======================================
bike_name bike_prefix bike_line
W111 V 111
X222 W 222
X333 X 333
===========================================
So usually bike_name keep changing its name thats seems to me a toggling behaviour.