[Bug 174373] Perl program crashes on end if prepared statements are used

[bugzilla at redhat.com]

Please do not reply directly to this email. All additional
comments should be made in the comments box of this bug report.

Summary: Perl program crashes on end if prepared statements are used


https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=174373


jvdias at redhat.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO




------- Additional Comments From jvdias at redhat.com  2005-12-07 16:48 EST -------
Hi - sorry for the delay in processing this bug. 

I've tried to reproduce the problem, with perl-5.8.6-16, perl-DBD-Pg-1.41-2
and postgresql-8.0.4-2.FC4.1 installed, using this example program:

---
#!/usr/bin/perl
use DBI;
use DBD::Pg;

$dbh = DBI->connect('dbi:Pg:dbname=test;', 'root', '',
		    { pg_server_prepare => 1 }
		   ) || die("can't connect: $! $?");

my $stmt = $dbh->prepare("SELECT * FROM t WHERE c = ?");

$stmt->{pg_server_prepare}=1;

my $rv = $stmt->execute("A");

while (my $data = $stmt->fetchrow_hashref) 
{
    print join(" ",values %{$data}),"\n";
};

$stmt->finish();

$dbh->disconnect();

print "STILL HERE\n";
---

In all cases, this program completes normally and prints out "STILL HERE" .

I've tried:
 o running the program on FC5 with perl-5.8.7-0.8.fc5, perl-DBD-Pg-1.43-2,
   postgresql-8.1.0-4 
 o running the program with or without { pg_server_prepare => 1 } in the 
   connect
 o running the program with or without $stmt->{pg_server_prepare}=1;
 o running the program with or without $stmt->finish ;
 o using 'undef $stmt' instead of $stmt->finish ;
 o connecting to a remote postgresql-8.1.0-4 server instead of the local server

If you can still reproduce this problem, please send me an example program such
as the above (and possibly an example database dump) which exhibits the problem
- otherwise I'll have to close as NOTABUG - thanks .

-- 
Configure bugmail: https://bugzilla.redhat.com/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug, or are watching someone who is.