Re:BUG #16434: some data lost

From: Konstantin Davydenka <davydenka(at)mail(dot)ru>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re:BUG #16434: some data lost
Date: 2020-05-14 08:13:11
Message-ID: 1589443991.737893612@f171.i.mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


 
today i copied rows again;
insert into public.a202003_foreign_new  select * from public.a202003;
copied 61140720! 
select count(*) from a202003  ; return result 60594707!
but how?  why i cannot see some rows in old tables ?
run: vacuum(full) a202003 and i can see  all rows in source table…
I don't understand that... why  "insert into select" statement query can see all rows,
 but other select queries can not see all rows.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2020-05-14 10:31:11 Multi-parent inherited table with mixed storage options cannot be restored
Previous Message PG Bug reporting form 2020-05-14 05:38:53 BUG #16436: Functions with input parameter table type failing from application