Hi Tom,
> Another possibility is that t_stockchanges has child table(s). Your
> SELECT would count rows in the child tables, but I don't think that
That's the case. I tried to copy the content of t_stockchanges table into a
temp table.
Being very lazy:) I created the temp table using create table... inhetit
from ... command instead of creating it independently. I haven't read the
manual carefuly enough regarding inherit clause.
> pg_dump -t would dump them.
No, pg_dump doesn't dump them - this was what I found strange.
I suppose this behavior disappears if I drop both table and reload the
t_stockchanges from the dump.
Thank you All.
Bye,
-- Csaba
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
