Skip site navigation (1) Skip section navigation (2)

pgsql: Support arrays of composite types, including the rowtypes of

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Support arrays of composite types, including the rowtypes of
Date: 2007-05-11 17:57:14
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-committers
Log Message:
Support arrays of composite types, including the rowtypes of regular tables
and views (but not system catalogs, nor sequences or toast tables).  Get rid
of the hardwired convention that a type's array type is named exactly "_type",
instead using a new column pg_type.typarray to provide the linkage.  (It still
will be named "_type", though, except in odd corner cases such as
maximum-length type names.)

Along the way, make tracking of owner and schema dependencies for types more
uniform: a type directly created by the user has these dependencies, while a
table rowtype or auto-generated array type does not have them, but depends on
its parent object instead.

David Fetter, Andrew Dunstan, Tom Lane

Modified Files:
        array.sgml (r1.60 -> r1.61)
        catalogs.sgml (r2.150 -> r2.151)
        syntax.sgml (r1.117 -> r1.118)
        create_type.sgml (r1.69 -> r1.70)
        README (r1.10 -> r1.11)
        heap.c (r1.318 -> r1.319)
        pg_shdepend.c (r1.17 -> r1.18)
        pg_type.c (r1.111 -> r1.112)
        tablecmds.c (r1.219 -> r1.220)
        typecmds.c (r1.101 -> r1.102)
        parse_type.c (r1.89 -> r1.90)
        lsyscache.c (r1.151 -> r1.152)
        pg_dump.c (r1.467 -> r1.468)
        pg_dump.h (r1.134 -> r1.135)
        catversion.h (r1.405 -> r1.406)
        pg_attribute.h (r1.130 -> r1.131)
        pg_class.h (r1.100 -> r1.101)
        pg_type.h (r1.182 -> r1.183)
        typecmds.h (r1.18 -> r1.19)
        alter_table.out (r1.101 -> r1.102)
        oidjoins.out (r1.19 -> r1.20)
        type_sanity.out (r1.29 -> r1.30)
        oidjoins.sql (r1.19 -> r1.20)
        type_sanity.sql (r1.29 -> r1.30)
        README (r1.3 -> r1.4)

pgsql-committers by date

Next:From: Neil ConwayDate: 2007-05-11 19:40:08
Subject: pgsql: Improvements to the SGML docs for TRUNCATE and CLUSTER.
Previous:From: David FetterDate: 2007-05-11 15:54:07
Subject: dbi-link - dbi-link: New Directory

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group