BUG #5417: intarray adds <@ operator which breaks infromation_schema.referential_constraints

Поиск
Список
Период
Сортировка
От Kenaniah Cerny
Тема BUG #5417: intarray adds <@ operator which breaks infromation_schema.referential_constraints
Дата
Msg-id 201004130803.o3D83js3014501@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #5417: intarray adds <@ operator which breaks infromation_schema.referential_constraints  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      5417
Logged by:          Kenaniah Cerny
Email address:      kenaniah@gmail.com
PostgreSQL version: 8.4.2 - 9.0
Operating system:   linux
Description:        intarray adds <@ operator which breaks
infromation_schema.referential_constraints
Details:

Attempting to select * from information_schema.referential_constraints when
the intarray contrib module is loaded on a database produces the following
result:

>ERROR:  operator is not unique: smallint[] <@ smallint[]
>LINE 1: select $1 <@ $2 and $2 <@ $1
>                  ^
>HINT:  Could not choose a best candidate operator. You might need to add
explicit type casts.
>QUERY:  select $1 <@ $2 and $2 <@ $1
>CONTEXT:  SQL function "_pg_keysequal" during inlining

It is expected that this is due to intarray defining its own version of the
<@ operator.

Steps to reproduce:
>select * from >information_schema.referential_constraints; --success

>begin;
>\i /usr/local/.../share/contrib/_int.sql;
>select * from information_schema.referential_constraints; --failure
>rollback;

This bug has been verified in versions 8.4.2, 8.4.3, and 9.0-dev and has not
been checked in other versions yet.

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

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: Possible alpha5 SR bug
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: BUG #5414: pg_dump failure from database 8.4.3 to 8.4.3