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
On Sun, 20 Mar 2005 [EMAIL PROTECTED] wrote:
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?
I can't think of a reason it would, so can you send a self-contained
full
PROTECTED]
Cc: pgsql-general@postgresql.org
Subject: Re: Betr: Re: [GENERAL] Question insert data
On Sun, 20 Mar 2005 [EMAIL PROTECTED] wrote:
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
insert into master_nl
select * from master where substr(loc,1,2) = 'NL'
-- Oorspronkelijk bericht --
Subject: Re: [GENERAL] Question insert data
From: Ragnar Hafstað [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Date: Sat, 19 Mar 2005 17:56:52 +
On Sat,
Some more info
select count(*) from master_bart where substr(locode_c5,1,2) = 'NL'
gives me the result: 5106
delete from masterplts_nl;
insert into masterplts_nl
select * from master_bart where substr(locode_c5,1,2) = 'NL';
Query returned successfully: 2553 rows affected, 5127 ms execution
