[lang_en]PG4WP 1.1.0 is almost ready for release.
All I need now is some feedback from people who can test the latest development version.
You can leave a comment to this post to give your feedback.
Fresh install of WordPress 2.9.1 seems to work smoothly, at least with PHP 5.2 and PostgreSQL 8.3 (this is my test/dev setup).
Upgrading from WP 2.8.6 to 2.9.1 works ok, there is just one query that generates an « INDEX not found » during the upgrade (for my testing database), this is a non blocking error.
If you are brave enough to test upgrading from WP 2.8.6 (or any older release) to WP 2.9.1 please note that you should upgrade PG4WP before you start WordPress’ upgrade.
Don’t forget to make a complete backup of your data before trying this.
Important note : the ‘db.php’ from the development archive has PG4WP_LOG_ERRORS set to true, so if you don’t want these logs don’t forget to change it after copying the file to ‘wp-content’.
Here is the download link to the latest development version of PG4WP
[/lang_en]
I found one problem so far, and I’m not sure it’s specific to WordPress 2.9. To fix it, change the $date_funcs array on line 154 to the following:
$date_funcs = array(
‘YEAR(‘ => ‘EXTRACT(YEAR FROM ‘,
‘DAYOFMONTH(‘ => ‘EXTRACT(DAY FROM ‘,
‘MONTH(‘ => ‘EXTRACT(MONTH FROM ‘,
‘DAY(‘ => ‘EXTRACT(DAY FROM ‘
);
Apologies if the above doesn’t format right on your page. Bottom line is that you need to handle the « DAYOFMONTH » function.
Thanks for this info I didn’t notice the problem.
DAYOFMONTH appears at least in WP 2.8.x basic setup, I’ve added a modification in trunk.