Thread: pgsql: Flip the default typispreferred setting from true to false.

pgsql: Flip the default typispreferred setting from true to false.

From
tgl@postgresql.org (Tom Lane)
Date:
Log Message:
-----------
Flip the default typispreferred setting from true to false.  This affects
only type categories in which the previous coding made *every* type
preferred; so there is no change in effective behavior, because the function
resolution rules only do something different when faced with a choice
between preferred and non-preferred types in the same category.  It just
seems safer and less surprising to have CREATE TYPE default to non-preferred
status ...

Modified Files:
--------------
    pgsql/doc/src/sgml/ref:
        create_type.sgml (r1.75 -> r1.76)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/create_type.sgml?r1=1.75&r2=1.76)
    pgsql/doc/src/sgml:
        typeconv.sgml (r1.56 -> r1.57)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/typeconv.sgml?r1=1.56&r2=1.57)
    pgsql/src/backend/catalog:
        heap.c (r1.335 -> r1.336)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/heap.c?r1=1.335&r2=1.336)
    pgsql/src/backend/commands:
        typecmds.c (r1.120 -> r1.121)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/typecmds.c?r1=1.120&r2=1.121)
    pgsql/src/bin/pg_dump:
        pg_dump.c (r1.498 -> r1.499)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_dump.c?r1=1.498&r2=1.499)
    pgsql/src/include/catalog:
        catversion.h (r1.472 -> r1.473)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversion.h?r1=1.472&r2=1.473)
        pg_type.h (r1.198 -> r1.199)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_type.h?r1=1.198&r2=1.199)
    pgsql/src/test/regress/expected:
        create_type.out (r1.15 -> r1.16)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/create_type.out?r1=1.15&r2=1.16)
    pgsql/src/test/regress/sql:
        create_type.sql (r1.11 -> r1.12)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/create_type.sql?r1=1.11&r2=1.12)

Re: pgsql: Flip the default typispreferred setting from true to false.

From
Simon Riggs
Date:
On Wed, 2008-07-30 at 19:35 +0000, Tom Lane wrote:
> type categories

This whole area makes a lot more sense now.

It was so difficult to explain before...

--
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support