Re: Bug in tables column data in postgres database

From: Sándor Daku <daku(dot)sandor(at)gmail(dot)com>
To: Sarita Sharma <saritakumarisharma61(at)gmail(dot)com>
Cc: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Re: Bug in tables column data in postgres database
Date: 2022-03-06 10:08:54
Message-ID: CAKyoTgYkPg7nsTANMq-YSygkM1vFy16aPwzOFm4MWT9ReS1--Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Sun, 6 Mar 2022 at 00:14, Sarita Sharma <saritakumarisharma61(at)gmail(dot)com>
wrote:

> As of now I think I only faced this issue in postgres database behavioural
> issue. In future ofcourse more developers might face such issue.
>

>
> All the best team.
>
> On Sat, 5 Mar 2022, 20:57 David G. Johnston, <david(dot)g(dot)johnston(at)gmail(dot)com>
> wrote:
>
>> On Sat, Mar 5, 2022 at 3:29 AM Sarita Sharma <
>> saritakumarisharma61(at)gmail(dot)com> wrote:
>>
>>>
>>> I am only hoping that some point of time the bug reported by me will get
>>> reproduced from your end and you will find time to work on this.
>>>
>>>>
>>>>>
>> I can assure you that absent further feedback and details from you no one
>> will be working on this. Hundreds of thousands of people have hundreds, if
>> not thousands, of tables, in production databases, running 24x7x365, and do
>> not experience this behavior. The problem is specific to your organization
>> and thus your organization's responsibility.
>>
>> David J.
>>
>>
Hi,

What you are telling to us is not a simple bug. It's something that would
make Postgres completely unusable as a database. Luckily nobody experienced
it so far except you.(Mind you, people on this list have countless hours of
experience building, running and maintaining Postgres databases and I don't
even dare to guess how much data that means.)
It is analogous with telling the Java core developers that if statement
doesn't work correctly, it messes up the evaluation of the condition
sometimes.
It's highly unlikely. And this is the only thing we can tell you without
further information about your issue.

So if you want our help, please provide us at least the table definition
and the select statement producing the wrong result.
On top of that log and check the dml statements on your database to see if
something modifies the data without your knowledge.

Regards,
Sándor

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Michaeldba@sqlexec.com 2022-03-06 12:23:23 Re: Bug in tables column data in postgres database
Previous Message David G. Johnston 2022-03-05 16:07:51 Re: Bug in tables column data in postgres database