This project is archived and is in readonly mode.

#3453 ✓stale

invalid session table created by postgresql_adapter

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

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

Comments and changes to this ticket

  • Rohit Arondekar

    Rohit Arondekar October 6th, 2010 @ 06:33 AM

    • 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.

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile »

<h2 style="font-size: 14px">Tickets have moved to Github</h2>

The new ticket tracker is available at <a href=""></a>

People watching this ticket