Hi,
I'm having this issue with my catalyst app where the session table is
not fully qualified in the generated SQL statement:
[error] Caught exception in engine DBIx::Class::ResultSet::delete():
DBI Exception: DBD::Pg::st execute failed: ERROR: relation sessions
does not exist [for Statement
Hi there,
We built a simple POC of what could be a pretty cool project for building a
Web-based SCADA on top of Catalyst.
I can gladly participate in the project but we have no funds to continue
it's development internally. So would like to know if anyone here would
like to participate/lead it's
On Wed, Nov 14, 2012 at 7:45 AM, Fernan Aguero fernan.agu...@gmail.comwrote:
Hi,
I'm having this issue with my catalyst app where the session table is
not fully qualified in the generated SQL statement:
[...]
The sessions table lives in my PostgreSQL database in a separate
schema
On Wed, Nov 14, 2012 at 11:36 AM, Alejandro Imass alejandro.im...@gmail.com
wrote:
On Wed, Nov 14, 2012 at 7:45 AM, Fernan Aguero fernan.agu...@gmail.comwrote:
Hi,
I'm having this issue with my catalyst app where the session table is
not fully qualified in the generated SQL statement:
On Wed, Nov 14, 2012 at 10:07 AM, Fernan Aguero fernan.agu...@gmail.comwrote:
[...]
Thanks Alejandro for the quick response. I still think that this is
exposing a bug in Session::Store::DBIC or Session::Store::Delegate. They
should use whatever qualified name is given in the DBIC class ...
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:
On Wed, Nov 14, 2012 at 3:09 PM, Francisco Obispo fobi...@isc.org wrote:
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
Use:
$c-model('GUS::WebappSession') as the name.
or in the config:
Plugin::Session
dbic_class GUS::WebappSession
id_field id
storage_field session_data
expires_field expires
need_commit 0
expires 3600
verify_address 1
/Plugin::Session
francisco
On Nov 14, 2012, at 12:51 PM,