Thread

1. Comment bug in psql

   Martin Olsson <elof@sentor.se> — 2001-04-09T16:22:32Z

   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!"
   
   
   

2. Re: Comment bug in psql

   Bruce Momjian <pgman@candle.pha.pa.us> — 2001-04-09T17:51:12Z

   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