Betr: Re: Question insert data

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 <sszabo(at)megazone(dot)bigpanda(dot)com>
>To: perico(at)12move(dot)nl
>Cc: pgsql-general(at)postgresql(dot)org
>Subject: Re: [GENERAL] Question insert data
>
>
>On Sat, 19 Mar 2005 perico(at)12move(dot)nl 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