Horton

Add a bunch of pseudo-types to replace the behavior formerly associated

Tom Lane <tgl@sss.pgh.pa.us>

View on postgr.es
Commit: b663f3443ba096a06970214c3e83e79f6e570b84
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2002-08-22T00:01:51Z
Releases: 7.3.1 
Add a bunch of pseudo-types to replace the behavior formerly associated
with OPAQUE, as per recent pghackers discussion.  I still want to do some
more work on the 'cstring' pseudo-type, but I'm going to commit the bulk
of the changes now before the tree starts shifting under me ...

Files

PathChange+/−
contrib/btree_gist/btree_gist.sql.in modified +35 −35
contrib/chkpass/chkpass.sql.in modified +5 −5
contrib/cube/cube.c modified +0 −8
contrib/cube/cube.sql.in modified +18 −18
contrib/dbmirror/MirrorSetup.sql modified +1 −1
contrib/fulltextindex/fti.c modified +1 −1
contrib/fulltextindex/fti.pl modified +1 −1
contrib/fulltextindex/fti.sql.in modified +1 −1
contrib/fulltextindex/README.fti modified +1 −1
contrib/intarray/_int.sql.in modified +32 −32
contrib/isbn_issn/isbn_issn.sql.in modified +10 −10
contrib/lo/lo_drop.sql modified +3 −9
contrib/lo/lo.sql.in modified +6 −6
contrib/ltree/ltree.sql.in modified +43 −43
contrib/mysql/my2pg.pl modified +17 −11
contrib/noupdate/noup.sql.in modified +1 −1
contrib/oracle/Ora2Pg.pm modified +1 −1
contrib/rserv/MasterInit.in modified +1 −1
contrib/rserv/master.sql.in modified +1 −1
contrib/rtree_gist/rtree_gist.sql.in modified +23 −23
contrib/seg/seg.c modified +0 −8
contrib/seg/seg.sql.in modified +18 −18
contrib/spi/autoinc.sql.in modified +1 −1
contrib/spi/insert_username.sql.in modified +1 −1
contrib/spi/moddatetime.sql.in modified +1 −1
contrib/spi/refint.sql.in modified +2 −2
contrib/spi/timetravel.sql.in modified +1 −1
contrib/string/string_io.sql.in modified +4 −4
contrib/tsearch/tsearch.sql.in modified +36 −30
doc/src/sgml/datatype.sgml modified +141 −1
doc/src/sgml/indexcost.sgml modified +3 −10
doc/src/sgml/plpgsql.sgml modified +3 −3
doc/src/sgml/pltcl.sgml modified +3 −3
doc/src/sgml/ref/create_conversion.sgml modified +4 −4
doc/src/sgml/ref/create_function.sgml modified +12 −13
doc/src/sgml/ref/create_language.sgml modified +9 −7
doc/src/sgml/ref/create_opclass.sgml modified +8 −8
doc/src/sgml/ref/create_trigger.sgml modified +10 −2
doc/src/sgml/ref/create_type.sgml modified +35 −10
doc/src/sgml/release.sgml modified +2 −1
doc/src/sgml/trigger.sgml modified +3 −3
doc/src/sgml/xfunc.sgml modified +5 −8
doc/src/sgml/xplang.sgml modified +4 −4
doc/src/sgml/xtypes.sgml modified +7 −3
src/backend/access/common/printtup.c modified +3 −28
src/backend/catalog/aclchk.c modified +2 −2
src/backend/catalog/pg_aggregate.c modified +4 −4
src/backend/catalog/pg_operator.c modified +5 −5
src/backend/catalog/pg_proc.c modified +21 −7
src/backend/commands/aggregatecmds.c modified +18 −24
src/backend/commands/comment.c modified +4 −3
src/backend/commands/conversioncmds.c modified +3 −3
src/backend/commands/copy.c modified +2 −1
src/backend/commands/functioncmds.c modified +61 −40
src/backend/commands/opclasscmds.c modified +2 −2
src/backend/commands/proclang.c modified +8 −6
src/backend/commands/trigger.c modified +11 −4
src/backend/commands/typecmds.c modified +128 −38
src/backend/parser/parse_coerce.c modified +42 −19
src/backend/parser/parse_func.c modified +9 −20
src/backend/utils/adt/int.c modified +1 −54
src/backend/utils/adt/Makefile modified +2 −2
src/backend/utils/adt/pseudotypes.c added +234 −0
src/backend/utils/adt/regproc.c modified +10 −13
src/backend/utils/adt/selfuncs.c modified +3 −3
src/backend/utils/cache/lsyscache.c modified +29 −1
src/backend/utils/mb/conversion_procs/ascii_and_mic/ascii_and_mic.c modified +4 −4
src/backend/utils/mb/conversion_procs/cyrillic_and_mic/cyrillic_and_mic.c modified +4 −4
src/backend/utils/mb/conversion_procs/euc_cn_and_mic/euc_cn_and_mic.c modified +4 −4
src/backend/utils/mb/conversion_procs/euc_jp_and_sjis/euc_jp_and_sjis.c modified +4 −4
src/backend/utils/mb/conversion_procs/euc_kr_and_mic/euc_kr_and_mic.c modified +4 −4
src/backend/utils/mb/conversion_procs/euc_tw_and_big5/euc_tw_and_big5.c modified +4 −4
src/backend/utils/mb/conversion_procs/latin2_and_win1250/latin2_and_win1250.c modified +4 −4
src/backend/utils/mb/conversion_procs/latin_and_mic/latin_and_mic.c modified +4 −4
src/backend/utils/mb/conversion_procs/Makefile modified +2 −2
src/backend/utils/mb/conversion_procs/utf8_and_ascii/utf8_and_ascii.c modified +4 −4
src/backend/utils/mb/conversion_procs/utf8_and_big5/utf8_and_big5.c modified +4 −4
src/backend/utils/mb/conversion_procs/utf8_and_cyrillic/utf8_and_cyrillic.c modified +4 −4
src/backend/utils/mb/conversion_procs/utf8_and_euc_cn/utf8_and_euc_cn.c modified +4 −4
src/backend/utils/mb/conversion_procs/utf8_and_euc_jp/utf8_and_euc_jp.c modified +4 −4
src/backend/utils/mb/conversion_procs/utf8_and_euc_kr/utf8_and_euc_kr.c modified +4 −4
src/backend/utils/mb/conversion_procs/utf8_and_euc_tw/utf8_and_euc_tw.c modified +4 −4
src/backend/utils/mb/conversion_procs/utf8_and_gb18030/utf8_and_gb18030.c modified +4 −4
src/backend/utils/mb/conversion_procs/utf8_and_gbk/utf8_and_gbk.c modified +4 −4
src/backend/utils/mb/conversion_procs/utf8_and_iso8859_1/utf8_and_iso8859_1.c modified +4 −4
src/backend/utils/mb/conversion_procs/utf8_and_iso8859/utf8_and_iso8859.c modified +4 −4
src/backend/utils/mb/conversion_procs/utf8_and_johab/utf8_and_johab.c modified +4 −4
src/backend/utils/mb/conversion_procs/utf8_and_sjis/utf8_and_sjis.c modified +4 −4
src/backend/utils/mb/conversion_procs/utf8_and_tcvn/utf8_and_tcvn.c modified +4 −4
src/backend/utils/mb/conversion_procs/utf8_and_uhc/utf8_and_uhc.c modified +4 −4
src/backend/utils/mb/conversion_procs/utf8_and_win1250/utf8_and_win1250.c modified +4 −4
src/backend/utils/mb/conversion_procs/utf8_and_win1256/utf8_and_win1256.c modified +4 −4
src/backend/utils/mb/conversion_procs/utf8_and_win874/utf8_and_win874.c modified +4 −4
src/bin/pg_dump/pg_dump.c modified +17 −13
src/bin/pg_dump/pg_dump.h modified +2 −1
src/bin/psql/describe.c modified +11 −8
src/bin/scripts/createlang.sh modified +2 −2
src/include/access/printtup.h modified +1 −4
src/include/catalog/catversion.h modified +2 −2
src/include/catalog/pg_proc.h modified +247 −211
src/include/catalog/pg_type.h modified +23 −6
src/include/parser/parse_func.h modified +2 −2
src/include/utils/builtins.h modified +21 −3
src/include/utils/lsyscache.h modified +3 −1
src/pl/plperl/plperl.c modified +37 −12
src/pl/plpgsql/src/pl_comp.c modified +24 −14
src/pl/plpython/plpython.c modified +2 −2
src/pl/plpython/plpython_function.sql modified +3 −3
src/pl/tcl/pltcl.c modified +37 −12
src/pl/tcl/test/test_setup.sql modified +4 −4
src/test/regress/expected/copy2.out modified +2 −2
src/test/regress/expected/create_type.out modified +25 −4
src/test/regress/expected/opr_sanity.out modified +28 −18
src/test/regress/expected/plpgsql.out modified +22 −22
src/test/regress/expected/type_sanity.out modified +49 −18
src/test/regress/input/create_function_1.source modified +18 −8
src/test/regress/output/create_function_1.source modified +19 −8
src/test/regress/regress.c modified +61 −1
src/test/regress/sql/copy2.sql modified +2 −2
src/test/regress/sql/create_type.sql modified +22 −4
src/test/regress/sql/drop.sql modified +2 −2
src/test/regress/sql/opr_sanity.sql modified +28 −18
src/test/regress/sql/plpgsql.sql modified +22 −22
src/test/regress/sql/type_sanity.sql modified +36 −18
src/tutorial/complex.c modified +2 −10
src/tutorial/complex.source modified +4 −5