cakephp with postgresql sequence

Hi,

I read from many posts about cakephp and postgresql sequence. Most of
them seems implying that the sequence will be used automatically. One
can override the default sequence name by declaring var $sequence =
"new_sequence"; in the model class.

However, I'm using postgres 8.3 with the latest cakephp rc3. I got
error null value in column "id". As I've check the query shown on the
page, I found that the code try to insert without calling sequence.
It expects the server will generate id automatically.

I've also try to remove the cache, regenerating model, etc. but still
not work. I'm quite new to postgresql. The table is look simple.

table name : supplier_master
field : id=integer, supplier_name=charvarying.

sequence name : supplier_master_id_seq

Can anybody give me a clue?

Thanks in Advance

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---