As per discussion on -hackers, a patch which allows updates to use
subselects is attached with this mail.
As per discussion with Tom, I have adopted the following approach:
* Introduce ROWEXPR_SUBLINK type for subqueries that allows multiple column
* Populate the targetList with PARAM_SUBLINK entries dependent on the
* Modify the targets in-place into PARAM_EXEC entries in the make_subplan
The above does not require any kluges in the targetList processing code path
UPDATEs seem to work fine using subselects with this patch. I have modified
the update.sql regression test to include possible variations .
No documentation changes are present in this patch.
Feedback, comments appreciated.
pgsql-patches by date
|Next:||From: Tom Lane||Date: 2007-04-11 14:11:33|
|Subject: Re: [HACKERS] Fix mdsync never-ending loop problem |
|Previous:||From: Pavan Deolasee||Date: 2007-04-11 08:13:43|
|Subject: Re: [HACKERS] CIC and deadlocks|