Re: BUG #16140: View with INSERT, DO INSTEAD, and ON CONFLICT causes an error
Peter Geoghegan <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.bugs |
|---|---|
| Message-ID | <CAH2-Wzmfmx_YpAEFGS1rhG_-hdkGfO0yx0hZhxYD0+ww3A5RZA@mail.gmail.com> |
On Thu, Nov 28, 2019 at 10:26 AM Tom Lane <[email protected]> wrote: > You should have written "EXCLUDED.value" not "NEW.value". There is > a bug here, but it's that the parser accepted this rule. I'm guessing > that the parsing logic for ON CONFLICT didn't consider the possibility > that NEW and OLD for a rule would already be in the range table. I must admit that I have zero recollection of this aspect of the ON CONFLICT work. Do you think that this would be difficult to fix? -- Peter Geoghegan