Re: Sessions with Postgres

>>>>> "r" == robert <robert(at)robert(dot)cz> writes:

r> Is anybody here using Apache::Session/Postgres combination without
r> problems? If so, could you be so kind as to post your configuration? If
r> not, how far did you get last time you tried? Is anybody interested in
r> using it at all?

works like a charm. I didn't have to do anything special when I
converted from MySQL -- just change the driver and poof, it worked.

here's a clip of code. $dbh is an already-opened handle to a DBD::Pg
object.

use Apache::Session::Postgres;

# ok, so now create a session for them and use that session ID
# as their cookie value
my %session;
eval {
tie %session, 'Apache::Session::Postgres', undef,
{
Handle => $dbh,
Commit => 0,
};
};

and to pull the session back out:

my %session;
eval {
my $dbh = openDB();
tie %session, 'Apache::Session::Postgres', $key,
{
Handle => $dbh,
Commit => 0,
};
};

What is it that you are doing?

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera(at)kciLink(dot)com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/