Re: Bug in tables column data in postgres database

Christophe Pettus <xof@thebuild.com>

From: Christophe Pettus <xof@thebuild.com>
To: Sarita Sharma <saritakumarisharma61@gmail.com>
Cc: pgsql-sql@lists.postgresql.org
Date: 2022-03-03T17:18:59Z
Lists: pgsql-sql

> On Mar 3, 2022, at 08:45, 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.


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?