Apache::Session::DBI and PostgreSQL

[Miguel A.L. Paraz]

Hi all,

I'm trying out Apache::Session for the first time, with this bit of code 
adapted from the manual:

#!/usr/bin/perl -w

use strict;
#use Apache::Session::File;
use Apache::Session::DBI;
my %session;

#make a fresh session for a first-time visitor
#tie %session, "Apache::Session::File", undef, 
#    { Directory => "/tmp/sessiondata" };

tie %session, "Apache::Session::DBI", undef, 
    {DataSource => 'DBI:Pg:dbname=sessions', #these arguments are
     UserName   => '',         #required when using
     Password   => ''            #DBIStore.pm
     };

#stick some stuff in it
$session{visa_number} = "1234 5678 9876 5432";

#get the session id for later use
my $id = $session{_session_id};

print "Content-type: text/html\n\n";

print $id;


But when I run this script, inside the /perl directory handled by
Apache::Registry, the httpd process dies, and error_log reports:

[Sun Oct 17 21:40:06 1999] [error]      (in cleanup) DBD::Pg::st execute failed: 
ERROR:  parser: parse error at or near ""

panic: POPSTACK
Callback called exit.

Note, Apache::Session::File works fine, and I have no problem with DBI
and DBD::pg on this system.

Thanks for any advice,
---m


-- 
               [EMAIL PROTECTED]    Miguel "Migs" A.L. Paraz        
        http://www.iphil.net    IPhil Communications Network, Inc.
              +63-2-750-2288    Business Development Group