Dennis Daupert wrote:
> 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.
Dont mention it.. that "just works". SERIAL get expanded to a sequence and
int id DEFAULT nextval("sequence")
> $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' });
There is actually a specific DBIx::Class mailinglist.
Jesper
--
Jesper Krogh, [EMAIL PROTECTED]
_______________________________________________
List: [email protected]
Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/[email protected]/
Dev site: http://dev.catalyst.perl.org/