Re: INSERT ... ON CONFLICT {UPDATE | IGNORE}

From: Peter Geoghegan <pg(at)heroku(dot)com>
To: Craig Ringer <craig(at)2ndquadrant(dot)com>
Cc: Anssi Kääriäinen <anssi(dot)kaariainen(at)thl(dot)fi>, Robert Haas <robertmhaas(at)gmail(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, Josh Berkus <josh(at)agliodbs(dot)com>, Kevin Grittner <kgrittn(at)ymail(dot)com>, Andres Freund <andres(at)2ndquadrant(dot)com>, Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: INSERT ... ON CONFLICT {UPDATE | IGNORE}
Date: 2014-12-04 18:27:47
Message-ID: CAM3SWZSgGCBm-5YerVq++eF+X30+m7CR-SVr2rvK9zGnmBAJYw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Dec 4, 2014 at 3:04 AM, Craig Ringer <craig(at)2ndquadrant(dot)com> wrote:
> Yes, I think that's pretty important. With a negative attno so it's
> treated as a "hidden" col that must be explicitly named to be shown and
> won't be confused with user columns.

I think that the standard for adding a new system attribute ought to
be enormous. The only case where a new one was added post-Postgres95
was "tableoid". I'm pretty sure that others aren't going to want to do
it that way. Besides, I'm not entirely convinced that this is actually
an important distinction to expose.

--
Peter Geoghegan

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2014-12-04 18:56:12 Re: SSL regression test suite
Previous Message Andres Freund 2014-12-04 18:01:29 Re: Sequence Access Method WIP