Skip site navigation (1) Skip section navigation (2)

Re: psql \conninfo command (was: Patch: psql \whoami option)

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: David Christensen <david(at)endpoint(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Steve Singer <ssinger_pg(at)sympatico(dot)ca>, pgsql-hackers Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: psql \conninfo command (was: Patch: psql \whoami option)
Date: 2010-07-20 03:55:20
Message-ID: AANLkTil_Rh0i63qbLgXWrx7sov2uoNqHbDTbSOES6fTO@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Mon, Jul 19, 2010 at 11:41 PM, David Christensen <david(at)endpoint(dot)com> wrote:
>> I took a look at this patch.  One problem is that it doesn't handle
>> the case where there is no database connection (for example, shut down
>> the database with pg_ctl, then do select 1, then do \conninfo).  I've
>> fixed that in the attached version.
>
> Thanks, I hadn't considered that case.

For some reason, I end up crashing a lot of databases during
development (must be my lousy coding).  So I've had occasion to run
across this, ahem, a few times...

> +1 from me; I don't care what color the bikeshed is, as long as it gets the point across, which this does, and is consistent to boot.

Great, committed that way.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company

In response to

pgsql-hackers by date

Next:From: David ChristensenDate: 2010-07-20 04:02:40
Subject: Re: psql \conninfo command (was: Patch: psql \whoami option)
Previous:From: Robert HaasDate: 2010-07-20 03:54:19
Subject: pgsql: Add \conninfo command to psql, to show current connection info.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group