Re: What does count(*) count? - Mailing list pgsql-general

From Együd Csaba
Subject Re: What does count(*) count?
Date
Msg-id 001001c3d05c$908cc8a0$230a0a0a@compaq
Whole thread Raw
In response to Re: What does count(*) count?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: Mnogosearch (Was: Re: website doc search is ... )
Next
From: Arjen van der Meijden
Date:
Subject: Re: Mnogosearch (Was: Re: website doc search is ... )