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 1nPpBS-0008Q3-Hj for pgsql-sql@arkaria.postgresql.org; Thu, 03 Mar 2022 17:24: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 1nPpBR-0001gq-3Z for pgsql-sql@arkaria.postgresql.org; Thu, 03 Mar 2022 17:24:09 +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 1nPpBQ-0001gg-Qu for pgsql-sql@lists.postgresql.org; Thu, 03 Mar 2022 17:24:08 +0000 Received: from mout.perfora.net ([74.208.4.196]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nPpBO-0007nF-8D for pgsql-sql@lists.postgresql.org; Thu, 03 Mar 2022 17:24:08 +0000 Received: from oxuslxaltgw00.schlund.de ([10.72.76.56]) by mrelay.perfora.net (mreueus002 [74.208.5.2]) with ESMTPSA (Nemesis) id 0LeeUq-1nyHRk46us-00qUb1; Thu, 03 Mar 2022 18:24:02 +0100 Date: Thu, 3 Mar 2022 12:24:02 -0500 (EST) From: MichaelDBA Vitale To: Sarita Sharma , pgsql-sql@lists.postgresql.org Message-ID: <1444146918.6491942.1646328242347@email.ionos.com> In-Reply-To: References: Subject: Re: Bug in tables column data in postgres database MIME-Version: 1.0 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Priority: 3 Importance: Normal X-Mailer: Open-Xchange Mailer v7.10.5-Rev38 X-Originating-Client: open-xchange-appsuite X-Provags-ID: V03:K1:3NqkxYlCCVqJZE4uaOGEo1CiiIJ7eLCj6rbT3rnVwZNk3/My9/I k/gojvVuaRrt0wpJnSzQ4RooCxgAUkAppsTROyiS/ONpjxS7VVesPnikEf1StT2+JZXjD5+ LqzLITITRmgOE5E6ossifx6JP0hCJmj41Avv7tdP94NuTjDHqrEoGrUK1M5DHk9TFmoX12O bPxQ5pB1TVh/2up94JbbA== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:P9X+Ee96v4s=:BoR6V7JHh0sLB+XXVQUBZ/ l+7et3kkvfZeJpWugBs4GSRwe4LVz4wbdBjCJ82Fe1QkBIcN8rwmliX+JDQkRHyt36e8JBM6S Uqfc6rdnJ9jaChB7zSTlcqnLr8JamTPfAhcYlFHwJ+bfpSHU2eNU+ChozeK6nrfm+2rq182GG SxdWo5JxpbafhntlmCokEQ+E27aYV4gEj/BZ/vwSBhJKCwD9TO5EDKkNkfd2d+im6b1WnsCHu QPJ0QkXbajyMVpVbHKP2CGKYiUxpE2X5M7R+brlSprypebS9mtIB5ovArxSx5MBLDh05h6taM TmmFVeBggSfaTjmPVEIR8niqQRkdDbg7N88uGCF0WD3fji3Lr3eNab7y21MaGE6aWV2r4Viv9 0/VVd8wG84wXbYCuDqzIrM8CJyaWk0aGEP220/j/JSLXBumMAVJheWo6vMjZcghj1MVqsQdB7 xfM9r6qu8mVAnS2yj/Cv4rphl0iMhbjuZXn6FxqkAV1Z5PqtegwMXT2BfELMSCDk/egT4Dtq9 rmBc9hZQa6UyLKj5wiIqM4DbSxx64GiR0fZ++Qcq/UV80GM+cx2B5Z382XCBdFCNBSp62NBDz xsBmetDx2k6N6iD657OvHK250IbkeyO47pADbqIE6lwzfxxxRm6L4+uPnZ+XJQgQx+um3ZNqM 4WR5hpEw2VXs6kzG5GHnK+SQKFscTI4j5VloevVzuS1QehwWMG2SNwMpgow2xFjGtwik= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk

Hi Sarita,

Well, I doubt we will take this as a bug in PG at the getgo. I very seriously doubt this is a bug due to some PG internal toggling wrangling going on. I think we can get to the bottom of this if you provide more info in this thread.

Would you provide the DDL you used to create this table, along with any triggers under the covers?

Then later, we might need to turn on some debugging in the PG log so we can capture any DML changes to this table to see if that is the culprit.

log_statement = 'mod'

Regards,

Michael Vitale

On 03/03/2022 11:45 AM Sarita Sharma <saritakumarisharma61@gmail.com> wrote:

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