Re: INSERT ... ON CONFLICT UPDATE/IGNORE 4.0
| От | Andres Freund |
|---|---|
| Тема | Re: INSERT ... ON CONFLICT UPDATE/IGNORE 4.0 |
| Дата | |
| Msg-id | 20150508180636.GR12950@alap3.anarazel.de обсуждение исходный текст |
| Ответ на | Re: INSERT ... ON CONFLICT UPDATE/IGNORE 4.0 (Heikki Linnakangas <hlinnaka@iki.fi>) |
| Ответы |
Re: INSERT ... ON CONFLICT UPDATE/IGNORE 4.0
|
| Список | pgsql-hackers |
On 2015-05-08 20:37:15 +0300, Heikki Linnakangas wrote: > Why does INSERT ON CONFLICT pay attention to indcheckxmin? Uniqueness check > only cares about the most recent committed version of the tuple, and the > index good for that use immediately. If there was a problem there, the > uniqueness check in a normal insert have the same problem. Yea, that's a good angle to view this from. That'd not be the case, I think, if we'd allow this to be used on system relations. But since neither creating an index on system relations, nor using INSERT ON CONFLICT on them is supported... Greetings, Andres Freund
В списке pgsql-hackers по дате отправления: