Re: OT: Apache::Session::DBI vs postgresql? --help

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(at)serensoft(dot)com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!