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.
In PostgreSQL, queries strings have to be enclosed in apostrophes ('), quotation mark (") does not work. Please fix it.
Thanx,
Gabor
Comment | File | Size | Author |
---|---|---|---|
#1 | page_title_pg.patch | 3.29 KB | valthebald |
Comments
Comment #1
valthebaldPeople, please!
The world is not stuck to mysql :)
Please find attached patch against 6.x-2.3
Comment #2
Andy Dorman CreditAttribution: Andy Dorman commentedFWIW, I just applied the patch to a new install using 6.x-2.3 and it works great with PgSQL 8.4
Comment #3
nicholasThompsonThanks guys - I've never used PostgreSQL so have no experience (or system) for testing this.
I have applied a similar fix to that in your patch (I actually just switched the single and double quotes around... Works on MySQL and looks like it achieves the same thing as your patch).
Marking as TBP...
Comment #4
beasley CreditAttribution: beasley commentedJust tried the dev version on PostgreSQL 8.1.19 and it works fine.
Comment #5
nicholasThompsonThanks Beasley :)
Comment #6
beasley CreditAttribution: beasley commentedNo problem. Thanks for the really useful module!
Comment #7
John Franklin CreditAttribution: John Franklin commentedThis patch has been sitting around for a full eight months. Can we please get this into a release soon?
Comment #8
davidwhthomas CreditAttribution: davidwhthomas commentedThis module uses invalid SQL syntax which breaks on postgres.
Basically, quote marks are around the wrong way
should be
In all cases.
In then works fine on mysql and postgres.
Without this, postgres users see constant error messages on screen.
Otherwise, a useful module, thanks.
Comment #9
onewomanbiz CreditAttribution: onewomanbiz commentedWhere / how have you used this patch?
I tried the patch through the PGSQL interface and came up with a pgsql error in the code.
I tried looking at database.pgsql.inc line 139, and dreamweaver'd the whole file looking for erroneous " to change them manually to ', everything is already apostrophed.
I get error node column doesn't exist, time_zone column not found...all basically the same error in line 139 database.pgsql.inc.
Any suggestions?
Comment #10
nicholasThompsonThis is fixed in both D6 and D7 - as far as I know.
Comment #11
valthebaldconfirm - D6 version works with postgres 8.4
Comment #12
nicholasThompsonthank you valthebald :)