Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1e9xMW-0002V9-PU for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Nov 2017 18:03:36 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1e9xMV-0000Ig-Di for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Nov 2017 18:03:35 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1e9xMU-0000Ed-Gu for pgsql-hackers@postgresql.org; Wed, 01 Nov 2017 18:03:34 +0000 Received: from mail-pg0-x234.google.com ([2607:f8b0:400e:c05::234]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1e9xMS-0008Js-0A for pgsql-hackers@postgresql.org; Wed, 01 Nov 2017 18:03:33 +0000 Received: by mail-pg0-x234.google.com with SMTP id b192so2754823pga.2 for ; Wed, 01 Nov 2017 11:03:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=a4LWLNszKqyOmlZi1Tq7Ht/pt+N2sL4EmtuzZpTbk34=; b=TWHicFUAQfDou84m4F3UfMQGhq/PUTCSU7F96iKxpf47Z+VVWgJA6Hzb+teCqsKgUp +DvgwKNurIDY3AzrC0L8AfHDMBs3Z3amz2zzTdYxUzlCUEoLvkNeqiBz1VfnrusV/pJE aHLAQ7EPAuKUX3zRFYpNko74UrxDW2C6DerjhgHXsndD7U7Hylr4ZU/OvXQKIp+ktvKA TXmNLfG1M/x+Q5SbyI0IsoqCdrtUUSrBoeiIRMdosrzBoUiQs0LYgic03sAlwLzco7xL JqauX4pinruKaR6YdmjWIfnZHMCgkx2OhNB6U8pfgaNhRbO7YEeixEkkusV5Q4S4UjSf FcVQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=a4LWLNszKqyOmlZi1Tq7Ht/pt+N2sL4EmtuzZpTbk34=; b=suKekKZgX5yrmYVmmT757dI9jiG65NIaytq2O3WNWLWoKsJrdvJp1ew/vomrahxy4D cHLb5O9QXOKwExEXJfu7t0R8mlMzgwbrhoLkiqiyx1mvfLp8+bPfqejsQCqA6nszQqNK frXk/O3zyzOMrdmKqGuaOq/jv3RrJV11I35+3r8PMl4xXYe7Ys+6V1A4ddtFDCmhbYpG jY7qwK3DgqDdYmz0DU6yrrsdlIDTLy/KpJ/Dyg+0HqMGI+C7Q/8O14am4/0WzfgvH5i4 yJCsMp7qpd4SK0npOtuqBY+XXlq9K2YpaM6B7taO4NMBRPDSqwjwjir2PokEFnWlWndM ztqQ== X-Gm-Message-State: AMCzsaVE0hWHCTvaZ7s7S5+8XxZOiA10D9sgc6rOfT/LCJEPHpYZHkBQ lD6FEHJMNIktNzxdBKkTfRU= X-Google-Smtp-Source: ABhQp+TW5YJZ7UH06iAx9UK0TqGKz2/O1kRMdS4cZ1hOgRHnjWEUbzeCMr4mTqIr3NK/Bkc3dfpIPw== X-Received: by 10.99.1.81 with SMTP id 78mr661133pgb.99.1509559410646; Wed, 01 Nov 2017 11:03:30 -0700 (PDT) Received: from [192.168.2.121] ([172.92.45.130]) by smtp.gmail.com with ESMTPSA id p71sm2885657pfl.56.2017.11.01.11.03.29 (version=TLS1 cipher=ECDHE-RSA-AES128-SHA bits=128/128); Wed, 01 Nov 2017 11:03:30 -0700 (PDT) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 9.3 \(3124\)) Subject: Re: proposal: schema variables From: Mark Dilger In-Reply-To: Date: Wed, 1 Nov 2017 11:03:28 -0700 Cc: PostgreSQL Hackers Content-Transfer-Encoding: 7bit Message-Id: <58C95E69-F94E-46E0-98B5-8F52454B4403@gmail.com> References: To: Pavel Stehule X-Mailer: Apple Mail (2.3124) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org > Comments, notes? How would variables behave on transaction rollback? CREATE TEMP VARIABLE myvar; SET myvar := 1; BEGIN; SET myvar := 2; COMMIT; BEGIN; SET myvar := 3; ROLLBACK; SELECT myvar; How would variables behave when modified in a procedure that aborts rather than returning cleanly? mark -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers