Re: Re:BUG #16434: some data lost

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Konstantin Davydenka <davydenka(at)mail(dot)ru>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: Re:BUG #16434: some data lost
Date: 2020-05-14 13:19:39
Message-ID: 24730.1589462379@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

=?UTF-8?B?S29uc3RhbnRpbiBEYXZ5ZGVua2E=?= <davydenka(at)mail(dot)ru> writes:
> I don't understand that... why  "insert into select" statement query can see all rows,
>  but other select queries can not see all rows.

I wonder if you have a corrupt index in there. REINDEX should fix it if
so.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2020-05-14 16:21:25 BUG #16437: The dump is stored with error in creating VIEW statement.
Previous Message Pavel Stehule 2020-05-14 11:12:48 Re: BUG #16436: Functions with input parameter table type failing from application