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

From Konstantin Davydenka
Subject Re:BUG #16434: some data lost
Date
Msg-id 1589443991.737893612@f171.i.mail.ru
Whole thread Raw
In response to BUG #16434: some data lost  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: Re:BUG #16434: some data lost  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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.

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #16436: Functions with input parameter table type failing from application
Next
From: Heikki Linnakangas
Date:
Subject: Multi-parent inherited table with mixed storage options cannot berestored