*** ./src/bin/psql/startup.c.orig Mon Nov 19 13:06:15 2001 --- ./src/bin/psql/startup.c Mon Nov 19 13:06:24 2001 *************** *** 293,298 **** --- 293,315 ---- #endif } + + /* Warn if connecting to a different version */ + PGresult *result; + + /* Temporarily turn off echoing */ + if (GetVariable(pset.vars, "ECHO_HIDDEN")) + DeleteVariable(pset.vars, "ECHO_HIDDEN"); + result = PSQLexec("SELECT version()"); + SetVariableBool(pset.vars, "ECHO_HIDDEN"); + if (result) { + char serverversion[12]; + sscanf(PQgetvalue(result,0,0), "PostgreSQL %s", serverversion); + PQclear(result); + if (strcmp(PG_VERSION, serverversion)) + printf("WARNING! psql version %s does not match server version %s!\n\n", PG_VERSION, serverversion); + } + SetVariable(pset.vars, "PROMPT1", DEFAULT_PROMPT1); SetVariable(pset.vars, "PROMPT2", DEFAULT_PROMPT2); SetVariable(pset.vars, "PROMPT3", DEFAULT_PROMPT3);