MySQL 5.1?

[Mirkules]

Hi All,

 

Does anyone know a release date for MySQL 5.1? In particular, I am interested in the TRIGGER privilege, which allows non-superuser accounts to be able to add/modify/delete triggers.  A hosting company I am working with is (understandably) refusing to upgrade to a RC version (despite it being in development for 2 years already).

 

What's worse, in order for them to add triggers in my name, they want to charge me $120/hr (without having given me an estimate on how long it will take) even though I have provided them with my trigger code, while at the same time saying that trigger privileges are not a requirement of MySQL 5.0.  So, in order for me to twist my host's arm, MySQL 5.1 needs to be a stable release.

 

So, barring any new changes to the MySQL stable branch (and soon!), I will not be able to use triggers with MySQL. Maybe I'll have more luck with PostgreSQL? Anyone have any experience with triggers in PostgreSQL? What is it like migrating from MySQL to PostgreSQL (assuming I wrote my code with PDO or PEAR::MDB2, which, sadly, I didn't lol) ? Are there many hosts that support PostgreSQL?

 

Also, I'm curious if anyone heard anything about PHP 6's release date? PHP 6 was discussed here http://www.phpfreaks.com/forums/index.php/topic,169200.0.html but there was no definitive answer.

 

Anyway, thanks, and goodnight.