Re: Bug in tables column data in postgres database

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Sarita Sharma <saritakumarisharma61(at)gmail(dot)com>
Cc: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: Re: Bug in tables column data in postgres database
Date: 2022-03-03 17:18:59
Message-ID: 39AFDD57-D4B2-4566-A78A-DE03351A60AD@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> On Mar 3, 2022, at 08:45, Sarita Sharma <saritakumarisharma61(at)gmail(dot)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.

While never say never, the issue you are describing is essentially impossible. Can we see the schema of the table, and the statements you are using to insert the data and query it?

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message MichaelDBA Vitale 2022-03-03 17:24:02 Re: Bug in tables column data in postgres database
Previous Message Stöcker 2022-03-03 17:10:06 AW: Bug in tables column data in postgres database