Lighthouse has a new layout. Prefer the old one? Return to the old layout, and switch back any time from the link at the top of each page.

This project is archived and is in readonly mode.

invalid session table created by postgresql_adapter

#3453

Trying to use PostgreSQL as DB backend for rail v2.3.4 (gentoo).

rake db:create:sessions uses rails string type for session_id field. Unfortunately postgresql_adapter translates this type to postgres type: character varying with limit 255 (set explicitly in the adapter code) which is too short for session_id generated by rails.

I simply changed the limit value for the string type to 512 and it seems working, however I don't know how long this field should be to handle every session_id generated by rails.

The adapter was installed on my system together with activerecord-2.3.4

Reported by srcv · November 2nd, 2009 @ 12:26 PM

State: stale
Milestone: none
Assigned to: nobody
Importance: none

Activity

  1. Rohit Arondekar
    Rohit Arondekar
    • State changed from new to stale
    • Importance changed from to

    Marking ticket as stale. If this is still an issue please leave a comment with suggested changes, creating a patch with tests, rebasing an existing patch or just confirming the issue on a latest release or master/branches.

    October 6th, 2010 @ 06:33 AM