agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: MichaelDBA Vitale <michaeldba@sqlexec.com>
To: Sarita Sharma <saritakumarisharma61@gmail.com>
To: pgsql-sql@lists.postgresql.org
Subject: Re: Bug in tables column data in postgres database
Date: Thu, 3 Mar 2022 12:24:02 -0500 (EST)
Message-ID: <1444146918.6491942.1646328242347@email.ionos.com> (raw)
In-Reply-To: <CAOKMkZoQ-7kqjLdJgkZxUGe8ODnF4ABhDL_42CvpdaRku7Uhbg@mail.gmail.com>
References: <CAOKMkZoQ-7kqjLdJgkZxUGe8ODnF4ABhDL_42CvpdaRku7Uhbg@mail.gmail.com>
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<div class="default-style">
Hi Sarita,
</div>
<div class="default-style">
<br>
</div>
<div>
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.
</div>
<div class="default-style">
<br>
</div>
<div class="default-style">
Would you provide the DDL you used to create this table, along with any triggers under the covers?
</div>
<div class="default-style">
<br>
</div>
<div class="default-style">
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.
</div>
<div class="default-style">
log_statement = 'mod'
</div>
<div class="default-style">
<br>
</div>
<div class="default-style">
Regards,
</div>
<div class="default-style">
Michael Vitale
</div>
<div class="default-style">
<br>
</div>
<blockquote type="cite">
<div>
On 03/03/2022 11:45 AM Sarita Sharma <saritakumarisharma61@gmail.com> wrote:
</div>
<div>
<br>
</div>
<div>
<br>
</div>
<div dir="ltr">
Hi Team,
<div>
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.
</div>
<div>
eg::
</div>
<div>
if I have stored data into table
</div>
<div>
bike_table
</div>
<div>
======================================
</div>
<div>
bike_name bike_prefix bike_line
</div>
<div>
V111 V 111
</div>
<div>
W222 W 222
<br>
</div>
<div>
X333 X 333
<br>
</div>
<div>
===========================================
</div>
<div>
<br>
</div>
<div>
if some other time if query is made for same table data might look like this
</div>
<div>
<div>
bike_table
</div>
<div>
======================================
</div>
<div>
bike_name bike_prefix bike_line
</div>
<div>
W111 V 111
</div>
<div>
X222 W 222
<br>
</div>
<div>
X333 X 333
<br>
</div>
<div>
===========================================
</div>
</div>
<div>
So usually bike_name keep changing its name thats seems to me a toggling behaviour.
</div>
<div>
Please take this issue as bug and work on this.
</div>
<div>
<br>
</div>
<div>
Thanks and Regards,
</div>
<div>
Sarita
</div>
</div>
</blockquote>
</body>
</html>
view thread (25+ messages) latest in thread
Message-ID: <1444146918.6491942.1646328242347@email.ionos.com>
Permalink: ../1444146918.6491942.1646328242347@email.ionos.com/
Also on: postgresql.org/message-id/1444146918.6491942.1646328242347@email.ionos.com
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: michaeldba@sqlexec.com, saritakumarisharma61@gmail.com, pgsql-sql@lists.postgresql.org
Subject: Re: Bug in tables column data in postgres database
In-Reply-To: <1444146918.6491942.1646328242347@email.ionos.com>
* 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