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 1tGJIB-0029nD-KF for pgsql-general@arkaria.postgresql.org; Wed, 27 Nov 2024 14:45:23 +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 1tGJIA-00FIpK-7T for pgsql-general@arkaria.postgresql.org; Wed, 27 Nov 2024 14:45:22 +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 1tGJI9-00FIpB-RB for pgsql-general@lists.postgresql.org; Wed, 27 Nov 2024 14:45:21 +0000 Received: from mail-ot1-x333.google.com ([2607:f8b0:4864:20::333]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tGJI7-004L5x-CR for pgsql-general@postgresql.org; Wed, 27 Nov 2024 14:45:21 +0000 Received: by mail-ot1-x333.google.com with SMTP id 46e09a7af769-71d46ace74aso1878238a34.3 for ; Wed, 27 Nov 2024 06:45:19 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1732718717; x=1733323517; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=SLszKmv+c7SSjK9gvZxRtbAp1SIoxjSqpDSlX/InyZs=; b=MtRAPV+IQw50TZywZL3iCkBhhSA10Uk5vWvc3kfJmKfl8/TI1yNGyJzjgLRR7M6BWu /VId1Pu5Nv0pOf8sPE8xX50Er3EI5udqOWVPf2HsBsr7LXqvdxq59aMqayYA0EYLObd5 GXXZy+EKHPFy3qlg/PQmr2rO0yB1q7V6hjNLQbOVPak/Rf4gzEUZTVkWVgrwIZkuW7hj 3wHwiEocHZ09oAkXpSiRSU0XFPlo/+7FCjY1uIyniH0JnAoLu1DOJCf3TvlrVXOBLDT0 vaj2v6b/HMitBpHKMTjezQ/inIShZQVT0izKQVwhwYiUvJGDEzJ3j3Plm3m9HCPSKn0h 5RwA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1732718717; x=1733323517; h=content-transfer-encoding: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=SLszKmv+c7SSjK9gvZxRtbAp1SIoxjSqpDSlX/InyZs=; b=jz2YxxL2IKiTqHFjG9OC/bV3kniFexTWwc7nyeYS3G4iv9lWIoIO6fa8wl5bA1odAW rv8SW4GaeaUey7nTnUaZmQDf4aZYaiLSnTLHFkKjZiotEgi3+oupHFJvm5pVCYPX9U+B pFNU/cJvweU7L5HQ87n4Ma16uvqw6rIWMg0Bf1VIMak2fjgs99kLPehZ1f3V4S3MbuYG BqLDqrqug+FRVoM1dV902b+BTwZ48b0fAmNx0dwfUx83Epp6LQof1/ONd78ANG741Xn5 D0RKZPUJRIcgbgeAZAAxTdgC6XFLj8K+oo/SeHHOGR0BTsAzF+J0SpOu63WhPFC7esft oQiQ== X-Forwarded-Encrypted: i=1; AJvYcCXLoItpdR6Ip2Ngwf1mFLdM5oJ9KF+mHorQUlvdUyzHgChsXZshyNW4oYMNIJWKfk2qfUBRnWy7DFYnTZTS@postgresql.org X-Gm-Message-State: AOJu0Yyt6PjjF4NIvvKIirC13IzO7QF6frAaP1SqctOHyoVj614M0f2K H/3ScVwBYIK7V7gjFmFWGcZee1gqVi+AeQ4KUmcnAbRUU1yYhOv6AYmyCF2XEXEtCw7cuWSb4jO HVofgc00GHz3FbZeK2hgEfRO+KVw= X-Gm-Gg: ASbGncu0zMVmmYH2C60hdwKSljGsYx2sh05KVfjNBwmTWXe9i74OsyR2JePS4df5xsB Orpw4gPIV3XuxR3oEjtF3+LJiMqfzSQRluw== X-Google-Smtp-Source: AGHT+IEd2ooZczPvbOAhlT4HQaCnC9RKZkRl8c6QwMGyRSm9x81NOFFYcIsSttWyBnu05zcj4oaWcpGOsUlikM2PdBk= X-Received: by 2002:a05:6830:43a2:b0:71d:5b70:41bd with SMTP id 46e09a7af769-71d65cb0e98mr3192513a34.12.1732718717154; Wed, 27 Nov 2024 06:45:17 -0800 (PST) MIME-Version: 1.0 References: <3079980.1727103295@sss.pgh.pa.us> In-Reply-To: From: Dominique Devienne Date: Wed, 27 Nov 2024 15:45:05 +0100 Message-ID: Subject: Re: Customize psql prompt to show current_role To: =?UTF-8?Q?Raphael_Salguero_Arag=C3=B3n?= Cc: Tom Lane , Adrian Klaver , Laurenz Albe , Erik Wienhold , Asad Ali , pgsql-general@postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Nov 27, 2024 at 3:14=E2=80=AFPM Raphael Salguero Arag=C3=B3n wrote: > Am 23.09.2024 um 17:37 schrieb Dominique Devienne : > > I'd be glad to use Pavel's proposed %N. =E2=80=94DD > I just wanted to add that we are also supporting a larger customer with e= xactly the same request. > Perhaps this increases the value of the adjustment a little more :) Hi. Thanks for sharing Raphael. That's a 3rd notch Tom! :) So is it the proverbial "third time's a charm" and the community would revise its initial rejection? I keep making that point, but the fact this is entirely opt-in, mitigates the "expensive" argument IMHO. FWIW. Thank you for considering this RFC again, especially since there's a patch for it. Respectfully, --DD