Re: [HACKERS] [bug fix] PG10: libpq doesn't connect to alternativehosts when some errors occur

From: Michael Paquier [mailto:michael.paquier@gmail.com]
> Does JDBC use something like that to make a difference between a failure
> and a move-on-to-next-one? 

No, it just tries the next host.  See the first while loop in org/postgresql/jdbc/core/v3/ConnectionFactoryImpl.java.


> From maintenance point of view, this would
> require lookups each time a new SQLSTATE is added. Not sure that people
> would remember that.

Yes, I have the same concern, but I'll see if there's a good way anyway (e.g. whether we can simply use the class code
ofthe SQLSTATE, which seems hopeless.)  I guess PgJDBC's way is practical and sensible in the end.
 

Regards
Takayuki Tsunakawa