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