[Catalyst] Newbie with the tutorial and Postgresql

[lbmlist at hethcote.com]

Thank you, you got me past that hurdle. I was missing a

"DEFAULT nextval('books_seq'),"

in the CREATE TABLE. I had the correct stuff in the
lib/MyAppDB/Book.pm (since it was copied right out of the tutorial ;-) I 
was missing something for the PK::Auto to operate on.

Thanks again!

Louis


On Wed, 30 May 2007, Marcello Romani wrote:

> Tom Lanyon ha scritto:
>> 
>> On 30/05/2007, at 3:39 PM, Marcello Romani wrote:
>> 
>>> Do you also have
>>>
>>>  __PACKAGE__->set_primary_key('id');
>>> 
>>> ?
>> 
>> You need:
>>     - an add_column() or add_columns() line for your 'id' column
>>     - the above set_primary_key('id') line
>>     - the 'id' column in your database table must have its default value 
>> set to the nextval from a sequence in the database
>> 
>> Hope this helps.
>> 
>> -- 
>> Tom Lanyon
>> Systems Administrator
>> NetSpot Pty Ltd
>> 
>> 
>> 
>> _______________________________________________
>> List: Catalyst at 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/
>> 
>> 
>
> Yes, I've probably been too concise ;-)
>
> In fact it would be of great help to see the full source code for the 
> dbic-class and the db-creation script, to see where the problem lies.
>
> I think checking if the id column is SERIAL is a good advice.
>
> -- 
> Marcello Romani
> Responsabile IT
> Ottotecnica s.r.l.
> http://www.ottotecnica.com
>
> _______________________________________________
> List: Catalyst at 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/
>
>
>