Re: GSOC13 proposal - extend RETURNING syntax - Mailing list pgsql-hackers

From Karol Trzcionka
Subject Re: GSOC13 proposal - extend RETURNING syntax
Date
Msg-id 51EE332E.7070307@gmail.com
Whole thread Raw
In response to Re: GSOC13 proposal - extend RETURNING syntax  (David Fetter <david@fetter.org>)
List pgsql-hackers
W dniu 23.07.2013 06:22, David Fetter pisze:
> What problem or problems did you notice, and what did you change to
> fix them?
"UPDATE ... FROM" generated "ERROR:  variable not found in subplan
target lists". I've added some workaround in add_vars_to_targetlist:
- if it is an "after" - simple change var->varno to base RTE (it should
always exists, the value is temporary, it will change to OUTER_VAR)
- if it is a "before" - add to targetlist new var independently from
rel->attr_needed[attno].
Additionally I've change build_joinrel_tlist to ignore any "BEFORE"
RTEs. The regression tests are updated.
Regards,
Karol



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: anchovy failing on 9.1 and earlier since using gcc 4.8
Next
From: Sawada Masahiko
Date:
Subject: Re: Using ini file to setup replication