[Catalyst] Session::Store::DBIC and session table (postgres)
fobispo at isc.org
Wed Nov 14 18:09:32 GMT 2012
Did you use the dbicdump script (or myapp_create.pl model) command to create the schema files?
I would suggest you look to see how the 'sessions' table was created and use that as the name for the relation.
On Nov 14, 2012, at 7:07 AM, Fernan Aguero <fernan.aguero at gmail.com> wrote:
> Of course, I can reproduce succesfully what DBIC is trying to do on the Pg terminal. E.g. for the following error:
> [error] Scheduler: Error executing /cron/remove_sessions: DBIx::Class::ResultSet::delete(): DBI Exception: DBD::Pg::st execute failed: ERROR: relation "sessions" does not exist [for Statement "DELETE FROM sessions WHERE ( id = ? )" with ParamValues: 1='session:c7d07ff1ec06ebf2c6fc37c3cb8f36b117053384']
> I can fix the query and run it (using the same userid/credentials of the catalyst app) without issues:
> tcsnp3=> DELETE FROM webapp.sessions WHERE ( id = 'session:c7d07ff1ec06ebf2c6fc37c3cb8f36b117053384' );
> DELETE 1
Director of Applications and Services - ISC
email: fobispo at isc.org
Phone: +1 650 423 1374 || INOC-DBA *3557* NOC
PGP KeyID = B38DB1BE
More information about the Catalyst