1.8.4 bug DB Restriction field

From: Zach Conrad <zach(dot)conrad(at)digitecinc(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: 1.8.4 bug DB Restriction field
Date: 2008-06-05 19:43:44
Message-ID: 9953724.16651212695024883.JavaMail.root@zimbra
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

DB Restriction field borks on datname IN ('blah') or datname='blah' with the error: "ERROR: operator does not exist: name <> boolean LINE 5: WHERE datname NOT IN (datname='blah')

Here's the full query from the logs being sent from pgAdmin:
SELECT db.oid, datname, db.dattablespace AS spcoid, spcname, datallowconn, datconfig, datacl, pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba) AS datowner,has_database_privilege(db.oid, 'CREATE') as cancreate, current_setting('default_tablespace') AS default_tablespace FROM pg_database db LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID WHERE datname NOT IN (datname='blah')

Sincerely,

Zach Conrad

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2008-06-05 20:31:55 Re: 1.8.4 bug DB Restriction field
Previous Message Simone Gadenz 2008-06-05 09:55:19 Re: restoring database