Skip site navigation (1) Skip section navigation (2)

Comment bug in psql

From: Martin Olsson <elof(at)sentor(dot)se>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Comment bug in psql
Date: 2001-04-09 16:22:32
Message-ID: Pine.LNX.4.21.0104091804250.18068-100000@jean.lab.sentor.se (view raw or flat)
Thread:
Lists: 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!"


Responses

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2001-04-09 17:51:12
Subject: Re: Comment bug in psql
Previous:From: Stephan SzaboDate: 2001-04-08 07:20:10
Subject: Re: error creating table that worked under 7.0.3

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group