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 1h7zVY-0002KC-Oi for pgsql-hackers@arkaria.postgresql.org; Sun, 24 Mar 2019 09:33:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h7zVX-0005RB-Dx for pgsql-hackers@arkaria.postgresql.org; Sun, 24 Mar 2019 09:33:35 +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 1h7zVW-0005OT-WF for pgsql-hackers@lists.postgresql.org; Sun, 24 Mar 2019 09:33:35 +0000 Received: from mail-wm1-x333.google.com ([2a00:1450:4864:20::333]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h7zVU-0006Fv-Gp for pgsql-hackers@lists.postgresql.org; Sun, 24 Mar 2019 09:33:33 +0000 Received: by mail-wm1-x333.google.com with SMTP id h18so6040189wml.1 for ; Sun, 24 Mar 2019 02:33:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=XXeNAgMrS6jVM2506pYw4E8Yi6nWJUBlje/AeOfV4aA=; b=k1ZO0fo47TUhlklE9vDxpbqX4prK1r7m1J/YgPfZzmTDTJO++eo3RIDpblqT9IGvW4 o5ldIr1/4q9A+i3VJf1FvCH//ZRRcMWv/BiVhRJxhwMx69hCwdKdwDgGFeaHQGeWSOpB Li7Q3JP3M4/6U+dE/lZOuT0/a4dYB3FOQnKcB3SEbyze8CfHo60vLIPsJgbvvfQMpjrg o8s6Ub+wuwtF7PqHRgnahT6rJeLBIc8KS97N6JTqwmjnGe7HyK2UO+qjftcSgSiH4xXK qdswBdLc5JB3buAQj0bfhp9pUzf6L8cwKAhk/maCC6/+Dd3IUzjXWyx7S7PqhiRCvlbn EUCw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=XXeNAgMrS6jVM2506pYw4E8Yi6nWJUBlje/AeOfV4aA=; b=B2oh70Q9pBLWX6+cB6iKhgeBD5h7roKHczmLc6ima+bvWstKG+e+/R7gQDv3xvz/qG PA/UzDPc3pXKh85BR0awr3cT7/68o6wV5tv4b8oEfz5X1XDy+Uv2gu4vFJ9RoP+QNA5H nR5hIeP+jmJ6zxsN9INims8PYAHczj/0V8pWBfEIgb/07OTgWjKP2rhh/+eRRK/IQnjb 313eWuMKp0DKWqAT61zsHQqMfedbOjA5s3e1I0PsgmVFeCg78wtzLkzI6A4QZtLJnW1p HZ6iJuhQFr+S89Vxohep5mBFrpCPx9QfFbn4WLQztS/+j+IXZvycIEw/8cXF0T2fxEqE m9aA== X-Gm-Message-State: APjAAAXLoGyN8AjDg/hx18I3kABaHg7+yjSmqd0zL+F8w1l/QatA7wxj kNlYIIWgMyOMA6g7abIsbeik6o3Qqg7WU3wzd5A= X-Google-Smtp-Source: APXvYqy7ew5/ZUe4pJrPmqgt9pJBDXjYRj/QzqSByYc5qmU10lBAIlOiC9nK+YWLkxHoOu3l1ZINi/vvp82dw+M6lYM= X-Received: by 2002:a1c:4844:: with SMTP id v65mr942739wma.139.1553420010221; Sun, 24 Mar 2019 02:33:30 -0700 (PDT) MIME-Version: 1.0 References: <20180919112305.GA18604@zakirov.localdomain> In-Reply-To: From: Pavel Stehule Date: Sun, 24 Mar 2019 10:32:53 +0100 Message-ID: Subject: Re: [HACKERS] proposal: schema variables To: Erik Rijkers Cc: Artur Zakirov , Dean Rasheed , Fabien COELHO , Gilles Darold , PostgreSQL Hackers Content-Type: multipart/alternative; boundary="000000000000e577280584d3c72e" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000e577280584d3c72e Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable ne 24. 3. 2019 v 10:25 odes=C3=ADlatel Erik Rijkers napsal: > 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) > I cannot to reproduce it. please, try compilation with "make distclean"; configure .. or if the problem persists, please send test case, or backtrace Regards Pavel > > > thanks, > > Erik Rijkers > > > --000000000000e577280584d3c72e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


=
ne 24. 3. 2019 v=C2=A010:25 odes=C3= =ADlatel Erik Rijkers <er@xs4all.nl&= gt; napsal:
On 2= 019-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:=C2=A0 schema "varschema2" does not exist
create variable if not exists testv as text;
server closed the connection unexpectedly
=C2=A0 =C2=A0 =C2=A0 =C2=A0 This probably means the server terminated abnor= mally
=C2=A0 =C2=A0 =C2=A0 =C2=A0 before or while processing the request.
connection to server was lost


(both statements are needed to force the crash)

I cannot to reproduce it.

please, try com= pilation with "make distclean"; configure ..

=
or if the problem persists, please send test case, or backtrace
<= div>
Regards

Pavel


thanks,

Erik Rijkers


--000000000000e577280584d3c72e--