Hi, For the last couple days I have been using 4.6 with PostgreSQL on windows with Apache 2 and PHP5. I've gotten a bunch of pg_query() errors and am wondering if this stuff is supposed to be working yet with PostgreSQL. Some of the errors: 1. Attempting to add a new role: INSERT INTO role (name) VALUES ('superduper') in C:\...\includes\database.pgsql.inc on line 62. pg_query() [function.pg-query <http://www.footballfantasywizard.com/function.pg-query>]: Query failed: ERROR: duplicate key violates unique constraint "role_pkey" in C:\...\includes\database.pgsql.inc on line 45. I fixed this by incrementing the role_rid_seq Current Value, but looking at the code in user.module, it seems that we would want to change the following (add a call to db_next_id): db_query("INSERT INTO {role} (name) VALUES ('%s')", $edit['name']); 2. Under logs, top users (and top pages) this error happens: SELECT COUNT(a.uid) AS hits, a.uid, u.name FROM accesslog a LEFT JOIN users u ON a.uid = u.uid GROUP BY a.uid ORDER BY hits DESC LIMIT 30 OFFSET 0 in C:\...\includes\database.pgsql.inc on line 63. pg_query() [function.pg-query <http://www.footballfantasywizard.com/function.pg-query>]: Query failed: ERROR: column "u.name" must appear in the GROUP BY clause... 3. First time I went to the forums (can't reproduce this one, but will do so on a clean install): INSERT INTO vocabulary (name, description, help, multiple, required, hierarchy, relations, weight, module, vid) VALUES ('Forums', '', '', 0, 1, 1, 0, '', 'forum', '1') pg_query() [function.pg-query <http://www.footballfantasywizard.com/function.pg-query>]: Query failed: ERROR: invalid input syntax for integer: "" --- I guess my questions are: 1. Is there a main contact for Drupal/PostgreSQL issues (I emailed James Arthur whose name is at the top of database.pgsql and he gave me some great starting points but said he's been out of the loop for a number of years)? 2. When 4.6 is released, what does that mean as far as PostgreSQL stability? And I'm volunteering to help out -- I've got some time on my hands, but I am not a PostgreSQL expert. Doesn't look like one is really needed, but there appears to be a need for someone to be banging on it. Please feel free to flame away. Hope I haven't put this out in the wrong venue. Marc