Message-ID: <4CA93C9B.7010201@gmx.net>
Date: Mon, 04 Oct 2010 04:31:55 +0200
From: Andreas <maps.on@gmx.net>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de;
	rv:1.9.2.9) Gecko/20100915 Thunderbird/3.1.4
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Re: Need magic for inserting in 2 tables
References: <4CA9004E.7060106@gmx.net>
	<AANLkTinibE8HA3nipALO_aGsgxYDACf0xokUiPJrq5bz@mail.gmail.com>
	<4CA9241E.9030709@gmx.net>
	<AANLkTi=8cS5ODYOauMFHdKfw=6iZnp8GYCMhmHpVvavm@mail.gmail.com>
In-Reply-To: <AANLkTi=8cS5ODYOauMFHdKfw=6iZnp8GYCMhmHpVvavm@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

  Am 04.10.2010 02:58, schrieb Scott Marlowe:
>
> The same way it would use the output of a select, it's a record set.
> So it's x rows by y columns.

Then where were my insert statements wrong?
Please, look this is a simple but complete example and show me my error.

create temporary table table_1 ( id_1 serial primary key, txt  text );
create temporary table table_2 as select 42::integer as id_2;
ALTER TABLE table_2 ADD CONSTRAINT t2_pkey PRIMARY KEY( id_2 );
create temporary table t1_t2 ( fk_1 integer references table_1 ( id_1 ), 
fk_2 integer references table_2 ( id_2 ) );

--  delete from table_1;

insert into t1_t2 ( fk_1, fk_2 )
     insert into table_1 ( txt )
     values ( 'A' ), ( 'B' ), ( 'C' )
     returning id_1, 42;

The inner insert works and dumps the inserted ids along with the 
constant which is needed in the outer insert as reference to the project.

Both inserts run together give an error.