From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Josh Berkus <josh(at)agliodbs(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: RETURNING and DO INSTEAD ... Intentional or not? |
Date: | 2007-09-14 18:50:58 |
Message-ID: | 200709141850.l8EIowT27390@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Josh Berkus wrote:
> All,
>
> > I'll note that we currently prevent adding RETURNING to a *conditional* DO
> > INSTEAD rule. This means that if we have a conditional DO INSTEAD rule
> > which inserts into a different table than the final unconditional rule,
> > we'll be RETURNING wrong or empty values. Mind you, that's a pretty
> > extreme corner case.
>
> FYI, after some tinkering around, I've found that RETURNING is 100%
> incompatible with any table which has conditional DO INSTEAD rules; there's
> just no way to make it work and return any intelligible data. This would be
> a completely corner case, except that people use conditional DO INSTEAD rules
> heavily with partitioning (and yes, real users are complaining).
>
> I don't see this as super-urgent to fix for 8.3, but can we put it up as a
> TODO?
>
> -- Make it possible to use RETURNING together with conditional DO INSTEAD
> rules, such as for partitioning setups.
Added to TODO:
* Make it possible to use RETURNING together with conditional DO INSTEAD
rules, such as for partitioning setups
http://archives.postgresql.org/pgsql-hackers/2007-09/msg00577.php
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
From | Date | Subject | |
---|---|---|---|
Next Message | Stefan Kaltenbrunner | 2007-09-14 18:59:22 | Re: PL/TCL Patch to prevent postgres from becoming multithreaded |
Previous Message | Tom Lane | 2007-09-14 18:26:28 | Re: 8.3 version of ts_headline |