On 6/22/06, David King dking@ketralnis.com wrote:
I tried upgrading to postgres 8.1 instead of 8.0 to no avail. Does anyone have any ideas? I can do additional debugging
I´m just guess here, but it appears to me that the query it is executing is malformed in some way. Were I you, I´d redo the installation on a test site and try executing this query that has the problem. The DB may give you a more explicit explanation (maybe not) and then you can just try deleting sections of the query until it works and then dive into the section that you removed last (i.e. the offending bit) until you see the syntax error.
query: UPDATE users SET uid = '2', name = 'dking', pass = '47c6b15aca93873f58522f26300d181d', mail = 'dking@<censored=domain>', mode = '0', sort = '0', threshold = '0', theme = '', signature = '', created = '1150424378', changed = '1150424378', status = '1', timezone = '', language = '', picture = '', init = '', data = 'a:3:{s:5:"roles";a:1:{i:0;s:1:"2";}s: 17:"ldap_authentified";b:1;s:7:"ldap_dn";s:38:"<censored=dn>";}', data = 'a:3:{s:5:"roles";a:1:{i:0;s:1:"2";}s: 17:"ldap_authentified";b:1;s:7:"ldap_dn";s:38:"<censored=dn>";}', changed = 1150424379 WHERE uid = 2 in /usr/local/www/drupal/ includes/database.pgsql.inc on line 62.
The errors seem to alternate between those two.
If you are still having trouble after that exercise, you may have better luck asking a pgsql expert or on a pgsql list because drupal users are mostly mysql folks so it´s hard to find a pgsql debugger around these parts...
Best luck, Greg