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.

PHPBuilder.com has posted part two of a series they're working through introducing PHP developers to the world of exception handling in the Postgres database.

Last week we left off with an example where notice, exception and log levels are sent to the client. This week we present more POSTGRES exception examples, and continue with our article on Postgres exception handling.

They create a few examples:

• handling other error conditions with OTHERS
• using f_ex2
• returning NO_DATA_FOUND and TOO_MANY_ROWS
• handling exceptions like table constraints
• nested exceptions
• using f_ex5
• a RAISE EXCEPTION dilemma
• using f_ext1

On PHPBuilder, Robert Bernier has started writing a series of articles on Postgres exception handling. In this one, covers the basics of exception handling for PHP developers.

Postgres exceptions are quite different from PHP exceptions; whereas PHP 5 uses the traditional "Try And Catch" format, Postgres exceptions can only be defined, executed and processed inside the body of the function that triggered the exception.

Also in the article he covers RAISE statements, how Postgres handles them, and gives good practices on how to use them effectively as a method of troubleshooting errors.

The phpPgAdmin development team is happy to announce the release of the latest version of their software - phpPgAdmin 4.1.

The phpPgAdmin Team is proud to announce a new major release of phpPgAdmin. Version 4.1 adds many new features, bug fixes and updated translations over the previous version.

Updates include:

• New icons by Niko , from the graphics repository on pgFoundry
• Send encrypted passwords over the wire wherever possible
• Display Prepared Transactions
• Add Support For IN/OUT Parameters

and many more. Check out this posting for a more complete listing or just head straight to the download page to grab the update.