Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Yxbyo-0007CK-SR for pgsql-hackers@arkaria.postgresql.org; Wed, 27 May 2015 14:06:46 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Yxbyn-0001oD-IK for pgsql-hackers@arkaria.postgresql.org; Wed, 27 May 2015 14:06:45 +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 ) id 1Yxbym-0001o7-5M for pgsql-hackers@postgresql.org; Wed, 27 May 2015 14:06:44 +0000 Received: from smtprelay0169.b.hostedemail.com ([64.98.42.169] helo=smtprelay.b.hostedemail.com) by makus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1Yxbyg-0001qW-VI for pgsql-hackers@postgresql.org; Wed, 27 May 2015 14:06:42 +0000 Received: from filter.hostedemail.com (10.5.19.248.rfc1918.com [10.5.19.248]) by smtprelay03.b.hostedemail.com (Postfix) with ESMTP id B577F1A701E; Wed, 27 May 2015 14:06:27 +0000 (UTC) X-Session-Marker: 616C76686572726540616C76682E6E6F2D69702E6F7267 X-Spam-Summary: 50, 0, 0, , d41d8cd98f00b204, alvherre@alvh.no-ip.org, :::::::::, RULES_HIT:41:355:379:599:967:973:988:989:1260:1263:1277:1311:1312:1313:1314:1345:1359:1437:1515:1516:1518:1519:1534:1538:1568:1593:1594:1595:1596:1711:1714:1730:1747:1777:1792:2198:2199:2393:2525:2560:2563:2682:2685:2828:2859:2895:2933:2937:2939:2942:2945:2947:2951:2954:3022:3138:3139:3140:3141:3142:3865:3867:3868:3871:3874:3934:3936:3938:3941:3944:3947:3950:3953:3956:3959:4250:4605:4659:5007:6261:9025:9121:10004:10400:10848:11232:11256:11257:11658:11914:12517:12519:13069:13161:13229:13255:13311:13357:13894:13895:21080:21088, 0, RBL:none, CacheIP:none, Bayesian:0.5, 0.5, 0.5, Netcheck:none, DomainCache:0, MSF:not bulk, SPF:fn, MSBL:0, DNSBL:none, Custom_rules:0:0:0 X-HE-Tag: trip18_55625a4e1e125 X-Filterd-Recvd-Size: 2060 Received: from alvin.alvh.no-ip.org (unknown [181.43.8.18]) (Authenticated sender: alvherre@alvh.no-ip.org) by omf11.b.hostedemail.com (Postfix) with ESMTPA; Wed, 27 May 2015 14:06:26 +0000 (UTC) Received: by alvin.alvh.no-ip.org (Postfix, from userid 1000) id 625F3528; Wed, 27 May 2015 11:06:24 -0300 (CLT) Date: Wed, 27 May 2015 11:06:24 -0300 From: Alvaro Herrera To: Simon Riggs Cc: Andres Freund , Tom Lane , Peter Geoghegan , Pg Hackers Subject: Re: Re: [COMMITTERS] pgsql: Add support for INSERT ... ON CONFLICT DO NOTHING/UPDATE. Message-ID: <20150527140624.GB5885@postgresql.org> References: <20150520215816.GI5885@postgresql.org> <20150520220911.GK5885@postgresql.org> <20150521011229.GX27868@alap3.anarazel.de> <10660.1432171328@sss.pgh.pa.us> <20150521013059.GY27868@alap3.anarazel.de> <20150521232841.GO5885@postgresql.org> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.5.23 (2014-03-12) X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org Simon Riggs wrote: > What I think should happen is that the command tag should vary according to > whether an INSERT or an UPDATE was performed, so we get a visible > difference without any new tags. The problem with doing that is that the same command might have updated some tuples and inserted others. Also, we build the tag before the command is executed. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, 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