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 1w6jyy-004bV2-1G for pgsql-hackers@arkaria.postgresql.org; Sun, 29 Mar 2026 06:50:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w6jyv-00Fqfz-0x for pgsql-hackers@arkaria.postgresql.org; Sun, 29 Mar 2026 06:50:45 +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 1w6jyv-00Fqfp-00 for pgsql-hackers@lists.postgresql.org; Sun, 29 Mar 2026 06:50:45 +0000 Received: from mail-lj1-x22f.google.com ([2a00:1450:4864:20::22f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w6jyt-00000001bhn-2pWw for pgsql-hackers@lists.postgresql.org; Sun, 29 Mar 2026 06:50:44 +0000 Received: by mail-lj1-x22f.google.com with SMTP id 38308e7fff4ca-38bd15d82bdso25194261fa.2 for ; Sat, 28 Mar 2026 23:50:43 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774767040; cv=none; d=google.com; s=arc-20240605; b=Y1WQ/6nVZkTE2NCMA0NyTo9rvVGRxt1LWOBFiWCmV/gl4MLrv8WkPW2J5GS9MgMgKq duSNNLbPjd854l5JLs4qX42RnuGmoBPsiJSIqFpYRR+X9vckTy/y7XyBxgNQizBQCbfN 7Gc1NDFUYH3dskYX3Bl1sTI1v3R6ICeQQiJDquDAgM6RWQz7LflIXK/xmZTRvqREAQkM AoVkHnjCCX4D2Nu9J7XCOIHu44oxv5li1r6n2GjaOhhEPMLk1Px+iUzPI+Nv14PThJq9 d0UbB2r0FhODULwya51Rlcol9JQhzO8HjqGTsYewEVDncNBDZWDA8wsrSxHX6oVZYQ2J JJMQ== 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=UbO0tmZKJW0mLZ/+Y/jYqtnQoL09OQpmjmUDhYztXtE=; fh=nwNxTtLLPTU0ewfLM7SSbrjMajMl+wwnFkCY/fi90vE=; b=Z3RcGzHJkt3q1oM9zSn6FstXapXN/cLgkR7tXhYfwkx4sEW28KlisMuP4iOnmjrj4R 7QgsJiNQLB6Nvuc+aNm86d/vMAMmADRXV7/rb/2WgzTQEesXJ6+voXPFXoeCbmqIgZ70 Cj5SgvDbhOAt9BqsS6Y2BPVm9HaT2mtu30RKj9iKf98vCERfd6hiFvr1ysqk4yZHEHJj kGWvuOtfC5ud3nGwGK082nvM6fS9xBdYgL1noBgSgPCvKeVfY0ibT/5yaqo7HvjbhT2z irSv6EVIDSwvcRV4siyvqqtQC8rqozmWGQq/rNr5bzJ2X8tlciIHXmbWJiEX5zyAm/wl iCfw==; 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=gmail.com; s=20251104; t=1774767040; x=1775371840; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=UbO0tmZKJW0mLZ/+Y/jYqtnQoL09OQpmjmUDhYztXtE=; b=SgB24yBsaoU4aZLMBEjR5q/8zB1N+yNoy6SkbYvBiw/qEcAnMJYgNn+NzsGjlSqhJo 0uIb13xge1uZvnMdfB9GSAYtZUBrXUSXg/4EFCw5M9iMVnGyXv8r+zesyC+EK+u7CKou bTzzewAdVyZw+P6OOUQsFnw3dgyqpu2qr7xdjcHFVoBonhnl4nfFFVFL2QUdcFHD/Q3N id/bqPt1dcoCy0vh63IEabVbs2M/3Au1Ie3oZjENFhy76Nj/VnsDw+EfSUlwjYybXmQr lQXcjQCFAV7WcHk9kiYTEISrWO/+IZbANKFm9paNcpmlUd6zcl8XF5Vuot8F2cC4EgkQ voAw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774767040; x=1775371840; 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=UbO0tmZKJW0mLZ/+Y/jYqtnQoL09OQpmjmUDhYztXtE=; b=MwFmf3Qzzs7Dp++Ju24TQseL7zubZ+0jkhemGVtIxdyvmwt3N5IvijgTyVkR6FWMvn ZV8ShwzPjN/+ifisZPylwy9LNK6GKUqGXFGcr020LoCdAhUCZDx1dWnBIc1LLUFS99ho G17YCh30MCb2S8JLBOU9JLpDvyPi+jZ27D1YMgN/4SXjEMGD+mElHS1xz1flnDZJNF58 geM5QSoAfjsxrjydPiD02BlY8ewordPRVef6zc2LI8j4m2FqZoWEZkv/FQfMdcwSHRTJ Qdeb4NGu+0eQ7vfZ3d8CBwb0t30KHFE2w60Xgnkyajr77m3o2HkfIAK2d9Wuh8WY4mxq ViCg== X-Gm-Message-State: AOJu0Yw0BZNEoOq1NqaymHmhL0s0Gp7bS+i8S6mZ7BjOOba61daMt006 MM+tfCxKZmjGStXEdeJcjWYKEFw28fmd5gkplrCrJqV3EdmsvPgXcIFc6+s3j5DxsTu2gg0frKU TM2f3dYnf41/viSXlEFz/RKyogZ0hcfy2tbE+T5J7eqnqHd0= X-Gm-Gg: ATEYQzxIhnrEiLUZYViTkmVtRnxBxDKKQQ3dOQNMVa2NBKVSmxj2C4Mbt7qTNvV5MBy cC0PlXaqwST1559728iCX8PFkbkqsCF982B9ElKIsnziakjt9hyqD6GhBP8FE9JmZTxnKghr+00 NvGGHtZfhJyfy5SPELnQvYh+6JKganCyOfMVexUJfzmm1rUMW+JijdICHXPKWCqoUAJdO7V/dcs 2mTnycISNiQoxogyiNuFMJt+D3j906XVV66UuOEUh52BTb2eFnLRFmX9/UaejtznO/tpQjq92sE 6n7hekaYCT2yKccK3gGLA7rAufHmX5ySicdz/303NXSHYsShdiHd9OjIdY78VQ9Qp3roO0A= X-Received: by 2002:a05:651c:1502:b0:38b:fbb9:42c4 with SMTP id 38308e7fff4ca-38c7306a69cmr26405291fa.4.1774767040389; Sat, 28 Mar 2026 23:50:40 -0700 (PDT) MIME-Version: 1.0 From: Xianbin Zhu Date: Sun, 29 Mar 2026 14:50:28 +0800 X-Gm-Features: AQROBzDMK424D1Dh6DxGUdySxUO5kbF7MyOuxQSlHeqNEx7RQGndoWXSShIHuao Message-ID: Subject: [PROPOSAL] psql tab completion: support ALTER ROLE ... IN DATABASE ... RESET To: pgsql-hackers@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000006676064e24272c" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000006676064e24272c Content-Type: text/plain; charset="UTF-8" Hi hackers, I'd like to work on a small psql tab-completion improvement. Problem: psql currently has a missing completion path for: ALTER ROLE IN DATABASE RESET ... There is an in-code TODO marker for this case in src/bin/psql/tab-complete.in.c. Proposal: - Add completion support after "... IN DATABASE RESET" - Reuse existing completion behavior/style used by ALTER ROLE ... RESET - Add regression coverage in src/bin/psql/t/010_tab_completion.pl Non-goals: - No backend behavior changes - No SQL grammar changes If this direction looks good, I can send a patch. Thanks, xianbinzhu --000000000000006676064e24272c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi hackers,

I'd like to work on a small psql ta= b-completion improvement.

Problem:
psql currently has a missing c= ompletion path for:
ALTER ROLE <role> IN DATABASE <db> RESET= ...

There is an in-code TODO marker for this case in src/bin/psql/t= ab-complete.in.c.

Proposal:
- Add completion support after "= ... IN DATABASE <db> RESET"
- Reuse existing completion behav= ior/style used by ALTER ROLE ... RESET
- Add regression coverage in src/= bin/psql/t/010_tab_completion.pl

Non-goals:
- No backend behavior changes
- No SQL grammar c= hanges

If this direction looks good, I can send a patch.

Than= ks,
xianbinzhu
--000000000000006676064e24272c--