Re: Sessions with Postgres - Mailing list pgsql-general

From Vivek Khera
Subject Re: Sessions with Postgres
Date
Msg-id x7bsogna19.fsf@yertle.kciLink.com
Whole thread Raw
In response to Sessions with Postgres  (Robert <robert@robert.cz>)
List pgsql-general
>>>>> "r" == robert  <robert@robert.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@kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/

pgsql-general by date:

Previous
From: Justin Clift
Date:
Subject: Re: ERWin
Next
From: Vivek Khera
Date:
Subject: Re: transactions on Postgresql