The following bug has been logged online: Bug reference: 5417 Logged by: Kenaniah Cerny Email address: kenan...@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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
