Lists: | pgsql-bugs |
---|
From: | "Alexander" <goal81(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #5489: SELECT ... RETURNING INTO ... in ecpg |
Date: | 2010-06-03 20:17:26 |
Message-ID: | 201006032017.o53KHQGJ038090@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 5489
Logged by: Alexander
Email address: goal81(at)gmail(dot)com
PostgreSQL version: 8.3.11
Operating system: CentOS 5.4
Description: SELECT ... RETURNING INTO ... in ecpg
Details:
I've been using PostgreSQL since version 8.2.
As I saw, ecpg preprocessor is unable to handle "SELECT ... RETURNING INTO
... " queries due to the following line in
src/interfaces/ecpg/preproc/preproc.y:
returning_clause: RETURNING target_list { $$ = ...
Changing this line to:
returning_clause: RETURNING target_list ecpg_into { $$ = ...
fixes this lack.
From: | Michael Meskes <meskes(at)postgresql(dot)org> |
---|---|
To: | Alexander <goal81(at)gmail(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #5489: SELECT ... RETURNING INTO ... in ecpg |
Date: | 2010-06-04 12:12:24 |
Message-ID: | 20100604121224.GA5596@feivel.credativ.lan |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
> As I saw, ecpg preprocessor is unable to handle "SELECT ... RETURNING INTO
> ... " queries due to the following line in
I take it you mean INSERT/DELETE/UPDATE and not SELECT right? And yes, those
results weren't moved into C space. I more or less applied your patch to 8.3,
8.4 and 9.0, so the next release will work as expected.
Thanks for spotting this.
Michael
--
Michael Meskes
Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
Michael at BorussiaFan dot De, Meskes at (Debian|Postgresql) dot Org
ICQ 179140304, AIM/Yahoo/Skype michaelmeskes, Jabber meskes(at)jabber(dot)org
VfL Borussia! Força Barça! Go SF 49ers! Use Debian GNU/Linux, PostgreSQL