That's what I tought the problem was, but I created a table afterwards without inheritence. Could it have something to do with the max size of the schema or oid's?
>-- Oorspronkelijk bericht -- >Date: Sat, 19 Mar 2005 14:55:50 -0800 (PST) >From: Stephan Szabo <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Cc: pgsql-general@postgresql.org >Subject: Re: [GENERAL] Question insert data > > >On Sat, 19 Mar 2005 [EMAIL PROTECTED] wrote: > >> 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. > >Define "based on". Do you mean CREATE TABLE AS or perhaps that the new >table inherits from the old one? If the latter, you will see the rows in >the parent as well as the child if you do a select from the parent. > >---------------------------(end of broadcast)--------------------------- >TIP 4: Don't 'kill -9' the postmaster _____________________________________________________________________ 12move ADSL vanaf 18,95 euro! GRATIS modem, GEEN aansluitkosten en GEEN datalimiet! Ga nu naar http://adsl.12move.nl ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings