Re: Arrays for domain types - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Arrays for domain types
Date
Msg-id 26078.1039758998@sss.pgh.pa.us
Whole thread Raw
In response to Arrays for domain types  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> While playing around with a preliminary version of the information schema
> I get a failure in the type_sanity regression test here:

> SELECT p1.oid, p1.typname
> FROM pg_type as p1
> WHERE p1.typtype in ('b','d') AND p1.typname NOT LIKE '\\_%' AND NOT
> EXISTS
>     (SELECT 1 FROM pg_type as p2
>      WHERE p2.typname = ('_' || p1.typname)::name AND
>            p2.typelem = p1.oid);

For the moment I'd suggest backing off the regression test from p1.typtype in ('b','d')
to p1.typtype in ('b')
Probably eventually CREATE DOMAIN ought to create an associated array
type, but it's not really your problem if it doesn't ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Please, apply patch for 7.3.1 and current CVS
Next
From: Bruce Momjian
Date:
Subject: Big 7.4 items