4908*2=9816
2 inserts on the same line in the dmp file?
Erwan
>>> Együd Csaba <csegyud@vnet.hu> 31/12/2003 09:58:25 >>>
Hi all,
I tried to dump out a single table and just for a verification I counted the
number of 'INERT INTO' rows.
I found that count(*) results less rows than grep.
*******************
Csaba@compaq ~
$ pg_dump -d -t t_stockchanges alumil6 > sc.dump
*******************
alumil6=# select count(*) from t_stockchanges ;
count
-------
9816
(1 row)
*******************
Csaba@compaq ~
$ cat sc.dump | grep 'INSERT INTO' | wc -l
4908
*******************
What can be the reason of it?
Thx,
-- 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