[drupal-devel] 4.6 + PostgreSQL
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
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 07 Apr 2005, at 4:39 PM, Marc Poris wrote:
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)?
That would be me. I am listed in the CREDITS file as the postgres maintainer, unfortunately none of my own sites are running postgres, so I only have limited time to test the postgres port, but I usually do a lot of testing when the RC is released, and fix most of the bugs I find (it is a fair amount of work).
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.
If you make patches, they will be looked at and committed.
Please feel free to flame away. Hope I haven't put this out in the wrong venue.
Not at all =) Relax. - -- Adrian Rossouw Drupal developer and Bryght Guy http://drupal.org | http://bryght.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (Darwin) iD8DBQFCVY4W6lSw9JdoA/wRApReAKCFlpaTU4FCq9H1A+QPMuD1ASEIVgCeJldL UTOkNf/qYYNP6dJKGpHWs/w= =7KnC -----END PGP SIGNATURE-----
Is there a pgsql test area for drupal.org? We would be willing to provide one, and grant appropriate access to folks willing to test pgsql. It's a pretty silly and one-off proposal though, if drupal.org already has space available for that. On Apr 7, 2005, at 2:46 PM, Adrian Rossouw wrote:
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)?
That would be me. I am listed in the CREDITS file as the postgres maintainer, unfortunately none of my own sites are running postgres, so I only have limited time to test the postgres port, but I usually do a lot of testing when the RC is released, and fix most of the bugs I find (it is a fair amount of work).
Allie Micka pajunas interactive, inc. http://www.pajunas.com/ scalable web hosting and open source solutions
Hi Adrian, Thanks for the reply -- I blurted out that email before taking the time to really go through the Contributor's Guide. Once I'm a little more familiar with the codebase and how things work I'll try to get into patch-making. - Marc Adrian Rossouw wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
On 07 Apr 2005, at 4:39 PM, Marc Poris wrote:
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)?
That would be me. I am listed in the CREDITS file as the postgres maintainer, unfortunately none of my own sites are running postgres, so I only have limited time to test the postgres port, but I usually do a lot of testing when the RC is released, and fix most of the bugs I find (it is a fair amount of work).
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.
If you make patches, they will be looked at and committed.
Please feel free to flame away. Hope I haven't put this out in the wrong venue.
Not at all =) Relax.
- -- Adrian Rossouw Drupal developer and Bryght Guy http://drupal.org | http://bryght.com
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (Darwin)
iD8DBQFCVY4W6lSw9JdoA/wRApReAKCFlpaTU4FCq9H1A+QPMuD1ASEIVgCeJldL UTOkNf/qYYNP6dJKGpHWs/w= =7KnC -----END PGP SIGNATURE-----
On 08 Apr 2005, at 00:14, Marc Poris wrote:
Hi Adrian,
Thanks for the reply -- I blurted out that email before taking the time to really go through the Contributor's Guide. Once I'm a little more familiar with the codebase and how things work I'll try to get into patch-making.
We're about the release Drupal 4.6 real soon now, so a PostgreSQL patch would be much appreciated. -- Dries Buytaert :: http://www.buytaert.net/
On 08 Apr 2005, at 07:46, Dries Buytaert wrote:
On 08 Apr 2005, at 00:14, Marc Poris wrote:
Hi Adrian,
Thanks for the reply -- I blurted out that email before taking the time to really go through the Contributor's Guide. Once I'm a little more familiar with the codebase and how things work I'll try to get into patch-making.
We're about the release Drupal 4.6 real soon now, so a PostgreSQL patch would be much appreciated.
Also, it is _not_ clear what PostgreSQL patches have been tested, what has been approved and what needs to be committed. Until then, I'm not committing/making any PostgreSQL changes. Anyone? -- Dries Buytaert :: http://www.buytaert.net/
Also, it is _not_ clear what PostgreSQL patches have been tested, what has been approved and what needs to be committed. Until then, I'm not committing/making any PostgreSQL changes. Anyone?
I hope someone gets to this soon. Meanwhile, I wish tht project.module allowed for a special kind of followup where one could tick off boxes 'i have tested this patch - it works as advertised', 'patch does not break stuff', 'patch does not work properly', 'i recommend this patch be accepted', and so on. details still need to be worked out. -moshe
participants (5)
-
Adrian Rossouw -
Allie Micka -
Dries Buytaert -
Marc Poris -
Moshe Weitzman