Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jNXB2-000561-JG for pgsql-hackers@arkaria.postgresql.org; Sun, 12 Apr 2020 07:37:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jNXB1-0004ba-2j for pgsql-hackers@arkaria.postgresql.org; Sun, 12 Apr 2020 07:37:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jNXB0-0004bT-SS for pgsql-hackers@lists.postgresql.org; Sun, 12 Apr 2020 07:37:10 +0000 Received: from mout.kundenserver.de ([217.72.192.74]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jNXAv-0007co-56 for pgsql-hackers@postgresql.org; Sun, 12 Apr 2020 07:37:10 +0000 Received: from [192.168.178.43] ([77.190.248.78]) by mrelayeu.kundenserver.de (mreue109 [212.227.15.145]) with ESMTPSA (Nemesis) id 1Mdvyi-1iokNv0xJ0-00b3JS; Sun, 12 Apr 2020 09:36:53 +0200 Subject: Re: Add A Glossary To: Corey Huinker Cc: Alvaro Herrera , Erik Rijkers , Justin Pryzby , Roger Harkavy , pgsql-hackers@postgresql.org, Fabien COELHO , Michael Paquier References: <20200405190046.GA16787@alvherre.pgsql> <280f7b1e-2e81-5d0e-2589-b5ea6313ad74@purtz.de> From: =?UTF-8?Q?J=c3=bcrgen_Purtz?= Message-ID: Date: Sun, 12 Apr 2020 09:36:50 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.4.1 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------DB9E1DCC6FC13A3927149A20" Content-Language: en-US X-Provags-ID: V03:K1:jRyzMCIRFy2uDVFlvGoVKlbhGz7Z6A2P2EQhCxcds0YcKSQmhIi oC0cGPozvEqzE913nHEySlmzDLL4G+O6jV32PKPVYYUmsbB1FG73T7mf+WZXcn6LambPRVG BMkeDPIanmPJApOKTHtGXBhpDdiOEEbC26Pn1IRAXT9EadeMwhGJSOgmxpuFvH87q90KcUn R/Pz9SvoyDJG4nbzrc8Tw== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:aqDHMJpFM3o=:1I8oao1d0dKuvwcPwv6843 AzZxi06qd+3gCOowNsdutJjGiXomp8MvaYRuxDAYwMkEoBlJka+ullQvA4+ctyoihEn9LZFGV tQEmcTOyrXvIkDIkfXEfMcyp8UdLGEM8PceJIXwMCF9ilv/9PVfnmWE+URN37xUe4ZUtEGcVY NZAx1W9mcVXRtNzNVGKqzOuYq+QriL2HZclcgM/4mlnM+QDqeY3154KhaFaGEjFsIxr2bUny8 l5v4cn4e5juXmPTZwpxtewtUNQKjTW4JFBCS0O3dFAWNE/T4ENsSP/r2QXqb5uXTMTJdrNKrR BG7yFR0Wbwk68Lfbu/+iF0D4+teIuGCOi/hjvSWHlNBz/nvcdlOqCZeOypbDcGNVrIcLYyQs8 6FA35ra1pfXCxh7EyHjo7ecoNJfLfO9PusG0JqqMX3jDMjLs56oMusDQZWSbrXXFhiTPqbOgD PVGXyabkfJd1hTOTu5PPlbHVfnplCZr/De9U6A8/cXvTC+ytzmd0pw1uPqGMvU3e8jOgYOGZQ WaIR9zDeJ5mDFT/U0fYMF7XyIm8hF+OYF3k38YvNuopagTR19ffBjxdjSUUK8K4kyOfvftGMi 6CAwiocWBp7uTKo7n7dF+VT25luFvipcA4iF1ctzcMfaHa4/ZmAPXtsG3DpOm5ZVBUC8IG0ap X+fseltrZRC2pXlnp1YtvgfdEWnVBwfZmQpb2W7feOQUTyfutlYw7lOBeiqXHetY40rGpXPye UZi0Klti6nuqIxyDZO4gPY18RxLM9KUUxuJ4MMPrHVVkIjIyqXoJrKQSsHHd6cX89OOFoXqWD 91GFVXoegdCWCHxenN7XjzGxt9iiVERrM6RpolyPFoM6LN3S1Eg7aDoQb527BCzNnX9YCea List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------DB9E1DCC6FC13A3927149A20 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit On 11.04.20 21:47, Corey Huinker wrote: > > > Term 'relation': A sequence is internally a table with one row - > right? > Shall we extend the list of concrete relations by 'sequence'? Or > is this > not necessary because 'table' is already there? > > > I wrote one for sequence, it was a bit math-y for Alvaro's taste, so > we're going to try again. > This seems to be a misunderstanding. My question was whether we shall extend the definition of Relation to: "... Tables, views, foreign tables, materialized views, indexes, and *sequences* are all relations." Kind regards, Jürgen --------------DB9E1DCC6FC13A3927149A20 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit


On 11.04.20 21:47, Corey Huinker wrote:

Term 'relation': A sequence is internally a table with one row - right?
Shall we extend the list of concrete relations by 'sequence'? Or is this
not necessary because 'table' is already there?

I wrote one for sequence, it was a bit math-y for Alvaro's taste, so we're going to try again.

 

This seems to be a misunderstanding. My question was whether we shall extend the definition of Relation to: "... Tables, views, foreign tables, materialized views, indexes, and *sequences* are all relations."

Kind regards, Jürgen

--------------DB9E1DCC6FC13A3927149A20--