Hi,

I get a number of errors with a Postgresql backend.

1. The install script does not create the tables required for postgresql.

2. It appears your install script does not create a required sequence. At least this is the message postgresql reports. Can you provide some information on this sequence?

3. It appears there is no constraints folder and required contents in the download on the module page. I had to get them from cvs.

4. Postgresql error messsages:

* warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "SET" at character 29 in /home/friend/public_html/includes/database.pgsql.inc on line 94.
* user warning: query: INSERT INTO password_policy SET id = 1, name = 'test', description = 'test', enabled = 0, serialized_policy = 'O:14:"And_Constraint":4:{s:11:"constraints";a:0:{}s:4:"name";s:4:"test";s:11:"description";s:4:"test";s:22:"minimumConstraintValue";N;}' in /home/friend/public_html/includes/database.pgsql.inc on line 113.

Comments

dayre’s picture

dayre commented
Status: Active » Closed (duplicate)

I've already logged lack of pg support as an issue, so this is a duplicate, except item #3, no constraints folder in the 4-7 release. I goofed up here, and just added the constraints folder to 4-7. It should be tarred up and appear within 24 hours.

PG support isn't high priority for me right now... unless we get some more issues logged... If you would like to apply a patch, i would be more than happy to review it and included into the distro.