zend-db icon indicating copy to clipboard operation
zend-db copied to clipboard

Published 20 hours ago • verified publisher icon zendframework

Issues with DDL and PostgreSQL

Open settermjd opened this issue 9 years ago • 2 comments

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.

settermjd avatar Dec 15 '15 10:12 settermjd

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?

alextech avatar Sep 10 '16 22:09 alextech

This repository has been closed and moved to laminas/laminas-db; a new issue has been opened at https://github.com/laminas/laminas-db/issues/135.

michalbundyra avatar Jan 16 '20 19:01 michalbundyra