Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g7TgA-0004sR-GZ for pgsql-hackers@arkaria.postgresql.org; Tue, 02 Oct 2018 23:02:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g7Tg8-0007eA-L0 for pgsql-hackers@arkaria.postgresql.org; Tue, 02 Oct 2018 23:02:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g7Tg8-0007dJ-E1 for pgsql-hackers@lists.postgresql.org; Tue, 02 Oct 2018 23:02:08 +0000 Received: from mail-wr1-x443.google.com ([2a00:1450:4864:20::443]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1g7Tg0-0004S5-Rb for pgsql-hackers@lists.postgresql.org; Tue, 02 Oct 2018 23:02:07 +0000 Received: by mail-wr1-x443.google.com with SMTP id g15-v6so1376211wru.9 for ; Tue, 02 Oct 2018 16:02:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=tJ0MYzyNPnuWpk2TVfc3d0zgfKaxSIxwg5wILiaCaDs=; b=VjDWU4jMVYPqJOBh6GiXPp5z+OL26bbobmKF2NYr9/P4mrZYoq8JPm7vgWro5u6FWU SCU5mQ+nDI9otwyQZGIOzZeYiNyXsz9M2Z3oq8pUSblE3vG5sh38zKV2Bk7wAAbU4Sl1 puMGv5ENMvgygjBxIlFbCc3Qgl/q87sWdQX+VRl9YwkJx918xiQiqjstU96VaIrn4Z0+ m92empYXU8+EUBwkE9mk12JgaXWwcsTNMleZPGt3V7pxQM9EXQ1JUM9uIvAYnXInPv+v MOMxW03PjV5HzxNjxZVQQdD5PMjEUy/dl3Y9r+85SiYlGtPIKrmcRnsN84dW+dMw4ln8 AMFA== 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=tJ0MYzyNPnuWpk2TVfc3d0zgfKaxSIxwg5wILiaCaDs=; b=Z6nWjcT6/1Lj20t/JKpowvi7ygegxs1Ef6Uha6slgrrgJHhENmP1sphJ7teL1mF5fZ IDqUkv8+6bSU8m1H+NPXh1WnsYrnhmijdz7e3E18TXjxWjfrwCoBew8n13rieQUTL7Mq 8QmxTgbiArqejWfj3sG6CDKm9DErGdVmC3k7QZicmTKYfTzBXOomQzntk0eLM9n3rys3 ZbhvRyVxq2hXEANBOekY0sfIs/qHHd/yxJhfwGirFZaA9vThyl2GaLYCVdccZUueGtao QTmHnDtyiojuZ8nT4VnSc1KuHp0DRBtvToKbfTRmU7aGyjxIlGIbSpOjbMz+T6SkkYEg G8tw== X-Gm-Message-State: ABuFfogjNofQ9LiEpTvAneV9hdGYhyOSTLyjec13B/FxOi8o5D14Ik2m C5n+P/V7eWwCLZKeRoFwCFdfrdCq1PjTWkYQsJbAIw== X-Google-Smtp-Source: ACcGV61tf8k9wWbAZ3aKsXjKwGwiYGSNuSCT1xrkGGwAHV7TuCsOz92AV3tMFUvlR5rfFJy9Oubn1s22H1xqfWx+GQ0= X-Received: by 2002:adf:b211:: with SMTP id u17-v6mr6749651wra.180.1538521319346; Tue, 02 Oct 2018 16:01:59 -0700 (PDT) MIME-Version: 1.0 References: <20180919112305.GA18604@zakirov.localdomain> In-Reply-To: From: Thomas Munro Date: Wed, 3 Oct 2018 12:01:22 +1300 Message-ID: Subject: Re: [HACKERS] proposal: schema variables To: Pavel Stehule Cc: Arthur Zakirov , Dean Rasheed , Fabien COELHO , gilles.darold@dalibo.com, PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Sun, Sep 30, 2018 at 11:20 AM Pavel Stehule 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 -- Thomas Munro http://www.enterprisedb.com