Use CURRENT_DATE or _TIMESTAMP instead (I hit a problem with using 'now' with Pg in DBIC due to use of prepared statements, puzzled over it for weeks before finding the solution :)).
2011/9/8 Alex Povolotsky <[email protected]>: > Hello! > > I've tried to use Catalyst::TraitFor::Model::DBIC::Schema::Caching to > decrease REALLY great number of identical SQL requests. DBIC_TRACE did not > show less requests, but storing now() (Postgres database) for timestamp > breaks everything - Caching stores string constant now(). > > What could have I done wrong? I've only added traits => ['Caching'], to > connect and set up memcached caching. > > Alex > > _______________________________________________ > List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class > IRC: irc.perl.org#dbix-class > SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ > Searchable Archive: > http://www.grokbase.com/group/[email protected] > _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[email protected]
