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

Re: Patch - SSL back to working

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: The Hermit Hacker <scrappy(at)hub(dot)org>
Cc: Magnus Hagander <mha(at)sollentuna(dot)net>, "'pgsql-patches(at)postgresql(dot)org'" <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Patch - SSL back to working
Date: 2000-08-19 21:19:22
Message-ID: 6909.966719962@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
The Hermit Hacker <scrappy(at)hub(dot)org> writes:
>>>> I also added the function sslinfo() to get information about the SSL
>>>> connection.
>> 
>> That strikes me as a very bizarre way of doing things.  Why not add an
>> inquiry function to the libpq API, instead?

> what's the difference between 'select sslinfo()' and 'select version()',

Well, (1) backend version is not known directly to libpq; the backend
*must* be queried in some fashion for that info.  I suppose the SSL
connection info is known equally well at both ends of the connection,
so it seems bizarre to inquire of the backend information that would
be available without any round-trip query.

(2) Transport-level info should be available without having to deal with
concerns like whether you have a half-issued query already, or are in
abort transaction state and can't get the backend to execute a SELECT,
etc.  This is a confusion of protocol-stack levels; it's like asking
the backend what the client's IP address is.

(3) version() is a constant, more or less, but sslinfo() will vary
depending on how you have connected.  That bothers me, although I can't
quite put my finger on the reason why.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: The Hermit HackerDate: 2000-08-19 21:24:37
Subject: Re: Patch - SSL back to working
Previous:From: The Hermit HackerDate: 2000-08-19 20:44:48
Subject: Re: Patch - SSL back to working

pgsql-patches by date

Next:From: The Hermit HackerDate: 2000-08-19 21:24:37
Subject: Re: Patch - SSL back to working
Previous:From: The Hermit HackerDate: 2000-08-19 20:44:48
Subject: Re: Patch - SSL back to working

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