Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tYuLv-00GLZM-OO for pgsql-hackers@arkaria.postgresql.org; Fri, 17 Jan 2025 21:58:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tYtw8-006iag-FF for pgsql-hackers@arkaria.postgresql.org; Fri, 17 Jan 2025 21:31:28 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tYtw8-006iaW-0J for pgsql-hackers@lists.postgresql.org; Fri, 17 Jan 2025 21:31:28 +0000 Received: from mail-ed1-x533.google.com ([2a00:1450:4864:20::533]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tYtw5-0005X7-11 for pgsql-hackers@lists.postgresql.org; Fri, 17 Jan 2025 21:31:27 +0000 Received: by mail-ed1-x533.google.com with SMTP id 4fb4d7f45d1cf-5d3f57582a2so7413784a12.1 for ; Fri, 17 Jan 2025 13:31:25 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=f10-com-br.20230601.gappssmtp.com; s=20230601; t=1737149484; x=1737754284; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=RBK8PVtYrkX5J49V32XT3cz8UB0FrO7uvNEbeiVF4Cc=; b=JXBUPywgrl9j7cZiCpa+9SXgZMnvaOJEYWvYUpAJLGLbMwcMLLUNOZ9veXVDBVKyK7 8RzOX7IeBIEXwU9KdXnVICGD27O90b0IV5rz5YBjfptKVM4co54Sn+4f0WeY+YuOpEno D2V8ddsk2E2CS2QJUu1+67ESCghnckRP82jCsQn7XInOMcO35WLAgmoH/Fi/fFacApN3 qqtSh3OpzRFlSBDUpxYVZyJP9+BUl+J8jQiw9N+6cu85BMMvnyNifqSLNI3vudhWvn9Y ZRajgMeu7KghcdD2aAbNKguqoq6wD0qrvcXE52Se/LMN7/nuQgqQfStjnDMGqHzr54uL ANoA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1737149484; x=1737754284; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=RBK8PVtYrkX5J49V32XT3cz8UB0FrO7uvNEbeiVF4Cc=; b=RPrj/XBET/0EfsJLxWvxOBTvhMLR4nhqOcYyGI2+tXiR+5Jj+++8+9BeS+FF0k4yfN V6z7Np3KTFMCy6biGrj+00G8N6JoRTKFabaEmxh7x1tPBb8RG/j1L5Eaa9n3jvBkPaUD tvnkqCqdmejoEc+IcUUsNYg4n6ktl8oe+LlXYQSYQVg5HriMijl4AmYF0l7VO7m42jQy Pz1j4esD++PGb5ZLt1MM5cJ6mll2l+srYFvnTEDfwJflVcC8Vz8sCUq/QxGVvJei/HRp urP3j+bGbleAgD/jgvbjktJsZjUZi8aIFnbfFzd2TiOS8qepsX2JacBAVwLWsmZqsipC uplA== X-Forwarded-Encrypted: i=1; AJvYcCUde8jc7SZqQ7DVJdDx6x7IL5PqpIXXQKIadndtPnht7E2GoPFi+ts40APoTsFiWrxGoDXJeEdr+FtFD3CF@lists.postgresql.org X-Gm-Message-State: AOJu0Yx+JbgCvfERKZ9SVDr3+cuMGZGAjYXjFECwLrMwn0iyUjAOQ+pd e6+zre6kBFzbBOgdvKyxpGv0IlcxOi73Jtm5B86Uipxd091soi4KGB/lwzik2Zr00NVn1Vbgpv6 J4FMpA0KIhG9zU19HOY2CUgl4Ndu4dkqMD5EZ X-Gm-Gg: ASbGncupIn+Ta5SXQ4oTPhI0JWHZgArM4d4tECmiyzwSMMXzsxU5MxwA+vy0Vu/rnIv 3607/Dn4IjYJhiUDOQn0MstwhKv1W7+JvFjTigyMU X-Google-Smtp-Source: AGHT+IFucFLVPnlA95fh1/RH1OoOyE/rIwMIkAJpUB+hinRLu0dbKJVVGpKxTMIdzxfHq5qP56XWh+uIryZ7fdLC7Xw= X-Received: by 2002:a17:907:96a5:b0:aab:a02c:764e with SMTP id a640c23a62f3a-ab36e2bcaafmr619682466b.14.1737149484393; Fri, 17 Jan 2025 13:31:24 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Marcos Pegoraro Date: Fri, 17 Jan 2025 18:30:40 -0300 X-Gm-Features: AbW1kvZyqzETLugLGZf5gk4anLVfnbbmSc8TDYh6l2mAUaVxv0NjjZ47EEih3I0 Message-ID: Subject: Re: Fwd: Re: proposal: schema variables To: Bruce Momjian Cc: Pavel Stehule , PostgreSQL Hackers Content-Type: multipart/alternative; boundary="000000000000f08590062beda199" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000f08590062beda199 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable > > > p=C3=A1 17. 1. 2025 v 16:35 odes=C3=ADlatel Bruce Momjian > napsal: > > Okay, good summary. Now, can people give feedback that they would want > this committed to PostgreSQL? > I would love to have this functionality as soon as possible. I already mentioned to Pavel that he did something very big, and consequently difficult for anyone to commit, because these patches change a lot of things in a lot of places. Of course we want as much as possible, but who knows if a first, leaner version was committed, with just session variables, so nothing related to schemas, catalogs, grants, dumps, etc, just a variable in memory, only that. It would be really cool, and certainly easier for a committer to agree with the code. And if the first commit occurs, others can follow. Remember that some people don't use PSQL, so they don't have \set Even \set variables are not typed, so CREATE VARIABLE T AS DOMAIN_NUMBER_BETWEEN_1_AND_5 is really cool. regards Marcos --000000000000f08590062beda199 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
> p=C3=A1 17. 1. 2025 v=C2=A016= :35 odes=C3=ADlatel Bruce Momjian <bruce@momjian.us> napsal:

Okay, good summary.=C2=A0 Now, can people give feedback that they would wan= t
this committed to PostgreSQL?

I would love to have this functionality as soon as possible.= =C2=A0
I already mentioned to Pavel that he did something very big, and conseque= ntly difficult for anyone to commit, because these patches=C2= =A0change a lot of things in a lot of places.
Of course we want = as much as possible, but who knows if a first, leaner version was committed, with just session variabl= es, so nothing related to schemas,= catalogs, grants,=C2=A0 dumps, etc, just a variable in memory, only that.= =C2=A0It would be really cool, and certa= inly easier for a committer to agree with the code. And if the first commit= occurs, others can follow.

Remember that so= me people don't use PSQL, so they don't have \set
Even \set variables are not typed, so CREATE VARIABLE T AS DOMAIN_N= UMBER_BETWEEN_1_AND_5 is really cool.

regards
Marcos
--000000000000f08590062beda199--