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
|
Список | 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 по дате отправления: