1.8.4 bug DB Restriction field

Поиск
Список
Период
Сортировка
Искать
От
Zach Conrad
Тема
1.8.4 bug DB Restriction field
Дата
Msg-id
9953724.16651212695024883.JavaMail.root@zimbra
Список
Дерево обсуждения
Re: 1.8.4 bug DB Restriction field Zach Conrad <zach.conrad@digitecinc.com>
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

В списке pgadmin-support по дате отправления
От: Simone Gadenz
Дата:
Сообщение: Re: restoring database
От: Guillaume Lelarge
Дата:
FAQ