Missing table from in INSERT RETURNING

From: Rémi Cura <remi(dot)cura(at)gmail(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Missing table from in INSERT RETURNING
Date: 2015-02-17 16:18:46
Message-ID: CAJvUf_v0G+8MzG8Dp7v7iizh00wb6gDCDZQmBY6jTPjhQRUohQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello dear list,
I would appreciate some help on a small matter that has been bothering me
for a long time :

CREATE TABLE test_insert_returning(
gid SERIAL
,some_value int
);
WITH serie AS (
select s, s*10 as computing
from generate_series(1,10) as s
)
INSERT INTO test_insert_returning (some_value)
SELECT computing
FROM serie
RETURNING gid, serie.s

doesn't work.

The only workaround I found was to create a plpgsql function that doesan
idnividual insert
so that :
WITH serie AS (
select s, s*10 as computing
from generate_series(1,10) as s
)
SELECT serie.s, my_inserting_function(computing)
FROM serie ;

But it is very annoying and potentially bad for performance because many
insert may be fired.

Any solution?
(postgres 9.3)
Cheers,
Rémi-C

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel LaMotte 2015-02-17 16:43:30 Re: Issue dumping schema using readonly user
Previous Message Adrian Klaver 2015-02-17 15:25:14 Re: Issue dumping schema using readonly user