On 2014-09-30 14:57:43 -0700, Josh Berkus wrote: > Regardless, I don't think there's any theoretical way to support UPSERT > without a unique constraint.
You can do stuff like blocking predicate locking. But without indexes to support it that gets awfully complicated and unfunny. I don't think we want to go there. So essentially I agree with that statement. Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers