Postgres Pro
Downloads
Home   >   mailing lists

Re: Re:BUG #16434: some data lost - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Re:BUG #16434: some data lost
Date
Msg-id 24730.1589462379@sss.pgh.pa.us
Whole thread Raw
In response to Re:BUG #16434: some data lost  (Konstantin Davydenka <davydenka@mail.ru>)
List pgsql-bugs
Tree view 
=?UTF-8?B?S29uc3RhbnRpbiBEYXZ5ZGVua2E=?= <davydenka@mail.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

pgsql-bugs by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: BUG #16436: Functions with input parameter table type failingfrom application
Next
From: PG Bug reporting form
Date:
Subject: BUG #16437: The dump is stored with error in creating VIEW statement.