Re: Reposnse from backend when wrong user/database request send - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: Reposnse from backend when wrong user/database request send
Date
Msg-id 20100313.083924.118740670.t-ishii@sraoss.co.jp
Whole thread Raw
In response to Re: Reposnse from backend when wrong user/database request send  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> Tatsuo Ishii <ishii@postgresql.org> writes:
> >> Tatsuo Ishii <ishii@postgresql.org> writes:
> >>> It seems between 8.4 and CVS HEAD backend responses 'E' packet
> >>> (error/fatal message) if a startup packet sent with wrong user and/or
> >>> database. Before backend responses 'R' packet first followd by 'E'
> >>> packet.
> 
> > I now understand that those behavior could be changed randomly release
> > to relase in unpredictable way.
> 
> I think the protocol specification is pretty explicit that you shouldn't
> be relying on specific sequences of events where it's not logically
> necessary that things happen in a particular order.  It's always been
> possible for a connection to be rejected before any 'R' is sent; we've
> only made a minor change in the set of error cases for which that's
> true.

No. I would say CVS HEAD's behavior that it returns 'E' first is ok if
it is given wrong database.

Problem is in 8.4 or before and HEAD returns Authentication ok
('R'+0x8+0x0) then 'E' if wrong user is given. How come backend says
"Great! authentication ok" then "Sorry your database is wrong so
authentican failed". FYI 8.4 or before always returns Authentication
ok then 'E' if user and/or database is wrong.

Maybe we should change "AuthenticationOK" to "AuthenticationMaybeOK"?:-)
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: buildfarm logging versus embedded nulls
Next
From: Bruce Momjian
Date:
Subject: Re: [BUGS] BUG #5021: ts_parse doesn't recognize email addresses with underscores