Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1d0MIu-0007zt-96 for pgsql-hackers@arkaria.postgresql.org; Tue, 18 Apr 2017 06:07:56 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1d0MIt-0002is-PQ for pgsql-hackers@arkaria.postgresql.org; Tue, 18 Apr 2017 06:07:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1d0MIs-0002hD-Ap for pgsql-hackers@postgresql.org; Tue, 18 Apr 2017 06:07:54 +0000 Received: from mail-pg0-x22a.google.com ([2607:f8b0:400e:c05::22a]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1d0MIo-0002rf-I5 for pgsql-hackers@postgresql.org; Tue, 18 Apr 2017 06:07:53 +0000 Received: by mail-pg0-x22a.google.com with SMTP id 63so22617783pgh.0 for ; Mon, 17 Apr 2017 23:07:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=leadboat.com; s=google; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=MT/WGjfn3SuGeUMxcaaOgJQf9aqPdl95Ngqbl8wtl4Q=; b=KGDVZdQqr1NIS1cwG1M0JYV+qjP0ZrNcXE4oSmgdgVTDKc8gPOheiozZ5xGUrRrzCf yTYBs3/ErtUq+XhN18nq421iXAMDddIuygtxzi0RrXB8/UN0yMfOjwuWUJglEH7oTsMV 1hegxDpnq3ZknRTcf9i9y35BiLMsr84/BDjCw= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=MT/WGjfn3SuGeUMxcaaOgJQf9aqPdl95Ngqbl8wtl4Q=; b=fqTCBzSj2lTjlw3P0Wq0qaCac6ZvfgQ1dTwrkbzCpKurrahlujPMr/VJaKBv8q+bb0 bhDLtpgIpGFzU/f2XbSV3728Garfu9WMzZzLyfXCo0klZYlDR5g7sanI1DYG324WkZVS 94mQqBuLQ5Wy/clcQ9e4+IJ/wrSXxceLjLK1U40LsPMnok3Kql7t9nHZDThWDLx5wp/x bjbLJWibqFiwOJQHa6Q9QKHO5WVTVeRoyWx/4yd5TFTqxHmeXdEunjEIp08s0xMmfbXf QXbvPrFob9RML4l4eoZ6l+XYjfXGvhqvyDwGpxxVsrLGELFpfXSSt0s9I8kNb7i931Ph seqw== X-Gm-Message-State: AN3rC/5ha5sny6JUlWBhzKoEEdo/5jPgbsENMkCYVov43oum2Unyo7Jq E0/dfY+InXqE3ZzBoqQ= X-Received: by 10.99.167.15 with SMTP id d15mr15871917pgf.69.1492495668190; Mon, 17 Apr 2017 23:07:48 -0700 (PDT) Received: from rfd.leadboat.com (c-98-248-47-228.hsd1.ca.comcast.net. [98.248.47.228]) by smtp.gmail.com with ESMTPSA id g7sm9115616pfe.6.2017.04.17.23.07.46 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 17 Apr 2017 23:07:47 -0700 (PDT) Date: Mon, 17 Apr 2017 23:07:44 -0700 From: Noah Misch To: Peter Eisentraut Cc: Vitaly Burovoy , pgsql-hackers Subject: Re: identity columns Message-ID: <20170418060744.GA123688@rfd.leadboat.com> References: <06a416db-e35b-36d1-7e2f-0affdee24745@2ndquadrant.com> <4b1d703f-818f-00bf-4169-3279af377f3d@2ndquadrant.com> <59d8e32a-14de-6f45-c2b0-bb52e4a7522d@2ndquadrant.com> <21ab7425-ae33-b0af-4177-f2ba88acd93a@2ndquadrant.com> <20170414055644.GF2870454@tornado.leadboat.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20170414055644.GF2870454@tornado.leadboat.com> User-Agent: Mutt/1.5.24 (2015-08-30) X-Pg-Spam-Score: -2.0 (--) 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 On Fri, Apr 14, 2017 at 05:56:44AM +0000, Noah Misch wrote: > On Thu, Apr 06, 2017 at 10:26:16PM -0700, Vitaly Burovoy wrote: > > On 4/6/17, Peter Eisentraut wrote: > > > On 4/4/17 22:53, Vitaly Burovoy wrote: > > >> The next nitpickings to the last patch. I try to get places with > > >> lacking of variables' initialization. > > >> All other things seem good for me now. I'll continue to review the > > >> patch while you're fixing the current notes. > > > > > > Committed with your changes (see below) as well as executor fix. > > > > Thank you very much! > > > > > > > As I tried to mention earlier, it is very difficult to implement the IF > > > NOT EXISTS behavior here, because we need to run the commands the create > > > the sequence before we know whether we will need it. > > > > In fact with the function "get_attidentity" it is not so hard. Please, > > find the patch attached. > > I've implement SET GENERATED ... IF NOT EXISTS. It must be placed > > before other SET options but fortunately it conforms with the > > standard. > > Since that form always changes the sequence behind the column, I > > decided to explicitly write "[NO] CACHE" in pg_dump. > > > > As a plus now it is possible to rename the sequence behind the column > > by specifying SEQUENCE NAME in SET GENERATED. > > > > I hope it is still possible to get rid of the "ADD GENERATED" syntax. > > [Action required within three days. This is a generic notification.] > > The above-described topic is currently a PostgreSQL 10 open item. Peter, > since you committed the patch believed to have created it, you own this open > item. If some other commit is more relevant or if this does not belong as a > v10 open item, please let us know. Otherwise, please observe the policy on > open item ownership[1] and send a status update within three calendar days of > this message. Include a date for your subsequent status update. Testers may > discover new open items at any time, and I want to plan to get them all fixed > well in advance of shipping v10. Consequently, I will appreciate your efforts > toward speedy resolution. Thanks. > > [1] https://www.postgresql.org/message-id/20170404140717.GA2675809%40tornado.leadboat.com This PostgreSQL 10 open item is past due for your status update. Kindly send a status update within 24 hours, and include a date for your subsequent status update. Refer to the policy on open item ownership: https://www.postgresql.org/message-id/20170404140717.GA2675809%40tornado.leadboat.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers