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.agu...@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: fobi...@isc.org Phone: +1 650 423 1374 || INOC-DBA *3557* NOC PGP KeyID = B38DB1BE _______________________________________________ List: Catalyst@lists.scsys.co.uk Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/ Dev site: http://dev.catalyst.perl.org/
