BUG #11884: pg_dump / restore mangles IS DISTINCT FROM expressions

Поиск
Список
Период
Сортировка
От nickbarnes01@gmail.com
Тема BUG #11884: pg_dump / restore mangles IS DISTINCT FROM expressions
Дата
Msg-id 20141105225025.26929.22334@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #11884: pg_dump / restore mangles IS DISTINCT FROM expressions  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      11884
Logged by:          Nick Barnes
Email address:      nickbarnes01@gmail.com
PostgreSQL version: 9.3.5
Operating system:   CentOS 6.5
Description:

IS DISTINCT FROM expressions are not dumped/restored correctly if the
comparison operator is outside the search path. e.g.:

psql <<EOF
  CREATE DATABASE test1;
  CREATE DATABASE test2;
  \c test1;
  CREATE SCHEMA s;
  CREATE EXTENSION citext SCHEMA s;
  SET search_path TO public, s;
  CREATE TABLE t (x citext CHECK (x IS DISTINCT FROM ''));
EOF
pg_dump -d test1 | psql -d test2
psql -d test2 -c '\d t'

The check constraint is restored as (x::text IS DISTINCT FROM
''::s.citext::text), i.e. using the <>(text,text) operator instead of
<>(citext,citext).

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #11883: Year 1500 not treated as leap year when it was a leap year
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #11884: pg_dump / restore mangles IS DISTINCT FROM expressions