Looks like this is fixed in 7.1RC4:
test=> /* Foo bar
test*> gazonk's gurka
test*> 2001 */
test-> CREATE TABLE foo (bar INTEGER);
CREATE
Thanks.
>
> 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!"
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026