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 1h1oY5-0003nd-Bg for pgsql-hackers@arkaria.postgresql.org; Thu, 07 Mar 2019 08:38:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h1oY3-0001Uz-Ah for pgsql-hackers@arkaria.postgresql.org; Thu, 07 Mar 2019 08:38:39 +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 1h1oY2-0001Ur-UM for pgsql-hackers@lists.postgresql.org; Thu, 07 Mar 2019 08:38:39 +0000 Received: from mail-wr1-x42f.google.com ([2a00:1450:4864:20::42f]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h1oY0-0004Fa-Ml for pgsql-hackers@lists.postgresql.org; Thu, 07 Mar 2019 08:38:37 +0000 Received: by mail-wr1-x42f.google.com with SMTP id d17so16359785wre.10 for ; Thu, 07 Mar 2019 00:38:36 -0800 (PST) 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=t9zLS/2lOdXg5i2hd4+S7MxW3hGpKFCZZGJJW632M9Y=; b=aSjtTDW123/WdoMkpZvh6kiL+wF3toJ1ZTk/Q47Z8ZG9IZ9ZV+89jQNspE0JyxvA2v z8PhC6KjbXRgN4SW8dNk1QFjk6c2LjNLDmhNR4kUsTe5zGVEBp/ZP3ftYPK+/VOvCdij uztlt63SNNkSfrBCAuPcN/jtLPQ5UqoyZBjORfjrHLpcJeXEQX83pPjiQ6zP7k6q4nML DCDcYsrHCJdWGn5cdkQOr1vMzDG9FeA2KuezWbAgJglVhjngMGqLgAzHhDcVg51FLdog 85RAGm8S/jO4YCjMc91EgBK9z44xhVm2aD8xYH+0EDL39RLI5FdoeoT/Du1sHdhoFHav 3hQw== 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=t9zLS/2lOdXg5i2hd4+S7MxW3hGpKFCZZGJJW632M9Y=; b=F+uVaPNniFaPAuieRRoSS1BScGjYxTfxpfy8dS/oc/wgd/7LqjwhU5302hukvGdEC0 WnhOERp95TS8VfveEhgvkaVZfT6LBG7oClxA2ROef1GCpONfRHG1HVEecexPHFFWTDHQ hbjhlXS6F4/hI8oIcD4wopblgyjb1jP0UO6WeFWqHQCwrNQnCI/noIf6ne0vLRaugm7G 6X5zc6pzUaGW2scmBPOWgRlxtXnxe9ftvlSGgqNLJL2eL/YOZCQMiEqEUKKh7M7ajhHy k1ZI21N0u9j5j4RYavZ1UPnHIJ1cWoBc6ynG3hd6tJfUwShrj4LRy+ksgrvY9tRSIXxA dG7g== X-Gm-Message-State: APjAAAUiDzvA0uFpX7W2bR7Gv8EY7Vq3rRpGZqQ10wwSFQnxQceXP49d FvOO2EmCBL7ryfmHud076DIubxJ39BBPdjVn6PM= X-Google-Smtp-Source: APXvYqzWahO0oKoyTgjGkrvPQPRh28DWss2d3n6iZEF5Y3lmEhHtO6NLh68b24VFa8WNcgUI9HKxUUhnWo1VhWQjJJo= X-Received: by 2002:adf:ef05:: with SMTP id e5mr6103842wro.153.1551947914843; Thu, 07 Mar 2019 00:38:34 -0800 (PST) MIME-Version: 1.0 References: <20180919112305.GA18604@zakirov.localdomain> In-Reply-To: From: Pavel Stehule Date: Thu, 7 Mar 2019 09:37:58 +0100 Message-ID: Subject: Re: Re: [HACKERS] proposal: schema variables To: Fabien COELHO Cc: David Steele , Artur Zakirov , Dean Rasheed , Gilles Darold , PostgreSQL Hackers , Peter Eisentraut Content-Type: multipart/alternative; boundary="0000000000002c9a9705837d08ad" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --0000000000002c9a9705837d08ad Content-Type: text/plain; charset="UTF-8" Hi >> My strong opinion based on the underlying use case is that it that such >> session variables should be transactional by default, and Pavel strong >> opinion is that they should not, to be closer to Oracle comparable >> feature. > > It is closer to any known database Oracle, DB2, Firebird, MSSQL, MySQL, Regards Pavel --0000000000002c9a9705837d08ad Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi


My strong opinion based on the underlying use case is that it that such session variables should be transactional by default, and Pavel strong
opinion is that they should not, to be closer to Oracle comparable
feature.

It is closer t= o any known database Oracle, DB2, Firebird, MSSQL, MySQL,

Regards

Pavel
<= /div> --0000000000002c9a9705837d08ad--