On 12/17/2014 01:12 PM, Heikki Linnakangas wrote:
> 3. Why is the specification required with ON CONFLICT UPDATE, but not
> with ON CONFLICT IGNORE?
Well, UPDATE has to know which row to lock, no? IGNORE does not.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com