Hi There,
I've a problem with inserting data and I can't figure out what the problem
is:
what did I do:
1. I've a master table containing about 40000 records. A count(*) provides
me the exact number.
2. I've create a table based on from the master. I copied a fraction from
the master into the new table using a where clause (insert into ... select
* from ... where a = b . The number of records copied is about 2553.
Issueing the same select statement on the master table gives me a list of
5106 which is twice the number of copied records.
Did someone have this problem before?
I'm using 8.0 Windows XP en the pgAdmin III , r1.2.0
I even tried the same on the command line!
thanks,
Peter
_____________________________________________________________________
12move ADSL vanaf 18,95 euro! GRATIS modem, GEEN aansluitkosten en GEEN datalimiet!
Ga nu naar http://adsl.12move.nl