Thread: Re: [BUGS] PSQL commands not backwards-compatible
> > > Here is a patch that will print out (in interactive mode only) a > > > warning message if a newer client connects to an older > major numbered server. > > > > Why only older? It's even less likely to work if the > server is newer. > > > > (I don't agree with the premise to begin with...) > > OK, this new patch prints a warning on any major version > mismatch, newer or older. I would suggest showing both the client and server versions that mismatched. If you're in a scenario with several versions on the same machine of both client and server (hosting scenario, I'd imagine), that would certainly help. //Magnus
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Four years later, people were saying: >> OK, this new patch prints a warning on any major version >> mismatch, newer or older. > > I would suggest showing both the client and server versions that > mismatched. If you're in a scenario with several versions on the same > machine of both client and server (hosting scenario, I'd imagine), that > would certainly help. This all seems so familiar somehow... :) http://archives.postgresql.org/pgsql-patches/2001-11/msg00184.php - -- Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 200508312042 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iD8DBQFDFk8HvJuQZxSWSsgRAunEAKDsF6M1QuDkK2JQnH2gH2iHnahbNACdGKTu inh9CWsDd27O4F1xT931mTs= =EoUH -----END PGP SIGNATURE-----
Greg Sabino Mullane wrote: [ There is text before PGP section. ] > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > > Four years later, people were saying: > > >> OK, this new patch prints a warning on any major version > >> mismatch, newer or older. > > > > I would suggest showing both the client and server versions that > > mismatched. If you're in a scenario with several versions on the same > > machine of both client and server (hosting scenario, I'd imagine), that > > would certainly help. > > This all seems so familiar somehow... :) > > http://archives.postgresql.org/pgsql-patches/2001-11/msg00184.php Yep. I think the reason it is acceptable now is that the server version is supplied automatically via the protocol, so we don't need to issue a query on every psql startup to check it. -- 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, Pennsylvania 19073