I just found a bug in psql 7.0.3 (a FreeBSD 4.2 port).
1 db=# /* Foo bar
2 db*# gazonk's gurka
3 db'# 2001 */
4 db'# CREATE TABLE foo (bar INTEGER);
5 db'# '
6 db*# */
7 db-# CREATE TABLE gazonk (blirp INTEGER);
8 ERROR: Unterminated quoted string
1 Prompt is =, ok
Start a comment
2 Prompt changes to *, ok
Write more comments and include an apostrofe (')
3 Prompt changes to ', ERROR! You shouldn't enter this mode because of an
apostrofe in commented text.
Write more comments and end them, ERROR! The end of the comments aren't
The rest, 4-8, will be interpreted incorrectly.
/Martin Olsson Sentor AB
"There is at least one incorrect statement in this text,
but it may be this one!"
pgsql-bugs by date
|Next:||From: Bruce Momjian||Date: 2001-04-09 17:51:12|
|Subject: Re: Comment bug in psql|
|Previous:||From: Stephan Szabo||Date: 2001-04-08 07:20:10|
|Subject: Re: error creating table that worked under 7.0.3|