Re: OT: Apache::Session::DBI vs postgresql? --help - Mailing list pgsql-general

From will trillich
Subject Re: OT: Apache::Session::DBI vs postgresql? --help
Date
Msg-id 20010616180339.A15073@serensoft.com
Whole thread Raw
In response to Re: OT: Apache::Session::DBI vs postgresql? --help  (Alex Pilosov <alex@pilosoft.com>)
Responses Re: OT: Apache::Session::DBI vs postgresql? --help  (Alex Pilosov <alex@pilosoft.com>)
List pgsql-general
On Sat, Jun 16, 2001 at 12:41:57AM -0400, Alex Pilosov wrote:
> Actually, I just tried your original example, and it worked for me:
>         use Apache::Session::Postgres;
>
>         #if you want Apache::Session to open new DB handles:
>
>         tie %hash, 'Apache::Session::Postgres', $id, {
>                 DataSource => 'dbi:Pg:dbname=sessions',
>                 UserName   => $db_user,
>                 Password   => $db_pass,
>                 Commit     => 1
>         };
> (all works fine)
>
> I think your problem is using wrong versions of Apache::Session. Make sure
> you upgrade to latest (1.53). You should _not_ even have had
> Session::DBIStore, its gone a long time ago.

ah. that made a big difference! thanks.

the manpages for Apache::Session::DBI still say that it
uses Apache::Session::DBIStore for its grunt work. whereas
normal db lookup scripts can
    use DBI
which then hooks into the needed DBD::<whatever> according to
the datasource pattern; i guess Apache::Session::DBI doesn't do
that... which is why we have to specify
    use Apache::Session::Postgres
*and*
    ...DataSource=>'dbi:Pg:dbname=something'...
which seems a bit unmodular, to coin a phrase.

--
I figure: if a man's gonna gamble, may as well do it
without plowing.   -- Bama Dillert, "Some Came Running"

will@serensoft.com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: 7.0.3 select/join syntax?
Next
From: Alex Pilosov
Date:
Subject: Re: OT: Apache::Session::DBI vs postgresql? --help