Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
install procedure fails to create table httpbl w/ postgresql db.
database query syntax only works w/ mysql.
Comment | File | Size | Author |
---|---|---|---|
#5 | httpbl.install.173137.patch | 1.55 KB | jaydub |
#5 | httpbl.module.173137.patch | 828 bytes | jaydub |
Comments
Comment #1
uffner CreditAttribution: uffner commentedThe following statements create approximately the same table in postgresql:
Comment #2
uffner CreditAttribution: uffner commentedI think the only problem query is the insert. PostgreSQL does not support the MySql
extension "INSERT IGNORE" which in addition to the standard SQL insert will also update existing rows. From a brief glance at the code, it does not appear to need the ignore semantics, because a select is done first. If the ignore keyword can indeed be dropped, the module should work with postgresql (assuming that table creation gets fixed of course).
Comment #3
praseodym CreditAttribution: praseodym commentedI'm going to take a look at this; to be honest I've never done any PostgreSQL compatibility myself before so I'll have to check how to create install files etc.
Comment #4
stormsweeper CreditAttribution: stormsweeper commentedI will try to roll a patch later today, but I just had to do this for myself. This is the changed install function for 1.2.2.4
As mentioned above, the "ignore" keyword should also be dropped from the cache set query.
Comment #5
jaydub CreditAttribution: jaydub commentedhere's the above code in patch form with a few small changes.
Also patch to httpbl.module for the one query that has issues
in PostgreSQL
Comment #6
praseodym CreditAttribution: praseodym commentedThis change has been committed. Expect a new release within a few days.
Comment #7
Anonymous (not verified) CreditAttribution: Anonymous commentedAutomatically closed -- issue fixed for two weeks with no activity.