Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nPpjK-0001Zb-2D for pgsql-sql@arkaria.postgresql.org; Thu, 03 Mar 2022 17:59:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nPpjI-0006oU-HS for pgsql-sql@arkaria.postgresql.org; Thu, 03 Mar 2022 17:59:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nPoy0-00018q-H3 for pgsql-sql@lists.postgresql.org; Thu, 03 Mar 2022 17:10:16 +0000 Received: from smtp-out2b.eurodata.de ([212.89.148.88] helo=smtp-out2.eurodata.de) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nPoxt-0007gK-DC for pgsql-sql@lists.postgresql.org; Thu, 03 Mar 2022 17:10:16 +0000 Received: from mx1.eurodata.de (mx1.eurodata.de [212.89.148.81]) by smtp-out2.eurodata.de (Postfix) with ESMTP id D745120008A4 for ; Thu, 3 Mar 2022 18:10:07 +0100 (CET) Received: from ed-imap.hip99.ncc.eurodata.de ([10.2.2.99]) by mx1.eurodata.de with ESMTP id 223HA76i001480-223HA76j001480; Thu, 3 Mar 2022 18:10:07 +0100 Received: from edex2.edmail.eurodata.de (imap4s2.eurodata.de [172.24.7.12]) by ed-imap.hip99.ncc.eurodata.de (Postfix) with ESMTP id 05DA817F91; Thu, 3 Mar 2022 18:10:07 +0100 (CET) Received: from edex2.edmail.eurodata.de (172.24.7.12) by edex2.edmail.eurodata.de (172.24.7.12) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256) id 15.1.2375.17; Thu, 3 Mar 2022 18:10:06 +0100 Received: from edex2.edmail.eurodata.de ([172.24.7.12]) by edex2.edmail.eurodata.de ([172.24.7.12]) with mapi id 15.01.2375.017; Thu, 3 Mar 2022 18:10:06 +0100 From: =?iso-8859-1?Q?St=F6cker=2C_Martin?= To: Sarita Sharma , "pgsql-sql@lists.postgresql.org" Subject: AW: Bug in tables column data in postgres database Thread-Topic: Bug in tables column data in postgres database Thread-Index: AQHYLyB2WBMa0i4prkqXOwhaRVD+V6yt4/S0 Date: Thu, 3 Mar 2022 17:10:06 +0000 Message-ID: <30a0813b98774e618a620f3b8cd8abcf@etl-datenservice.de> References: In-Reply-To: Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [31.31.209.12] Content-Type: multipart/alternative; boundary="_000_30a0813b98774e618a620f3b8cd8abcfetldatenservicede_" MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_30a0813b98774e618a620f3b8cd8abcfetldatenservicede_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 quer= y? Mit freundlichen Gr=FC=DFen Martin St=F6cker ----------------------------------------- ETL Datenservice GmbH Widdersdorfer Str. 415 | D-50933 K=F6ln Telefon: +49(0)2219544010 Fax: +49(0)2219544015 Email: Martin.Stoecker@etl-datenservice.de ETL Datenservice GmbH Widdersdorfer Str. 415 =B7 50933 K=F6ln Gesch=E4ftsf=FChrer: Dr. Dirk Goldner, Michael Kleinert, ppa Melanie Lillic= h Amtsgericht K=F6ln =B7 HRB 75439 =B7 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 Gesendet: Donnerstag, 3. M=E4rz 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 postg= res database(version 13) as I have find major issue working with column i= n table of database as data keep toggling its value. eg:: if I have stored data into table bike_table =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D bike_name bike_prefix bike_line V111 V 111 W222 W 222 X333 X 333 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D if some other time if query is made for same table data might look like thi= s bike_table =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D bike_name bike_prefix bike_line W111 V 111 X222 W 222 X333 X 333 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D So usually bike_name keep changing its name thats seems to me a toggling b= ehaviour. Please take this issue as bug and work on this. Thanks and Regards, Sarita --_000_30a0813b98774e618a620f3b8cd8abcfetldatenservicede_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

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 q= uery?


Mit freundlichen Gr=FC=DFen

Martin St=F6cker<= span style=3D"font-size:12pt"> 
-----------------------------------------
ETL Datenservice GmbH
Widdersdorfer Str. 415 | D-50933 K= =F6ln
Telefon: +49(0)2219544010
Fax: +49(0)2219544015
Email: Martin.Stoecker@etl-datenservice.= de

E= TL Datenservice GmbH
Widdersdorfer Str. 415 =B7 50933 K=F6ln
Gesch=E4ftsf=FChrer: Dr. Dirk Goldner, Michael Kleinert, ppa Melanie Lillich
Amtsgericht K=F6ln =B7 HRB 75439 =B7 USt.-Id= : DE 122 805 685
www.etl-datenservice.de
Email: info@etl-datenservice.de

Die STB Datenservice ist jetzt ETL Datenservic= e.
Sie erreichen uns nun unter dem Zusatz @etl-datenservice.de
Von: Sarita Sharma <sari= takumarisharma61@gmail.com>
Gesendet: Donnerstag, 3. M=E4rz 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 wo= rking with  column in table of database as data keep toggling its value. 
eg::
if I have stored data into table 
bike_table
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
bike_name    bike_prefix    bike_line
V111               V  &nb= sp;               111
W222              W    &n= bsp;            222
X333               X  &nb= sp;               333
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

if some other time if query is made for same table data might loo= k like this
bike_table
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
bike_name    bike_prefix    bike_line
W111               V  &nb= sp;               111
X222              W    &n= bsp;             222
X333               X  &nb= sp;               333
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
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
--_000_30a0813b98774e618a620f3b8cd8abcfetldatenservicede_--