Re: Apache::Session in PostgreSQL - Mailing list pgsql-general

From Herbert Liechti
Subject Re: Apache::Session in PostgreSQL
Date
Msg-id 38E4F428.8FB686C3@thinx.ch
Whole thread Raw
In response to Apache::Session in PostgreSQL  (Victor Manuel Jaquez Leal <ceyusa@linux1.coral.com.mx>)
Responses Re: Apache::Session in PostgreSQL
List pgsql-general
Victor Manuel Jaquez Leal wrote:
>
> Hi!
>
> I want to use the Apache::Session perl module in my WebApps, but when I
> try to insert the session tuple, the Postgres can't handle the string and
> abort the operation.

I had the same problem ;-(. I found no solution for that so I went to
store the session parameters in the file system. I'm also interested
in a solution.

Below the requirements for the Apache::Session::DbI

NAME
       Apache::Session::DBI - Session persistence via DBI

SCHEMA
       To use this module, you will need these columns in a table
       called 'sessions':

        id char(16)
        length int(11)
        a_session text

       Where the a_session column needs to be able to handle
       arbitrarily long binary data.

Regards Herbie

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Herbert Liechti                     E-Mail: Herbert.Liechti@thinx.ch
ThinX networked business services        Stahlrain 10, CH-5200 Brugg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

pgsql-general by date:

Previous
From: Ken Causey
Date:
Subject: Re: [INTERFACES] Problem with Large Object Interface of pgsql_perl5
Next
From: brad
Date:
Subject: Re: doing backups