Cdbhttpsession Does Not Work With Postgresql ...

Yii 1.1 General Discussion
1

Hi,

it looks like CDbHttpSession does not work with PostgreSQL "out of the box", while it does with SQLite.

Problem seems to be in the "data" column of the session table, which is being created as a "BYTEA" type (when autoCreateSessionTable is set to true).

Changing the column type to "TEXT" seems to work properly.

2

I can confirm that there is problem with saving the data in the session table when using Postgres. However changing the column type to ‘text’ will create problems in case you want to store some advanced data in your sessions, like arrays (because of the Null values)