Betr: Re: [GENERAL] Question insert data

2005-03-20 Thread perico
] 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 4 records

Re: Betr: Re: [GENERAL] Question insert data

2005-03-20 Thread Stephan Szabo
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

Betr: Re: Betr: Re: [GENERAL] Question insert data

2005-03-20 Thread perico
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

Re: [GENERAL] Question insert data

2005-03-20 Thread Marcin Piotr Grondecki
Dnia Sat, Mar 19, 2005 at 06:36:27PM +0100, [EMAIL PROTECTED] napisal(a/o): 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 new table using a where

[GENERAL] Question insert data

2005-03-19 Thread perico
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

Re: [GENERAL] Question insert data

2005-03-19 Thread Ragnar Hafstað
On Sat, 2005-03-19 at 18:36 +0100, [EMAIL PROTECTED] wrote: 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. Issueing the

Betr: Re: [GENERAL] Question insert data

2005-03-19 Thread perico
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, 2005-03

Betr: Re: [GENERAL] Question insert data

2005-03-19 Thread perico
time. -- 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, 2005-03-19 at 18:36 +0100, [EMAIL PROTECTED] wrote: 2. I've create a table

Re: [GENERAL] Question insert data

2005-03-19 Thread Stephan Szabo
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 4 records. A count(*) provides me the exact number. 2. I've create a table based on from