| 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: | Whole Thread | Raw Message | 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
| 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? |