Some queries uses double quotes (") instead of single quotes (') to mark strings.
So that they're not interpreted correctly by postgresql.

CommentFileSizeAuthor
#2 postgresql_patches.zip1.17 KBMonty-2

Comments

brucepearson’s picture

brucepearson commented
Assigned: Unassigned » jozik

Thanks for the report, we will review our DB queries.

Monty-2’s picture

Monty-2 commented
StatusFileSize
new postgresql_patches.zip1.17 KB

By now I have fixed some queries to make the module working on my site, but I've not used all the functionalities.
I'm not able by now to make patch files so i just attached a grep of the lines I edited, hope that will be useful.
And, by the way... great module!!

threading_signals’s picture

threading_signals commented

Subscribing to find out the resolution for Postgresql support. I too think this module is super. :)

brucepearson’s picture

brucepearson commented

We've fixed up the queries so they now use single quotes to mark strings. Hopefully we have found them all.
Please test the next release and let us know.

brucepearson’s picture

brucepearson commented
Status: Active » Needs review
brucepearson’s picture

brucepearson commented
Status: Needs review » Fixed
threading_signals’s picture

threading_signals commented

Thanks Bruce! Much appreciated.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

threading_signals’s picture

threading_signals commented
Status: Closed (fixed) » Needs review

It seems to be almost ready. Getting query related errors with drupal on postgresql when configuring blocks:

Location http://www.example.com/admin/content/translation-management/dashboard

Referrer http://www.example.com/admin/reports/dblog

Message pg_query(): Query failed: ERROR: operator does not exist: character varying = integer LINE 1: SELECT title FROM blocks WHERE delta = 2 ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. in/var/www/includes/database.pgsql.inc on line 139.
Severity error

Location http://www.example.com/admin/content/translation-management/dashboard

Referrer http://www.example.com/admin/reports/dblog

Message query: SELECT title FROM blocks WHERE delta = 2 in on line .
Severity error

Location http://www.example.com/admin/content/translation-management/icl-check

Referrer http://www.example.com/admin/reports/dblog

Message pg_query(): Query failed: ERROR: operator does not exist: character varying = integer LINE 1: SELECT language from i18n_blocks where delta = 3 ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. in/var/www/includes/database.pgsql.inc on line 139.
Severity error