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
Hi Stephan,
I figured out what happened:
The master table contained duplicates, but the insert statement seems to
be very smart by selecting just the unique ones.
Peter
-- Oorspronkelijk bericht --
Date: Sun, 20 Mar 2005 01:46:19 -0800 (PST)
From: Stephan Szabo [EMAIL PROTECTED]
To: [EMAIL
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 4 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
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
Hi,
I'm using postgres 8.0 and I'm collecting data from many countries. So I've
some slovakian data and i can't get properly into my table (COPY command).
I've tried many codepage settings but none of those seem to support the special
characters. Does someone know which codepage I shoud use?
I'm using ISO-8859-5 so should I change this to unicode?
-- Oorspronkelijk bericht --
Date: Tue, 1 Feb 2005 22:35:11 +0100
From: Martijn van Oosterhout kleptog@svana.org
To: [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] codepage setting, \encoding
Reply-To: Martijn