[Catalyst] How to update row in Postgres when SERIAL PRIMARY KEY?

[Dennis Daupert]

I know how in mysql, but still new to postgresql, trying to learn. In mysql, when there's an autoincremented integer primary key, you don't mention that field on inserts; it just gets handled. In postgresql, when I try that, he complains. Also complains if I try to set id to '', 'undef', 'DEFAULT', and various other tries.

ID field definition:

id           SERIAL      NOT NULL PRIMARY KEY,

The insert statement:

$c->stash->{quote} = $c->model('CatapultDB::Quotes')->create({
       id => 'DEFAULT',
       quote  => $c->request->params->{quote},
       author => $c->request->params->{author},
       category => $c->request->params->{category},
       active => 'true'
       });

best,

/dennis

_______________________________________________
List: Catalyst@lists.rawmode.org
Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/
Dev site: http://dev.catalyst.perl.org/