--- original/postgresql-7.1.1/src/bin/psql/command.c Sat May 5 15:06:58 2001 +++ postgresql-7.1.1/src/bin/psql/command.c Thu May 17 08:08:51 2001 @@ -93,6 +93,7 @@ size_t blank_loc; const char *continue_parse = NULL; /* tell the mainloop where the * backslash command ended */ + static int has_been_warned_about_syntax = 0; #ifdef USE_ASSERT_CHECKING assert(line); @@ -141,10 +142,11 @@ status = exec_command(new_cmd, line + 1, &continue_parse, query_buf); -#if 0 /* turned out to be too annoying */ - if (status != CMD_UNKNOWN && isalpha((unsigned char) new_cmd[0])) - psql_error("Warning: this syntax is deprecated\n"); -#endif + if (status != CMD_UNKNOWN && isalpha((unsigned char) new_cmd[0]) && (! has_been_warned_about_syntax)) + { + has_been_warned_about_syntax++; + psql_error("Warning: this syntax is deprecated (this will be your only notice)\n"); + } } if (status == CMD_UNKNOWN)