On standard Drupal 4.6.5 installation running on RedHat 9 - Apache 2.0.40-21.11, PHP 4.2.2-17.2, Postgresql 8.0.3-1. I have aded modules FCK editor, filemanager and Project.
When I create projects everything is OK but when I ad first Issue I'am allways getting SQL errors on Issues and My projects page. Every next Issue will produce one more error.

Errors produced with two Issues submited:

warning: pg_query() query failed: ERROR: syntax error at or near ".0" at character 101
in /data/html/drupal/includes/database.pgsql.inc on line 45.
user error:
query: SELECT n.*, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid WHERE n.0 = '8' AND n.nid = '8' in /data/html/drupal/includes/database.pgsql.inc on line 62.

warning: pg_query() query failed: ERROR: syntax error at or near ".0" at character 101
in /data/html/drupal/includes/database.pgsql.inc on line 45.
user error:
query: SELECT n.*, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid WHERE n.0 = '7' AND n.nid = '7' in /data/html/drupal/includes/database.pgsql.inc on line 62.

Comments

Kamik’s picture

Kamik CreditAttribution: Kamik commented

One more information I forgot to say. Issues are showing OK on the main page and also when you clicked one of them. This seems to be problem only with that table listing on Issues and my projects pages.

dww’s picture

dww
we/he/they
CreditAttribution: dww commented
Status: Active » Closed (won't fix)

i'm not supporting the 4.6.x series anymore, especially not on pgsql.

that said, i'm actively working on pgsql compatibility in the 4.7.x (both 1.* and 2.*) and HEAD versions, so don't loose hope for pgsql support. ;)