Arrays for domain types

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Arrays for domain types
Date: 2002-12-12 23:08:42
Message-ID: Pine.LNX.4.44.0212122356440.25355-100000@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

While playing around with a preliminary version of the information schema
I get a failure in the type_sanity regression test here:

-- Look for basic types that don't have an array type.
-- NOTE: as of 7.3, this check finds SET, smgr, and unknown.

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);

The information schema contains a couple of domains, but apparently no
arrays are generated for those. How is that supposed to be fixed?

--
Peter Eisentraut peter_e(at)gmx(dot)net

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Diego T. 2002-12-12 23:57:02 Postgres syscalls
Previous Message Tom Lane 2002-12-12 21:36:34 Re: PQnotifies() in 7.3 broken?