Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1d4Az9-0000OG-Ri for pgsql-hackers@arkaria.postgresql.org; Fri, 28 Apr 2017 18:51:20 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1d4Az9-0006wj-5O for pgsql-hackers@arkaria.postgresql.org; Fri, 28 Apr 2017 18:51:19 +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 1d4Axb-0003Sv-U6 for pgsql-hackers@postgresql.org; Fri, 28 Apr 2017 18:49:44 +0000 Received: from out4-smtp.messagingengine.com ([66.111.4.28]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1d4AxZ-0003e9-Bv for pgsql-hackers@postgresql.org; Fri, 28 Apr 2017 18:49:42 +0000 Received: from compute7.internal (compute7.nyi.internal [10.202.2.47]) by mailout.nyi.internal (Postfix) with ESMTP id EA5D420B5F; Fri, 28 Apr 2017 14:49:39 -0400 (EDT) Received: from frontend1 ([10.202.2.160]) by compute7.internal (MEProxy); Fri, 28 Apr 2017 14:49:39 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-sender:x-me-sender:x-sasl-enc:x-sasl-enc; s= fm1; bh=wxhXerAkrZmgj0KD8+YzV83l0HVeB5fO5hgy1udCOUM=; b=qiM5lgMw 8GlZYCyivkVd/mZJ7obeSR2dnDhsNgTEmE2WbKcyoORAr5IiAkTKqo+j9dYTNcWt GZ/p3C9imh4t9eyH2afnLkJaUf/CSr7K5Pjf3BZTc6p+474BUE9N0lrEjzUvz4iH ZHZVB6qTSJDQPIOIUJ9NrGLl06V+4EdjFCX6wzcbydaSkg9HV8ES+1ySjg5lTCei YjzZjWeF06VGB+KfGxWVcACmPTYjG01595BkF/vKJKLCZqzisU7bA7kMpZQS6vmB bZVHrTBIlzwXNdjZDKyjj6QMHEuTaY7sNrWeNR6iGHReJ+Om8uEuEUZNeaW8gdqn cqFrIZEfd7qC0A== X-ME-Sender: X-Sasl-enc: RJFlBB2+SH8bBqpyCmTE5c/ovs/wBs34wJsDvnq/Hi0F 1493405379 Received: from april.local (c-73-13-66-39.hsd1.pa.comcast.net [73.13.66.39]) by mail.messagingengine.com (Postfix) with ESMTPA id A2C877E32F; Fri, 28 Apr 2017 14:49:39 -0400 (EDT) Subject: Re: identity columns To: Robert Haas References: <6adbacbf-73bc-dd1a-2033-63409180fd18@2ndquadrant.com> <4b1d703f-818f-00bf-4169-3279af377f3d@2ndquadrant.com> <59d8e32a-14de-6f45-c2b0-bb52e4a7522d@2ndquadrant.com> <21ab7425-ae33-b0af-4177-f2ba88acd93a@2ndquadrant.com> <7e8fafb2-1949-fd97-cb57-fb1a3fe0ed6e@2ndquadrant.com> <83f5d264-6d4a-01e0-a496-fcca7933c18b@2ndquadrant.com> <0334bd69-ab72-384a-684d-4595d761beea@2ndquadrant.com> Cc: Vitaly Burovoy , pgsql-hackers From: Peter Eisentraut Organization: 2ndQuadrant Message-ID: Date: Fri, 28 Apr 2017 14:49:39 -0400 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:45.0) Gecko/20100101 Thunderbird/45.8.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.6 (--) 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 4/27/17 16:10, Robert Haas wrote: > I still think you should consider improving the psql output, though. > Vitaly's examples upthread indicate that for a serial sequence, > there's psql output showing the linkage between the table and sequence > in both directions, but not when GENERATED is used. Can we get > something morally equivalent for the GENERATED case? Done. Good catch. -- Peter Eisentraut 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