> tested your patch and there was no change in result. I think it 
> wouldn't be nice if this will point out a bug in the perl pg driver 
> because I can't imagine that you would like to do such things in 
> there ...
> 
> the new crash-me tests results are sent to monty so I think he will 
> put them online tomorrow (today for you I think). I also did a test 
> run on oracle and on a microsoft sql 7 server on windows nt (oracle 
> on linux).

Enclosed is a patch that shows our perl interface can't handle '--'
comments, even though psql and the backend directly can handle them.

To add complexity to this, the backend -d3 log from the perl test
session shows the same query that works perfectly in a direct backend
connection.

Can anyone suggest a cause for this?

---------------------------------------------------------------------------
	
	StartTransactionCommand
	query: CREATE TABLE person (id int4, name char(16)) --test
	ERROR:  parser: parse error at or near "--"
	AbortCurrentTransaction

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@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

*** ./interfaces/perl5/test.pl.orig	Thu Oct  7 20:25:13 1999
--- ./interfaces/perl5/test.pl	Thu Oct  7 20:41:40 1999
***************
*** 147,153 ****
  
  ######################### create and insert into table
  
! $result = $conn->exec("CREATE TABLE person (id int4, name char(16))");
  die $conn->errorMessage unless PGRES_COMMAND_OK eq $result->resultStatus;
  my $cmd = $result->cmdStatus;
  ( "CREATE" eq $cmd )
--- 147,153 ----
  
  ######################### create and insert into table
  
! $result = $conn->exec("CREATE TABLE person (id int4, name char(16)) -- /* test*/");
  die $conn->errorMessage unless PGRES_COMMAND_OK eq $result->resultStatus;
  my $cmd = $result->cmdStatus;
  ( "CREATE" eq $cmd )
Thu, 7 Oct 1999 21:47:53 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparison