Comment bug in psql - Mailing list pgsql-bugs

From Martin Olsson
Subject Comment bug in psql
Date
Msg-id Pine.LNX.4.21.0104091804250.18068-100000@jean.lab.sentor.se
Whole thread Raw
Responses Re: Comment bug in psql
List pgsql-bugs
Hi!

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
  recognized.
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:

Previous
From: "Stephan Szabo"
Date:
Subject: Re: error creating table that worked under 7.0.3
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: date_part returns wrong day for 1974-04-28