Re: SSL Connection / Windows + Cygwin + PostgreSQL 7.4

Tom,

I also see  S and N, and do for the database versions I have tested 
against (7.2, 7.3 and 7.4).  I always thought this was just a doc bug 
with the FE/BE protocol docs.

--Barry

Tom Lane wrote:
> Carlos Guzman Alvarez <carlosga@telefonica.net> writes:
> 
>>Now two questions about SSL Request message:
> 
> 
>>1. I'm getting as response an 'S' instead of an 'Y' is this ok ??
> 
> 
> Doesn't sound right.  A recent (7.1 or later) postmaster will always
> return 'Y' or 'N'.  Older postmasters will not recognize the SSLRequest
> code and will return an 'E' message bleating about bad protocol number.
> 
> 
>>2. In which format are sent the error messages for an SSL Request ?? (I 
>>ask this because i think they are sent in 2.0 format i'm rigth??)
> 
> 
> Always 2.0, because only a pre-7.1 postmaster will return an error.
> It's not clear to me that you really need to bother to parse the
> message, though.  The only thing you can do is close the connection
> and try again non-SSL (or fail if you don't want non-SSL).
> 
>             regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match
>