Igor Neyman <iney...@perceptron.com> writes:
> Answering my own question.
> Replacing original definition of _pg_keysequal (in information_schema):
> CREATE FUNCTION _pg_keysequal(smallint[], smallint[]) RETURNS boolean
> LANGUAGE sql IMMUTABLE -- intentionally not STRICT, to allow inlining
> AS 'select $1 <@ $2 and $2 <@ $1';
> with this one:
> CREATE FUNCTION _pg_keysequal(smallint[], smallint[]) RETURNS boolean
> LANGUAGE sql IMMUTABLE -- intentionally not STRICT, to allow inlining
> AS 'select $1 operator(pg_catalog.<@) $2 and $2 operator(pg_catalog.<@)
> $1';
> makes queries like:
> select * from information_schema.referential_constraints;
> against information_schema.referential_constraints work without errors.
This is known to happen pre-9.0 if you have contrib/intarray installed.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
