Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Chris Hartjes' Blog:
The Devil’s In The Details (or, Handling Sequences in Postgres in CakePHP)
Feb 04, 2008 @ 14:47:00

Chris Hartjes has shared his experiences in dealing with the combination of Postgres and CakePHP and convincing it to work with sequences in your tables.

I had been struggling with some weirdness that CakePHP has been displaying while trying to add some new features to the baseball league website, where Cake + PHP 4.4 + Postgres were deciding to just be sulky and not work together well.

Lucky for me, it turns out that the solution (for now) to the problem was to simply add the name of the sequence for that table as a variable to the model definition.

He includes the code for the Model that creates the connections between hos tables (belongsTo) and creates a sequence global to the class - note the naming convention.

tagged: sequence postgres database cakephp framework example

Link:


Trending Topics: