Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-hackers-owner+M273687=pgsql-hackers-arkari@postgresql.org>)
 id 1YvC2N-0006yX-Kr
 for pgsql-hackers@arkaria.postgresql.org; Wed, 20 May 2015 22:00:27 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-hackers-owner+M273687=pgsql-hackers-arkari@postgresql.org>)
 id 1YvC2M-00069b-UH
 for pgsql-hackers@arkaria.postgresql.org; Wed, 20 May 2015 22:00:26 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
 by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <andres@anarazel.de>) id 1YvC2K-00066k-JP
 for pgsql-hackers@postgresql.org; Wed, 20 May 2015 22:00:24 +0000
Received: from mail.anarazel.de ([217.115.131.40])
 by makus.postgresql.org with esmtp (Exim 4.84)
 (envelope-from <andres@anarazel.de>) id 1YvC2I-0004vg-7B
 for pgsql-hackers@postgresql.org; Wed, 20 May 2015 22:00:23 +0000
Received: from intern.anarazel.de (unknown [184.23.178.130])
 (Authenticated sender: andres@anarazel.de)
 by mail.anarazel.de (Postfix) with ESMTPSA id 95BE1860001;
 Thu, 21 May 2015 00:00:20 +0200 (CEST)
Date: Thu, 21 May 2015 00:00:17 +0200
From: Andres Freund <andres@anarazel.de>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: pgsql-hackers@postgresql.org
Subject: Re: [COMMITTERS] pgsql: Add support for INSERT ... ON CONFLICT DO
 NOTHING/UPDATE.
Message-ID: <20150520220017.GS27868@alap3.anarazel.de>
References: <E1YqZCW-0000e6-Od@gemulon.postgresql.org>
 <20150520215816.GI5885@postgresql.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20150520215816.GI5885@postgresql.org>
X-Pg-Spam-Score: -4.2 (----)
List-Archive: <http://archives.postgresql.org/pgsql-hackers>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-hackers.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@postgresql.org>
List-Post: <mailto:pgsql-hackers@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-hackers>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
X-Mailing-List: pgsql-hackers
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org

On 2015-05-20 18:58:16 -0300, Alvaro Herrera wrote:
> Andres Freund wrote:
> > Add support for INSERT ... ON CONFLICT DO NOTHING/UPDATE.
> 
> Hm, I just realized that the command tag for INSERT ON CONFLICT is still
> just INSERT.  Is that okay?  To me, the behavior is different enough
> that it should have its own tag.  I'm not too set on this, but maybe
> others share this opinion?

It's actually INSERT for DO NOTHING, and UPSERT for DO UPDATE. It's even
documented ;)

Andres


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers