Hi aLL,

We are running some drupal based web community sites here in Brazil intended to be used by social organizations. Drupal is really a great software, thanx.

At this moment we are using postgresql as database for drupal and we are going to some troubleshooting with this. Most common dificults we had till now were easy to overcome so we would be very happy to help people having problems. Despite this I think drupal use with postgresql could be very improved if we have good answers for questions posted to this forum. For example purposes only:

# warning: pg_exec() query failed: ERROR: pg_atoi: zero-length string ( specific postgresql >= 7.3)
example: http://drupal.org/node/view/2568

# mysql specific LIMIT clause
example: http://drupal.org/node/view/2551

# drupal setup with postgresql
example: http://drupal.org/node/view/2460

# postgresql request for support
example: http://drupal.org/node/view/5473

# encoding postgres related
example: http://drupal.org/node/view/4781

Are there instructions to drupal development with postgresql we could use to start a plan to resolve problems like above and integrate solutions to drupal releases and modules releases? In fact, if community thinks it is usefull for drupal we really like to help.

In meantime we started this week some efforts to modify (or create) drupal database schema mainly for modules development for postgresql 7.3.x to become it more suitable for fresh instalations. Starting point is ERD diagram ( http://drupal.org/book/view/1805 ). We note in example that NOT NULL constraints at every column in database schema is a problem to postgresql porting, are we correct?

People who are facing problems with postgresql fell free to contact me orzenil at intertexto.net

To drupal developers: is there a newer ERD diagram. We used sybase powerdesign reverse engineering from database.pgsql - drupal-4-3-2 to create one.


adrian’s picture

as drupal postgres maintainer I welcome any push to make Drupal more postgresql compatible, and will gladly help test out any new patches that come from this.