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.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' );

Francisco Obispo 
Director of Applications and Services - ISC
email: fobi...@isc.org
Phone: +1 650 423 1374 || INOC-DBA *3557* NOC

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/

Reply via email to