Issues with DDL and PostgreSQL

[settermjd]

I'm not sure if this is something which has already been covered, but recently I've been attempting to use the AlterTable and CreateTable classes with PostgreSQL and have been hitting an array of errors. These have been primarily caused by:

• Incorrect quoting of schema elements
• Incorrectly generated SQL

On investigating further, the support for PostgreSQL doesn't seem as robust as that for DB2, MySQL, Oracle or SQLServer. Am I missing something here? Or is it worth both implementing a set of Platform classes for PostgreSQL and spending time debugging and correcting the other issues which I've come across?

Would really appreciate feedback regarding this.

[alextech]

I am trying to go through available abstraction utilities (data types, constraint types etc.) to check they work with PostgreSQL and update the newly created decorator as I find them. Can you please share your usage examples that incorrectly generate SQL so I do not miss anything?

[michalbundyra]

This repository has been closed and moved to laminas/laminas-db; a new issue has been opened at laminas/laminas-db#135.