Re: [HACKERS] proposal: schema variables

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>
Cc: Artur Zakirov <a(dot)zakirov(at)postgrespro(dot)ru>, Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>, Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>, Gilles Darold <gilles(dot)darold(at)dalibo(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: [HACKERS] proposal: schema variables
Date: 2018-10-05 01:34:14
Message-ID: CAFj8pRCTbd2PrwcTd7hj-bctsVD1E5cpke_Z27k-vcgwGvLvLw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-hackers

st 3. 10. 2018 v 1:01 odesílatel Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>
napsal:

> On Sun, Sep 30, 2018 at 11:20 AM Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
> wrote:
> > I hope so now, there are almost complete functionality. Please, check it.
>
> Hi Pavel,
>
> FYI there is a regression test failure on Windows:
>
> plpgsql ... FAILED
>
> *** 4071,4077 ****
> end;
> $$ language plpgsql;
> select stacked_diagnostics_test();
> - NOTICE: sqlstate: 22012, message: division by zero, context:
> [PL/pgSQL function zero_divide() line 4 at RETURN <- SQL statement
> "SELECT zero_divide()" <- PL/pgSQL function stacked_diagnostics_test()
> line 6 at PERFORM]
> + NOTICE: sqlstate: 42702, message: column reference "v" is ambiguous,
> context: [PL/pgSQL function zero_divide() line 4 at RETURN <- SQL
> statement "SELECT zero_divide()" <- PL/pgSQL function
> stacked_diagnostics_test() line 6 at PERFORM]
>
> https://ci.appveyor.com/project/postgresql-cfbot/postgresql/build/1.0.15234

please, check attached patch

Thank you for report

Pavel

>
> --
> Thomas Munro
> http://www.enterprisedb.com
>

Attachment Content-Type Size
schema-variables-20181004-02.patch.gz application/gzip 65.7 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Langote 2018-10-05 02:06:29 Re: executor relation handling
Previous Message Michael Paquier 2018-10-05 01:26:45 TAP tests for pg_verify_checksums