Re: cakephp with postgresql sequence

You don't need to supply a value for the sequence in the insert. Postgres will take care of that if the table is set up correctly with one column as SERIAL type. Can you show the table creation code? Or, if you can access the database through a terminal in psql, show the output of:

\d supplier_master

You should only override the default sequence name for Postgres in Cake if you created and named it yourself when you created the table, rather than use the default name given when declaring a column of type SERIAL. Given your table and column name, it will, in fact be called supplier_master_id_seq. If your model doesn't reflect the actual sequence name you're sure to have problems.

Did you create the DB schema with Cake?

One other thing, though: Cake expects table names to be pluralised (supplier_masters or, if this is a join table, masters_suppliers).

On Tue, Nov 25, 2008 at 5:35 AM, ReFeeL <vorrarit@gmail.com> wrote:

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
-~----------~----~----~----~------~----~------~--~---