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
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 PROT
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
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,
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 the
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
>To: [EMAIL PROTECTED]
>Cc: pgsql-general@postgresql.org
>Subject: Re: [GENERAL] codepage setting, \encoding
>Reply-To: Martijn van Oosterho
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?
ch
