I've managed to get webforms up and running on Postgres. Following is a list of changes:
- the install file didn't support PostgreSQL
- wrong use of db_next_id() caused PostreSQL errors
- double quotes (
") can't be used for literal strings
db_next_id() seems to be a frequent cause of confusion, as most developers program for MySQL exclusively. The correct (ie. Postgres-compatible) format is db_next_id('{tablename}_columnname');. "columnname" should exactly match the column name the sequence is intended for.
Double quotes for literal strings seem to be not ANSI-compliant, so Postgres treats the string as identifier (table name). Switched on using single quotes instead.
Although all changes are for Postgres, i've added an update path for MySQL users to fix the sequence naming; they should run update.php after patching.
| Comment | File | Size | Author |
|---|---|---|---|
| webform_13.patch | 7.67 KB | smk-ka |
Comments
Comment #1
Tobias Maier commentedif you have a little bit time it would be nice if you could remove
at the mysql part
and add the update path for the mysqls' utf8 support...
http://drupal.org/node/22218#utf8_sql
is not hard to do, just copy and paste...
thanks
Comment #2
ullgren commentedPatch added to CVS and 4.7.0.
Comment #3
smk-ka commentedSeems like Pontus is too fast for me...
Anyway, the utf8 conversion was already part of the installer (FYI, it's update 3). I'll leave the MyISAM issue as it is (for now).
--
Stefan Kudwien
http://www.unleashedmind.com
Comment #4
ullgren commentedAs far as I could tell the changes that Mr Maier asked for was allready in the patch. Or did I miss something ?
Comment #5
Tobias Maier commentedsorry i overlooked it
Comment #6
(not verified) commented