Problems with Postgres (and any SQL standard compliant database)

Hi,

I had some problem to make this module run with Postgres 7.4

It seems the version of Postgres that I'm using is not possible to use double quotes (") in the queries to specify a language.

with the original code, for example...

languageinterface.module
...
(195) $defaulttext = db_result(db_query('SELECT native FROM {languages} WHERE language = "%s"', $lang));
...

It was giving some warnings...

# warning: pg_query(): Query failed: ERROR: column "en" does not exist in c:\...\includes\database.pgsql.inc on line 139.
# user warning: query: SELECT native FROM languages WHERE language = "en" in c:\...\sites\all\modules\languageinterface\languageinterface.module on line 195.

Changing the double quotes for simple quotes might solve the problem (at least for me)

languageinterface.module
...
(195) $defaulttext = db_result(db_query('SELECT native FROM {languages} WHERE language = \'%s\'', $lang));
...

hope it helps someone :)