Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h7zO5-0001yM-U3 for pgsql-hackers@arkaria.postgresql.org; Sun, 24 Mar 2019 09:25:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h7zO2-0000Ud-SI for pgsql-hackers@arkaria.postgresql.org; Sun, 24 Mar 2019 09:25:50 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h7zO2-0000UW-Ha for pgsql-hackers@lists.postgresql.org; Sun, 24 Mar 2019 09:25:50 +0000 Received: from lb1-smtp-cloud8.xs4all.net ([194.109.24.21]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h7zNv-000632-GY for pgsql-hackers@lists.postgresql.org; Sun, 24 Mar 2019 09:25:49 +0000 Received: from webmailclassic.xs4all.nl ([IPv6:2001:888:0:22:194:109:20:214]) by smtp-cloud8.xs4all.net with ESMTPA id 7zNqhrVFLUjKf7zNqheOIh; Sun, 24 Mar 2019 10:25:40 +0100 Received: from [185.220.101.67] by webmailclassic.xs4all.nl with HTTP (HTTP/1.1 POST); Sun, 24 Mar 2019 10:25:38 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit Date: Sun, 24 Mar 2019 10:25:38 +0100 From: Erik Rijkers To: Pavel Stehule Cc: Artur Zakirov , Dean Rasheed , Fabien COELHO , Gilles Darold , PostgreSQL Hackers Subject: Re: [HACKERS] proposal: schema variables In-Reply-To: References: <20180919112305.GA18604@zakirov.localdomain> Message-ID: X-Sender: er@xs4all.nl User-Agent: XS4ALL Webmail X-CMAE-Envelope: MS4wfOQ6iklHb02CRryHN9lGZKGj/C7AHmPHTtdJNliIaXcwIAx4AmW0sSVPu8gQdKgSAhVh1/aZY+nUnYhNxTgVqI4ZhVrLwoe2y5wJjkISDD47P5Da8+cI 5f540GdMcA/UhhtPwf5lnWuezTsCd44YOW5CozkT/OAXIjU15LyP7dODQuPO4Ph+06qjvAcxN+0gVrjo7PDUTMbth6yafAS2xiyLUsIBzEJy5gLhGcYR1KEi ujMevcRHs3HcapkZrNIym/U6DAwtutMUAi2ISt8hJyxnb/7KngtvBkVYJAj9DXQoaM06N8iusZakWHRZsA7+K2CVlwcqV5H/2Tdv4HzGJuvqpwmxeNXhi4KQ FsCDaQVdRMQ8csKHW2h7ityTve5avIAWjzs0RkMaZKq4WtsoBbg3aAnLfRs+Gl0TDnDdrjF0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2019-03-24 06:57, Pavel Stehule wrote: > Hi > > rebase against current master > I ran into this: (schema 'varschema2' does not exist): drop variable varschema2.testv cascade; ERROR: schema "varschema2" does not exist create variable if not exists testv as text; server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. connection to server was lost (both statements are needed to force the crash) thanks, Erik Rijkers