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.96) (envelope-from ) id 1w6A7v-004146-0U for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Mar 2026 16:33:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w6A7t-00Alxy-2H for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Mar 2026 16:33:38 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w69yY-00Ah53-32 for pgsql-hackers@lists.postgresql.org; Fri, 27 Mar 2026 16:23:59 +0000 Received: from mail-dl1-x122a.google.com ([2607:f8b0:4864:20::122a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w69yX-00000001LUK-1qHE for pgsql-hackers@lists.postgresql.org; Fri, 27 Mar 2026 16:23:58 +0000 Received: by mail-dl1-x122a.google.com with SMTP id a92af1059eb24-12a80c36350so2700594c88.1 for ; Fri, 27 Mar 2026 09:23:57 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774628636; cv=none; d=google.com; s=arc-20240605; b=eCewYAJfxp/A6eLvQbly4uOr/9Mtr35XZlNKVXmZTz0cqHcA7hvrL8owTstgHjLAoa iUi7EwWywi5mspkAOd1Y8vVO3iE/e/XOiPecciskxRfaf0lnYV/DvoLMd4sumCPj5XYj fEnkLvnbj8ZHNJQKeivm5k9BWgbrTp4ea+w5UyOUXP3afDvGcMeg8D+mrEydyfRo5ipX ijTnhow51fCMmNr9T3CK8W/1RlGsHXsFIdk2eUZiXsn2rgynwVIqPhZA5XXucOluBRn9 861hkh0kg4vWCHnaAiM6z2xszDBYE4KMwZ52fG/MDdceqYHmVP3g8aF690ZlnrOL1x+9 jfPg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:from:mime-version:dkim-signature; bh=QcLXUDdG12yrlpjb5verkjM6ppkXBV/Wj6oO/ra2XRU=; fh=nwNxTtLLPTU0ewfLM7SSbrjMajMl+wwnFkCY/fi90vE=; b=GqVHDcM7Q9sTo2pz1B8RELTCQFONh+WVuNwe5BSVLdeEwYDcZnjyHNwL3sjXhs8k7e W44BY7mPtwYlvM5vtu4j/OLhgXpvR4m81DPsw78xXA70LXoasaJM7Xc2S2jCBuv97msw texxBsC0zdz1eRj0ouawbaTBF4DiXX31SJgfeT41BgqaunjgAuEFI1ziwpYMhygbb3Rp AcnWHUS5PyvzNlPWWQbrYKCgbFZWZZqtahQ5Mg5Rg+lepLx4MgKliaCF0obU4JmGUUNX zMzGe8zpqUl8M8EcnDthGF9nGlXb2jJfAeWN5Pn/RYSaxMW7c8tzl7KWg4wUdiWbBA8D Bv2A==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=datadoghq.com; s=google; t=1774628636; x=1775233436; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=QcLXUDdG12yrlpjb5verkjM6ppkXBV/Wj6oO/ra2XRU=; b=dYwYjfv2zxWiyFhk4PQHZgkcLhbjmSjmfHtipL7Wgq0E79UkgDXadZcxLvHH2nWdFc FGCyK/Sh4H94Nqldz8BUJmSaw9XAfycQ8+DC1ktQPTCL2oPTew8coQ9zx+4Qys3upI0J LoxVIk8nTufwB9ddJbr26lTq7Vipd2QxDKXX0= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774628636; x=1775233436; h=to:subject:message-id:date:from:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=QcLXUDdG12yrlpjb5verkjM6ppkXBV/Wj6oO/ra2XRU=; b=L7HQaMsQ1hYSDgb92qZ86MplZVLKD2v6x9R1ZNZ8D1QGZ27ZxJiBTpelXIniiSScAI hp/069jr3mDkSgMhB9NjjS6dPhLDEgPxx2SijsxwZkj3r2lBFNVO76TrwfFRIhemlh9z +9of+3fl3CtZCTbiFJoLIF4FE5BTGAYKXcoUawq6faNWqr/mmtscUrGoutDQ2u2xSxYU zxFVogcJ7WkQ+iWSwbienodEKhpEpD5TWTlLIM37mxAw1QwWDj27XFs5aSvST0pOZ68J sOvUgWe9T/3KZDAzK9j3bJFZPYuuGIrBNqcvy7LrDc+tHvWTl64cc2iPdbLv4ss/d4uj Og+Q== X-Gm-Message-State: AOJu0YybmycIVpImgW5SCvYaCdYgbCZKGCLnJ1WnNkF18d2ZSBlKg2Vq 9CL5KRtwtiyubeb32RYaFxZbMWa+2+vfJ3nkGZZsGLDRBJTpx7Ino0lKNdLpq6nq7aAwu9YU+0Q NjTfGYh25Wq2Vv8j7KvG1peW9qEKDd46SOgGrvMifvJTxvQLUPsN9PNo= X-Gm-Gg: ATEYQzyzhqh+m/aQl/OJJ8yV/oJOq/iY3snDh4kswIatyqq/K/98ofCQUbHK+tc3/PY b0nD66L1UnNsiHXLvlA2i0Yj9n1J7jFLFgXq5gNpWJ+mHHygSZ2ponHs0ROegAzxKDvVDL5vBml DUvJIbDC8CTA7uR3RvfUzmp5mIp27UKPdYUiok2uZJiiWiaYGsEIovv1towHHv9Eh3PJXICjKm3 U9D+I6kZBUwfxD5YtEdo4pW76t6bUJr+TrMyZXZwwZzdCPnjAE6DkOFPRSr0pKUNwg7aXNLBopd uam4sDcMUw== X-Received: by 2002:a05:7022:6707:b0:12a:949b:c46 with SMTP id a92af1059eb24-12ab28e9ac6mr1626804c88.21.1774628635242; Fri, 27 Mar 2026 09:23:55 -0700 (PDT) MIME-Version: 1.0 From: =?UTF-8?B?w4FsdmFybyBSb2Ryw61ndWV6?= Date: Fri, 27 Mar 2026 17:23:43 +0100 X-Gm-Features: AQROBzABwnW0_aO_HS0lF9IWPmX0TVzHx7QdWhoSwQbEt8RUpkU5iNwGdfMYx1A Message-ID: Subject: Update documentation for SET to include SCHEMA / NAMES syntax To: pgsql-hackers@lists.postgresql.org Content-Type: multipart/mixed; boundary="0000000000006a1f35064e03eddd" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000006a1f35064e03eddd Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi, The attached patch updates the documentation for the SET statement to include the special syntax for SCHEMA / NAMES in the synopsis. The current documentation only mentions this special syntax under the parameters, which is confusing and different from the usual practice. We could consider also moving the description on the special syntax up to the description instead of keeping it under parameters, but the TIME ZONE variant is already explained under the parameters too so I thought better to keep the current structure. Thanks, =C3=81lvaro Rodr=C3=ADguez --0000000000006a1f35064e03eddd Content-Type: application/octet-stream; name="v1-0001-Update-the-SET-statement-documentation-for-clarit.patch" Content-Disposition: attachment; filename="v1-0001-Update-the-SET-statement-documentation-for-clarit.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_mn9400oc0 RnJvbSA1YjY3MWU1NGRhNTNmMzY3N2VlMDdjZjk3NjkxOTZhZTRlZmFiMjQwIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiA9P1VURi04P3E/PUMzPTgxbHZhcm89MjBSb2RyPUMzPUFEZ3Vl ej89CiA8YWx2YXJvcm9kcmlndWV6LmdhcmNpYUBkYXRhZG9naHEuY29tPgpEYXRlOiBUaHUsIDI2 IE1hciAyMDI2IDE3OjU2OjE3ICswMTAwClN1YmplY3Q6IFtQQVRDSCB2MSAxLzFdIFVwZGF0ZSB0 aGUgU0VUIHN0YXRlbWVudCBkb2N1bWVudGF0aW9uIGZvciBjbGFyaXR5CiB3aGVuIHVzaW5nIFND SEVNQSBhbmQgTkFNRVMKCkFkZGVkIGEgbmV3IHZhcmlhbnQgdG8gdGhlIFNFVCBzdGF0ZW1lbnQg dG8gaW5jbHVkZSB0aGUgc3BlY2lhbCBzeW50YXggZm9yIFNFVCBTQ0hFTUEgYW5kIFNFVCBOQU1F Uy4KLS0tCiBkb2Mvc3JjL3NnbWwvcmVmL3NldC5zZ21sIHwgMSArCiAxIGZpbGUgY2hhbmdlZCwg MSBpbnNlcnRpb24oKykKCmRpZmYgLS1naXQgYS9kb2Mvc3JjL3NnbWwvcmVmL3NldC5zZ21sIGIv ZG9jL3NyYy9zZ21sL3JlZi9zZXQuc2dtbAppbmRleCAxNmM3ZTlhN2IyNi4uNjM4NDNhNmI4NWMg MTAwNjQ0Ci0tLSBhL2RvYy9zcmMvc2dtbC9yZWYvc2V0LnNnbWwKKysrIGIvZG9jL3NyYy9zZ21s L3JlZi9zZXQuc2dtbApAQCAtMjIsNiArMjIsNyBAQCBQb3N0Z3JlU1FMIGRvY3VtZW50YXRpb24K ICA8cmVmc3lub3BzaXNkaXY+CiA8c3lub3BzaXM+CiBTRVQgWyBTRVNTSU9OIHwgTE9DQUwgXSA8 cmVwbGFjZWFibGUgY2xhc3M9InBhcmFtZXRlciI+Y29uZmlndXJhdGlvbl9wYXJhbWV0ZXI8L3Jl cGxhY2VhYmxlPiB7IFRPIHwgPSB9IHsgPHJlcGxhY2VhYmxlIGNsYXNzPSJwYXJhbWV0ZXIiPnZh bHVlPC9yZXBsYWNlYWJsZT4gWywgLi4uXSB8IERFRkFVTFQgfQorU0VUIFsgU0VTU0lPTiB8IExP Q0FMIF0gWyBTQ0hFTUEgfCBOQU1FUyBdIHsgJzxyZXBsYWNlYWJsZSBjbGFzcz0icGFyYW1ldGVy Ij52YWx1ZTwvcmVwbGFjZWFibGU+JyB9CiBTRVQgWyBTRVNTSU9OIHwgTE9DQUwgXSBUSU1FIFpP TkUgeyA8cmVwbGFjZWFibGUgY2xhc3M9InBhcmFtZXRlciI+dmFsdWU8L3JlcGxhY2VhYmxlPiB8 IExPQ0FMIHwgREVGQVVMVCB9CiA8L3N5bm9wc2lzPgogIDwvcmVmc3lub3BzaXNkaXY+Ci0tIAoy LjUyLjAKCg== --0000000000006a1f35064e03eddd--