Re: Relation "pg_relcheck"

Tom Lane wrote:
> Tilo Schwarz <mail@tilo-schwarz.de> writes:
> > Because this sort of questions appears quite often, I was wondering, if the 
> > start up message of psql could be changed from 
> >   Welcome to psql 7.4devel, the PostgreSQL interactive terminal.
> > to something like
> >   Welcome to psql 7.4devel, the PostgreSQL interactive terminal.
> >   Connected to PostgreSQL <put version here>.
> > to make it easier to catch these errors.
> 
> I'm not eager to add yet another hidden query cycle to the connection
> startup overhead, especially not one that does nothing for people who
> aren't making mistakes ;-).  What's been in the back of my mind is that
> when we redesign the FE/BE protocol (real soon now, I hope) we should
> extend the backend's first message to the frontend to include its
> version number, as well as any other useful info we can think of
> (database encoding and default client encoding come to mind).  This

Added to TODO:

>       o Report server version number, database encoding, client encoding

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073