Обсуждение: pgsql-server/ ontrib/dblink/dblink.c ontrib/mi ...

Поиск
Список
Период
Сортировка

pgsql-server/ ontrib/dblink/dblink.c ontrib/mi ...

От
tgl@svr1.postgresql.org (Tom Lane)
Дата:
CVSROOT:    /cvsroot
Module name:    pgsql-server
Changes by:    tgl@svr1.postgresql.org    03/11/12 17:15:59

Modified files:
    contrib/dblink : dblink.c
    contrib/miscutil: misc_utils.c
    doc/src/sgml   : catalogs.sgml xindex.sgml
    src/backend/access/common: scankey.c
    src/backend/access/gist: gistget.c gistscan.c
    src/backend/access/heap: tuptoaster.c
    src/backend/access/nbtree: nbtcompare.c nbtinsert.c nbtree.c
                               nbtsearch.c nbtsort.c nbtutils.c
    src/backend/access/rtree: rtproc.c rtscan.c
    src/backend/catalog: aclchk.c dependency.c heap.c index.c
                         pg_constraint.c pg_conversion.c pg_depend.c
                         pg_largeobject.c
    src/backend/commands: async.c cluster.c comment.c dbcommands.c
                          functioncmds.c indexcmds.c opclasscmds.c
                          tablecmds.c trigger.c typecmds.c user.c
                          vacuum.c
    src/backend/executor: nodeIndexscan.c
    src/backend/nodes: copyfuncs.c outfuncs.c
    src/backend/optimizer/path: indxpath.c
    src/backend/optimizer/plan: createplan.c
    src/backend/optimizer/util: plancat.c
    src/backend/parser: parse_func.c
    src/backend/rewrite: rewriteRemove.c
    src/backend/storage/large_object: inv_api.c
    src/backend/utils/adt: float.c regproc.c ruleutils.c selfuncs.c
    src/backend/utils/cache: catcache.c lsyscache.c relcache.c
                             syscache.c typcache.c
    src/backend/utils/init: postinit.c
    src/backend/utils/sort: tuplesort.c
    src/include/access: nbtree.h skey.h
    src/include/catalog: catversion.h indexing.h namespace.h
                         pg_amop.h pg_amproc.h pg_opclass.h
                         pg_proc.h
    src/include/nodes: plannodes.h
    src/include/utils: builtins.h geo_decls.h lsyscache.h rel.h
    src/test/regress/expected: create_index.out oidjoins.out
                               opr_sanity.out
    src/test/regress/sql: create_index.sql oidjoins.sql
                          opr_sanity.sql

Log message:
    Cross-data-type comparisons are now indexable by btrees, pursuant to my
    pghackers proposal of 8-Nov.  All the existing cross-type comparison
    operators (int2/int4/int8 and float4/float8) have appropriate support.
    The original proposal of storing the right-hand-side datatype as part of
    the primary key for pg_amop and pg_amproc got modified a bit in the event;
    it is easier to store zero as the 'default' case and only store a nonzero
    when the operator is actually cross-type.  Along the way, remove the
    long-since-defunct bigbox_ops operator class.


Re: pgsql-server/ ontrib/dblink/dblink.c ontrib/mi ...

От
Bruce Momjian
Дата:
Great.  I will update the TODO list item with a dash once 7.4 is out.
CVS HEAD gets copied to the web site so I don't want to update it yet.

---------------------------------------------------------------------------

Tom Lane wrote:
> CVSROOT:    /cvsroot
> Module name:    pgsql-server
> Changes by:    tgl@svr1.postgresql.org    03/11/12 17:15:59
>
> Modified files:
>     contrib/dblink : dblink.c
>     contrib/miscutil: misc_utils.c
>     doc/src/sgml   : catalogs.sgml xindex.sgml
>     src/backend/access/common: scankey.c
>     src/backend/access/gist: gistget.c gistscan.c
>     src/backend/access/heap: tuptoaster.c
>     src/backend/access/nbtree: nbtcompare.c nbtinsert.c nbtree.c
>                                nbtsearch.c nbtsort.c nbtutils.c
>     src/backend/access/rtree: rtproc.c rtscan.c
>     src/backend/catalog: aclchk.c dependency.c heap.c index.c
>                          pg_constraint.c pg_conversion.c pg_depend.c
>                          pg_largeobject.c
>     src/backend/commands: async.c cluster.c comment.c dbcommands.c
>                           functioncmds.c indexcmds.c opclasscmds.c
>                           tablecmds.c trigger.c typecmds.c user.c
>                           vacuum.c
>     src/backend/executor: nodeIndexscan.c
>     src/backend/nodes: copyfuncs.c outfuncs.c
>     src/backend/optimizer/path: indxpath.c
>     src/backend/optimizer/plan: createplan.c
>     src/backend/optimizer/util: plancat.c
>     src/backend/parser: parse_func.c
>     src/backend/rewrite: rewriteRemove.c
>     src/backend/storage/large_object: inv_api.c
>     src/backend/utils/adt: float.c regproc.c ruleutils.c selfuncs.c
>     src/backend/utils/cache: catcache.c lsyscache.c relcache.c
>                              syscache.c typcache.c
>     src/backend/utils/init: postinit.c
>     src/backend/utils/sort: tuplesort.c
>     src/include/access: nbtree.h skey.h
>     src/include/catalog: catversion.h indexing.h namespace.h
>                          pg_amop.h pg_amproc.h pg_opclass.h
>                          pg_proc.h
>     src/include/nodes: plannodes.h
>     src/include/utils: builtins.h geo_decls.h lsyscache.h rel.h
>     src/test/regress/expected: create_index.out oidjoins.out
>                                opr_sanity.out
>     src/test/regress/sql: create_index.sql oidjoins.sql
>                           opr_sanity.sql
>
> Log message:
>     Cross-data-type comparisons are now indexable by btrees, pursuant to my
>     pghackers proposal of 8-Nov.  All the existing cross-type comparison
>     operators (int2/int4/int8 and float4/float8) have appropriate support.
>     The original proposal of storing the right-hand-side datatype as part of
>     the primary key for pg_amop and pg_amproc got modified a bit in the event;
>     it is easier to store zero as the 'default' case and only store a nonzero
>     when the operator is actually cross-type.  Along the way, remove the
>     long-since-defunct bigbox_ops operator class.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073