Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dELFe-0000kY-86 for pgsql-hackers@arkaria.postgresql.org; Fri, 26 May 2017 19:50:22 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dELFd-0006IX-Qw for pgsql-hackers@arkaria.postgresql.org; Fri, 26 May 2017 19:50:21 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dELFd-0006H9-42 for pgsql-hackers@postgresql.org; Fri, 26 May 2017 19:50:21 +0000 Received: from mail-wr0-x22d.google.com ([2a00:1450:400c:c0c::22d]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dELFa-0007Xm-A1 for pgsql-hackers@postgresql.org; Fri, 26 May 2017 19:50:19 +0000 Received: by mail-wr0-x22d.google.com with SMTP id l50so7141854wrc.3 for ; Fri, 26 May 2017 12:50:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=subject:to:cc:references:from:organization:message-id:date :user-agent:mime-version:in-reply-to:content-language :content-transfer-encoding; bh=imJr1TgPXhod7uxAc/mnfZaEvxi9YQnNxEPATUtpE+g=; b=TcLqBgFz7hptuTgkBocgkosEZUYDndz/znMeU59OKo8iWuziIhRzi9NVnvcu/AS5KA ymE1VeOv8aOC8NTWB0Q6v1+8E9q2lIt+Grtjk5UxVepHnEvh4Pm7xofYLwEjy65fl6qs iuvpZfFoWCF/sat2GtY/XnUhjqUfmjkxYcGm19KSTwG0B0wl+uklauCOtODO+huPlDHf xkFX6ONz4wWQwwrDvlne9aYa+xzph0RU5W5nlnNGPq1qcT70lr22/6OjZWWoVandGW+E 4lcAWo6LMXQOWh85s144cxbYRTeTFJm9bJ3OAN3OczkdaeZAOxSztsavweMgr3VmTtE9 RfKw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:cc:references:from:organization :message-id:date:user-agent:mime-version:in-reply-to :content-language:content-transfer-encoding; bh=imJr1TgPXhod7uxAc/mnfZaEvxi9YQnNxEPATUtpE+g=; b=WTnalOZncVJvXjjLEe3NeNwZrGIhKIMfuBWuyTAaS93cXPTYLOP5vTGByV4LWPeJI7 JLHtvBveegGI0K11+C4PZiFKHV0qZacA/DueGjR4CBBN3C+cjU+Xibu6j5XLiA91PMZb aelWVZS5JsftzqQ5PGrnNOZ+0LtjlHjRzE4tvM5oKEF8GxsOxVe6cSdltK1b+UwnwrLt ckD/DpOL16Z8caiS+EKMuKOAY7U8XNPPWA2zjxPL/iQ/WjuYnpnqd0GttGqb/iM0pvAN Gke7BkRfjAxw8E/i9dBaP5IupUNX4n+WH6YUgNpnSnuhY9LZnN6NYCQ4zgP0/y8aIG8M 3k8Q== X-Gm-Message-State: AODbwcDSKPW3wxMVXIhW6o+j8LmHLiWFcvUegXR9jJRUgD2Sy1UDbyhW mC3aKskTgKh8Zpz3UFjSJ7ut1Z3MAKrdNhup0vIqjV8NC69cPvm50qKI5fKewDIUUDypkAKYo+J hFgXHGSGUThUDDyCiyt4z0/8CDOnBwsk3iP/tEgsOt/AhBS2oUnULIhuGNNiHe1pfeyva8EmNNn Cn X-Received: by 10.223.172.226 with SMTP id o89mr3038363wrc.157.1495828215504; Fri, 26 May 2017 12:50:15 -0700 (PDT) Received: from [10.85.10.250] ([104.222.149.130]) by smtp.gmail.com with ESMTPSA id y6sm1894453wrc.51.2017.05.26.12.50.14 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Fri, 26 May 2017 12:50:15 -0700 (PDT) Subject: Re: Renaming a table to an array's autogenerated name To: Tom Lane Cc: PostgreSQL-development References: <0f4ade49-4f0b-a9a3-c120-7589f01d1eb8@2ndquadrant.com> <29404.1495747497@sss.pgh.pa.us> <08811d08-4369-11a5-68a7-ac3482655461@2ndquadrant.com> <67129.1495826446@sss.pgh.pa.us> From: Vik Fearing Organization: 2ndQuadrant France Message-ID: Date: Fri, 26 May 2017 15:50:12 -0400 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.1.1 MIME-Version: 1.0 In-Reply-To: <67129.1495826446@sss.pgh.pa.us> Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: 7bit 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 On 05/26/2017 03:20 PM, Tom Lane wrote: > Vik Fearing writes: >> On 05/25/2017 05:24 PM, Tom Lane wrote: >>> After some experimentation, I came up with the attached, which simply >>> skips the "recursive" step if it would apply to the same array type we >>> already moved. > >> This looks good to me. > > Pushed, thanks for reviewing. Thanks! -- Vik Fearing +33 6 46 75 15 36 http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers