agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Stöcker, Martin <Martin.Stoecker@etl-datenservice.de>
To: Sarita Sharma <saritakumarisharma61@gmail.com>
To: pgsql-sql@lists.postgresql.org <pgsql-sql@lists.postgresql.org>
Subject: AW: Bug in tables column data in postgres database
Date: Thu, 3 Mar 2022 17:10:06 +0000
Message-ID: <30a0813b98774e618a620f3b8cd8abcf@etl-datenservice.de> (raw)
In-Reply-To: <CAOKMkZoQ-7kqjLdJgkZxUGe8ODnF4ABhDL_42CvpdaRku7Uhbg@mail.gmail.com>
References: <CAOKMkZoQ-7kqjLdJgkZxUGe8ODnF4ABhDL_42CvpdaRku7Uhbg@mail.gmail.com>
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<http://www.etl-datenservice.de;
Email: info@etl-datenservice.de<mailto: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.
Please take this issue as bug and work on this.
Thanks and Regards,
Sarita
Message-ID: <30a0813b98774e618a620f3b8cd8abcf@etl-datenservice.de>
Permalink: ../30a0813b98774e618a620f3b8cd8abcf@etl-datenservice.de/
Also on: postgresql.org/message-id/30a0813b98774e618a620f3b8cd8abcf@etl-datenservice.de
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: Martin.Stoecker@etl-datenservice.de, saritakumarisharma61@gmail.com, pgsql-sql@lists.postgresql.org
Subject: Re: AW: Bug in tables column data in postgres database
In-Reply-To: <30a0813b98774e618a620f3b8cd8abcf@etl-datenservice.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox