[Catalyst] Session::Store::DBIC and session table (postgres)

[Francisco Obispo]

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. 

regards


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

Francisco Obispo 
Director of Applications and Services - ISC
email: fobispo at isc.org
Phone: +1 650 423 1374 || INOC-DBA *3557* NOC
PGP KeyID = B38DB1BE