Re: 1.8.4 bug DB Restriction field

Zach Conrad a écrit :
> 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')
> 

The DB Restriction field should not contain : datname IN ('blah')

It should contain : 'blah'
or : 'foo','bar'

Regards.


-- 
Guillaume.
  http://www.postgresqlfr.org
  http://dalibo.com

-- 
Sent via pgadmin-sup****t mailing list (pgadmin-sup****t@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-sup****t