Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > 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.
--
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
Index: src/bin/psql/startup.c
===================================================================
RCS file: /cvsroot/pgsql/src/bin/psql/startup.c,v
retrieving revision 1.120
diff -c -c -r1.120 startup.c
*** src/bin/psql/startup.c 25 Jul 2005 17:17:41 -0000 1.120
--- src/bin/psql/startup.c 31 Aug 2005 02:19:12 -0000
***************
*** 8,13 ****
--- 8,14 ----
#include "postgres_fe.h"
#include <sys/types.h>
+ #include <math.h>
#ifndef WIN32
#include <unistd.h>
***************
*** 312,317 ****
--- 313,325 ----
if (!QUIET() && !pset.notty)
{
+ if (pset.sversion / 100 != atoi(PG_VERSION) * 100 +
+ (strchr(PG_VERSION, '.')[1] - '0'))
+ printf(_("You are connected to a server with a
differnt major version number\n"
+ "than your %s client.
Informational backslash commands, like \\d,\n"
+ "might not work
properly.\n\n"),
+ pset.progname);
+
printf(_("Welcome to %s %s, the PostgreSQL interactive
terminal.\n\n"
"Type: \\copyright for
distribution terms\n"
" \\h for help with
SQL commands\n"
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
