#---------------------------------------------------------------------- # # pg_aggregate.dat # Initial contents of the pg_aggregate system relation. # # Portions Copyright (c) 1996-2018, PostgreSQL Global Development Group # Portions Copyright (c) 1994, Regents of the University of California # # src/include/catalog/pg_aggregate.dat # #---------------------------------------------------------------------- [ # avg { aggfnoid => '2100', aggtransfn => 'int8_avg_accum', aggfinalfn => 'numeric_poly_avg', aggcombinefn => 'int8_avg_combine', aggserialfn => 'int8_avg_serialize', aggdeserialfn => 'int8_avg_deserialize', aggmtransfn => 'int8_avg_accum', aggminvtransfn => 'int8_avg_accum_inv', aggmfinalfn => 'numeric_poly_avg', aggtranstype => '2281', aggtransspace => '48', aggmtranstype => '2281', aggmtransspace => '48' }, { aggfnoid => '2101', aggtransfn => 'int4_avg_accum', aggfinalfn => 'int8_avg', aggcombinefn => 'int4_avg_combine', aggmtransfn => 'int4_avg_accum', aggminvtransfn => 'int4_avg_accum_inv', aggmfinalfn => 'int8_avg', aggtranstype => '1016', aggmtranstype => '1016', agginitval => '{0,0}', aggminitval => '{0,0}' }, { aggfnoid => '2102', aggtransfn => 'int2_avg_accum', aggfinalfn => 'int8_avg', aggcombinefn => 'int4_avg_combine', aggmtransfn => 'int2_avg_accum', aggminvtransfn => 'int2_avg_accum_inv', aggmfinalfn => 'int8_avg', aggtranstype => '1016', aggmtranstype => '1016', agginitval => '{0,0}', aggminitval => '{0,0}' }, { aggfnoid => '2103', aggtransfn => 'numeric_avg_accum', aggfinalfn => 'numeric_avg', aggcombinefn => 'numeric_avg_combine', aggserialfn => 'numeric_avg_serialize', aggdeserialfn => 'numeric_avg_deserialize', aggmtransfn => 'numeric_avg_accum', aggminvtransfn => 'numeric_accum_inv', aggmfinalfn => 'numeric_avg', aggtranstype => '2281', aggtransspace => '128', aggmtranstype => '2281', aggmtransspace => '128' }, { aggfnoid => '2104', aggtransfn => 'float4_accum', aggfinalfn => 'float8_avg', aggcombinefn => 'float8_combine', aggtranstype => '1022', agginitval => '{0,0,0}' }, { aggfnoid => '2105', aggtransfn => 'float8_accum', aggfinalfn => 'float8_avg', aggcombinefn => 'float8_combine', aggtranstype => '1022', agginitval => '{0,0,0}' }, { aggfnoid => '2106', aggtransfn => 'interval_accum', aggfinalfn => 'interval_avg', aggcombinefn => 'interval_combine', aggmtransfn => 'interval_accum', aggminvtransfn => 'interval_accum_inv', aggmfinalfn => 'interval_avg', aggtranstype => '1187', aggmtranstype => '1187', agginitval => '{0 second,0 second}', aggminitval => '{0 second,0 second}' }, # sum { aggfnoid => '2107', aggtransfn => 'int8_avg_accum', aggfinalfn => 'numeric_poly_sum', aggcombinefn => 'int8_avg_combine', aggserialfn => 'int8_avg_serialize', aggdeserialfn => 'int8_avg_deserialize', aggmtransfn => 'int8_avg_accum', aggminvtransfn => 'int8_avg_accum_inv', aggmfinalfn => 'numeric_poly_sum', aggtranstype => '2281', aggtransspace => '48', aggmtranstype => '2281', aggmtransspace => '48' }, { aggfnoid => '2108', aggtransfn => 'int4_sum', aggcombinefn => 'int8pl', aggmtransfn => 'int4_avg_accum', aggminvtransfn => 'int4_avg_accum_inv', aggmfinalfn => 'int2int4_sum', aggtranstype => '20', aggmtranstype => '1016', aggminitval => '{0,0}' }, { aggfnoid => '2109', aggtransfn => 'int2_sum', aggcombinefn => 'int8pl', aggmtransfn => 'int2_avg_accum', aggminvtransfn => 'int2_avg_accum_inv', aggmfinalfn => 'int2int4_sum', aggtranstype => '20', aggmtranstype => '1016', aggminitval => '{0,0}' }, { aggfnoid => '2110', aggtransfn => 'float4pl', aggcombinefn => 'float4pl', aggtranstype => '700' }, { aggfnoid => '2111', aggtransfn => 'float8pl', aggcombinefn => 'float8pl', aggtranstype => '701' }, { aggfnoid => '2112', aggtransfn => 'cash_pl', aggcombinefn => 'cash_pl', aggmtransfn => 'cash_pl', aggminvtransfn => 'cash_mi', aggtranstype => '790', aggmtranstype => '790' }, { aggfnoid => '2113', aggtransfn => 'interval_pl', aggcombinefn => 'interval_pl', aggmtransfn => 'interval_pl', aggminvtransfn => 'interval_mi', aggtranstype => '1186', aggmtranstype => '1186' }, { aggfnoid => '2114', aggtransfn => 'numeric_avg_accum', aggfinalfn => 'numeric_sum', aggcombinefn => 'numeric_avg_combine', aggserialfn => 'numeric_avg_serialize', aggdeserialfn => 'numeric_avg_deserialize', aggmtransfn => 'numeric_avg_accum', aggminvtransfn => 'numeric_accum_inv', aggmfinalfn => 'numeric_sum', aggtranstype => '2281', aggtransspace => '128', aggmtranstype => '2281', aggmtransspace => '128' }, # max { aggfnoid => '2115', aggtransfn => 'int8larger', aggcombinefn => 'int8larger', aggsortop => '413', aggtranstype => '20' }, { aggfnoid => '2116', aggtransfn => 'int4larger', aggcombinefn => 'int4larger', aggsortop => '521', aggtranstype => '23' }, { aggfnoid => '2117', aggtransfn => 'int2larger', aggcombinefn => 'int2larger', aggsortop => '520', aggtranstype => '21' }, { aggfnoid => '2118', aggtransfn => 'oidlarger', aggcombinefn => 'oidlarger', aggsortop => '610', aggtranstype => '26' }, { aggfnoid => '2119', aggtransfn => 'float4larger', aggcombinefn => 'float4larger', aggsortop => '623', aggtranstype => '700' }, { aggfnoid => '2120', aggtransfn => 'float8larger', aggcombinefn => 'float8larger', aggsortop => '674', aggtranstype => '701' }, { aggfnoid => '2121', aggtransfn => 'int4larger', aggcombinefn => 'int4larger', aggsortop => '563', aggtranstype => '702' }, #---------------------------------------------------------------------- # # pg_am.dat # Initial contents of the pg_am system relation. # # Portions Copyright (c) 1996-2018, PostgreSQL Global Development Group # Portions Copyright (c) 1994, Regents of the University of California # # src/include/catalog/pg_am.dat # #---------------------------------------------------------------------- [ { oid => '403', oid_symbol => 'BTREE_AM_OID', descr => 'b-tree index access method', amname => 'btree', amhandler => 'bthandler', amtype => 'i' }, { oid => '405', oid_symbol => 'HASH_AM_OID', descr => 'hash index access method', amname => 'hash', amhandler => 'hashhandler', amtype => 'i' }, { oid => '783', oid_symbol => 'GIST_AM_OID', descr => 'GiST index access method', amname => 'gist', amhandler => 'gisthandler', amtype => 'i' }, { oid => '2742', oid_symbol => 'GIN_AM_OID', descr => 'GIN index access method', amname => 'gin', amhandler => 'ginhandler', amtype => 'i' }, { oid => '4000', oid_symbol => 'SPGIST_AM_OID', descr => 'SP-GiST index access method', amname => 'spgist', amhandler => 'spghandler', amtype => 'i' }, { oid => '3580', oid_symbol => 'BRIN_AM_OID', descr => 'block range index (BRIN) access method', amname => 'brin', amhandler => 'brinhandler', amtype => 'i' }, ] #---------------------------------------------------------------------- # # pg_amop.dat # Initial contents of the pg_amop system relation. # # Portions Copyright (c) 1996-2018, PostgreSQL Global Development Group # Portions Copyright (c) 1994, Regents of the University of California # # src/include/catalog/pg_amop.dat # #---------------------------------------------------------------------- [ # btree integer_ops # default operators int2 { amopfamily => '1976', amoplefttype => '21', amoprighttype => '21', amopstrategy => '1', amopopr => '95', amopmethod => '403' }, { amopfamily => '1976', amoplefttype => '21', amoprighttype => '21', amopstrategy => '2', amopopr => '522', amopmethod => '403' }, { amopfamily => '1976', amoplefttype => '21', amoprighttype => '21', amopstrategy => '3', amopopr => '94', amopmethod => '403' }, { amopfamily => '1976', amoplefttype => '21', amoprighttype => '21', amopstrategy => '4', amopopr => '524', amopmethod => '403' }, { amopfamily => '1976', amoplefttype => '21', amoprighttype => '21', amopstrategy => '5', amopopr => '520', amopmethod => '403' }, # crosstype operators int24 { amopfamily => '1976', amoplefttype => '21', amoprighttype => '23', amopstrategy => '1', amopopr => '534', amopmethod => '403' }, { amopfamily => '1976', amoplefttype => '21', amoprighttype => '23', amopstrategy => '2', amopopr => '540', amopmethod => '403' }, { amopfamily => '1976', amoplefttype => '21', amoprighttype => '23', amopstrategy => '3', amopopr => '532', amopmethod => '403' }, { amopfamily => '1976', amoplefttype => '21', amoprighttype => '23', amopstrategy => '4', amopopr => '542', amopmethod => '403' }, { amopfamily => '1976', amoplefttype => '21', amoprighttype => '23', amopstrategy => '5', amopopr => '536', amopmethod => '403' }, # crosstype operators int28 { amopfamily => '1976', amoplefttype => '21', amoprighttype => '20', amopstrategy => '1', amopopr => '1864', amopmethod => '403' }, { amopfamily => '1976', amoplefttype => '21', amoprighttype => '20', amopstrategy => '2', amopopr => '1866', amopmethod => '403' }, { amopfamily => '1976', amoplefttype => '21', amoprighttype => '20', amopstrategy => '3', amopopr => '1862', amopmethod => '403' }, { amopfamily => '1976', amoplefttype => '21', amoprighttype => '20', amopstrategy => '4', amopopr => '1867', amopmethod => '403' }, { amopfamily => '1976', amoplefttype => '21', amoprighttype => '20', amopstrategy => '5', amopopr => '1865', amopmethod => '403' }, # default operators int4 { amopfamily => '1976', amoplefttype => '23', amoprighttype => '23', amopstrategy => '1', amopopr => '97', amopmethod => '403' }, { amopfamily => '1976', amoplefttype => '23', amoprighttype => '23', amopstrategy => '2', amopopr => '523', amopmethod => '403' }, { amopfamily => '1976', amoplefttype => '23', amoprighttype => '23', amopstrategy => '3', amopopr => '96', amopmethod => '403' }, { amopfamily => '1976', amoplefttype => '23', amoprighttype => '23', amopstrategy => '4', amopopr => '525', amopmethod => '403' }, { amopfamily => '1976', amoplefttype => '23', amoprighttype => '23', amopstrategy => '5', amopopr => '521', amopmethod => '403' }, # crosstype operators int42 { amopfamily => '1976', amoplefttype => '23', amoprighttype => '21', amopstrategy => '1', amopopr => '535', amopmethod => '403' }, { amopfamily => '1976', amoplefttype => '23', amoprighttype => '21', amopstrategy => '2', amopopr => '541', amopmethod => '403' }, { amopfamily => '1976', amoplefttype => '23', amoprighttype => '21', amopstrategy => '3', amopopr => '533', amopmethod => '403' }, { amopfamily => '1976', amoplefttype => '23', amoprighttype => '21', amopstrategy => '4', amopopr => '543', amopmethod => '403' }, { amopfamily => '1976', amoplefttype => '23', amoprighttype => '21', amopstrategy => '5', amopopr => '537', amopmethod => '403' }, # crosstype operators int48 { amopfamily => '1976', amoplefttype => '23', amoprighttype => '20', amopstrategy => '1', amopopr => '37', amopmethod => '403' }, { amopfamily => '1976', amoplefttype => '23', amoprighttype => '20', amopstrategy => '2', amopopr => '80', amopmethod => '403' }, { amopfamily => '1976', amoplefttype => '23', amoprighttype => '20', amopstrategy => '3', amopopr => '15', amopmethod => '403' }, { amopfamily => '1976', amoplefttype => '23', amoprighttype => '20', amopstrategy => '4', amopopr => '82', amopmethod => '403' }, { amopfamily => '1976', amoplefttype => '23', amoprighttype => '20', amopstrategy => '5', amopopr => '76', amopmethod => '403' }, # default operators int8 { amopfamily => '1976', amoplefttype => '20', amoprighttype => '20', amopstrategy => '1', amopopr => '412', amopmethod => '403' }, { amopfamily => '1976', amoplefttype => '20', amoprighttype => '20', amopstrategy => '2', amopopr => '414', amopmethod => '403' }, { amopfamily => '1976', amoplefttype => '20', amoprighttype => '20', amopstrategy => '3', amopopr => '410', amopmethod => '403' }, { amopfamily => '1976', amoplefttype => '20', amoprighttype => '20', amopstrategy => '4', amopopr => '415', amopmethod => '403' }, { amopfamily => '1976', amoplefttype => '20', amoprighttype => '20', amopstrategy => '5', amopopr => '413', amopmethod => '403' }, # crosstype operators int82 { amopfamily => '1976', amoplefttype => '20', amoprighttype => '21', amopstrategy => '1', amopopr => '1870', amopmethod => '403' }, { amopfamily => '1976', amoplefttype => '20', amoprighttype => '21', amopstrategy => '2', amopopr => '1872', amopmethod => '403' }, { amopfamily => '1976', amoplefttype => '20', amoprighttype => '21', amopstrategy => '3', amopopr => '1868', amopmethod => '403' }, #---------------------------------------------------------------------- # # pg_amproc.dat # Initial contents of the pg_amproc system relation. # # Portions Copyright (c) 1996-2018, PostgreSQL Global Development Group # Portions Copyright (c) 1994, Regents of the University of California # # src/include/catalog/pg_amproc.dat # #---------------------------------------------------------------------- [ # btree { amprocfamily => '397', amproclefttype => '2277', amprocrighttype => '2277', amprocnum => '1', amproc => '382' }, { amprocfamily => '421', amproclefttype => '702', amprocrighttype => '702', amprocnum => '1', amproc => '357' }, { amprocfamily => '423', amproclefttype => '1560', amprocrighttype => '1560', amprocnum => '1', amproc => '1596' }, { amprocfamily => '424', amproclefttype => '16', amprocrighttype => '16', amprocnum => '1', amproc => '1693' }, { amprocfamily => '426', amproclefttype => '1042', amprocrighttype => '1042', amprocnum => '1', amproc => '1078' }, { amprocfamily => '426', amproclefttype => '1042', amprocrighttype => '1042', amprocnum => '2', amproc => '3328' }, { amprocfamily => '428', amproclefttype => '17', amprocrighttype => '17', amprocnum => '1', amproc => '1954' }, { amprocfamily => '428', amproclefttype => '17', amprocrighttype => '17', amprocnum => '2', amproc => '3331' }, { amprocfamily => '429', amproclefttype => '18', amprocrighttype => '18', amprocnum => '1', amproc => '358' }, { amprocfamily => '434', amproclefttype => '1082', amprocrighttype => '1082', amprocnum => '1', amproc => '1092' }, { amprocfamily => '434', amproclefttype => '1082', amprocrighttype => '1082', amprocnum => '2', amproc => '3136' }, { amprocfamily => '434', amproclefttype => '1082', amprocrighttype => '1114', amprocnum => '1', amproc => '2344' }, { amprocfamily => '434', amproclefttype => '1082', amprocrighttype => '1184', amprocnum => '1', amproc => '2357' }, { amprocfamily => '434', amproclefttype => '1114', amprocrighttype => '1114', amprocnum => '1', amproc => '2045' }, { amprocfamily => '434', amproclefttype => '1114', amprocrighttype => '1114', amprocnum => '2', amproc => '3137' }, { amprocfamily => '434', amproclefttype => '1114', amprocrighttype => '1082', amprocnum => '1', amproc => '2370' }, { amprocfamily => '434', amproclefttype => '1114', amprocrighttype => '1184', amprocnum => '1', amproc => '2526' }, { amprocfamily => '434', amproclefttype => '1184', amprocrighttype => '1184', amprocnum => '1', amproc => '1314' }, { amprocfamily => '434', amproclefttype => '1184', amprocrighttype => '1184', amprocnum => '2', amproc => '3137' }, { amprocfamily => '434', amproclefttype => '1184', amprocrighttype => '1082', amprocnum => '1', amproc => '2383' }, { amprocfamily => '434', amproclefttype => '1184', amprocrighttype => '1114', amprocnum => '1', amproc => '2533' }, { amprocfamily => '434', amproclefttype => '1082', amprocrighttype => '1186', amprocnum => '3', amproc => '4133' }, { amprocfamily => '434', amproclefttype => '1114', amprocrighttype => '1186', amprocnum => '3', amproc => '4134' }, { amprocfamily => '434', amproclefttype => '1184', amprocrighttype => '1186', amprocnum => '3', amproc => '4135' }, { amprocfamily => '1970', amproclefttype => '700', amprocrighttype => '700', amprocnum => '1', amproc => '354' }, { amprocfamily => '1970', amproclefttype => '700', amprocrighttype => '700', amprocnum => '2', amproc => '3132' }, { amprocfamily => '1970', amproclefttype => '700', amprocrighttype => '701', amprocnum => '1', amproc => '2194' }, { amprocfamily => '1970', amproclefttype => '701', amprocrighttype => '701', amprocnum => '1', amproc => '355' }, { amprocfamily => '1970', amproclefttype => '701', amprocrighttype => '701', amprocnum => '2', amproc => '3133' }, { amprocfamily => '1970', amproclefttype => '701', amprocrighttype => '700', amprocnum => '1', amproc => '2195' }, { amprocfamily => '1970', amproclefttype => '701', amprocrighttype => '701', amprocnum => '3', amproc => '4139' }, { amprocfamily => '1970', amproclefttype => '700', amprocrighttype => '701', amprocnum => '3', amproc => '4140' }, { amprocfamily => '1974', amproclefttype => '869', amprocrighttype => '869', amprocnum => '1', amproc => '926' }, { amprocfamily => '1976', amproclefttype => '21', amprocrighttype => '21', amprocnum => '1', amproc => '350' }, { amprocfamily => '1976', amproclefttype => '21', amprocrighttype => '21', amprocnum => '2', amproc => '3129' }, { amprocfamily => '1976', amproclefttype => '21', amprocrighttype => '23', amprocnum => '1', amproc => '2190' }, { amprocfamily => '1976', amproclefttype => '21', amprocrighttype => '20', amprocnum => '1', amproc => '2192' }, { amprocfamily => '1976', amproclefttype => '21', amprocrighttype => '20', amprocnum => '3', amproc => '4130' }, { amprocfamily => '1976', amproclefttype => '21', amprocrighttype => '23', amprocnum => '3', amproc => '4131' }, { amprocfamily => '1976', amproclefttype => '21', amprocrighttype => '21', amprocnum => '3', amproc => '4132' }, { amprocfamily => '1976', amproclefttype => '23', amprocrighttype => '23', amprocnum => '1', amproc => '351' }, { amprocfamily => '1976', amproclefttype => '23', amprocrighttype => '23', amprocnum => '2', amproc => '3130' }, { amprocfamily => '1976', amproclefttype => '23', amprocrighttype => '20', #---------------------------------------------------------------------- # # pg_authid.dat # Initial contents of the pg_authid system relation. # # Portions Copyright (c) 1996-2018, PostgreSQL Global Development Group # Portions Copyright (c) 1994, Regents of the University of California # # src/include/catalog/pg_authid.dat # #---------------------------------------------------------------------- [ # The uppercase quantities will be replaced at initdb time with # user choices. # The C code typically refers to these roles using the #define symbols, # so be sure to keep those in sync with the DATA lines. { oid => '10', oid_symbol => 'BOOTSTRAP_SUPERUSERID', rolname => 'POSTGRES', rolsuper => 't', rolinherit => 't', rolcreaterole => 't', rolcreatedb => 't', rolcanlogin => 't', rolreplication => 't', rolbypassrls => 't', rolconnlimit => '-1', rolpassword => '_null_', rolvaliduntil => '_null_' }, { oid => '3373', oid_symbol => 'DEFAULT_ROLE_MONITOR', rolname => 'pg_monitor', rolsuper => 'f', rolinherit => 't', rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f', rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1', rolpassword => '_null_', rolvaliduntil => '_null_' }, { oid => '3374', oid_symbol => 'DEFAULT_ROLE_READ_ALL_SETTINGS', rolname => 'pg_read_all_settings', rolsuper => 'f', rolinherit => 't', rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f', rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1', rolpassword => '_null_', rolvaliduntil => '_null_' }, { oid => '3375', oid_symbol => 'DEFAULT_ROLE_READ_ALL_STATS', rolname => 'pg_read_all_stats', rolsuper => 'f', rolinherit => 't', rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f', rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1', rolpassword => '_null_', rolvaliduntil => '_null_' }, { oid => '3377', oid_symbol => 'DEFAULT_ROLE_STAT_SCAN_TABLES', rolname => 'pg_stat_scan_tables', rolsuper => 'f', rolinherit => 't', rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f', rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1', rolpassword => '_null_', rolvaliduntil => '_null_' }, { oid => '4200', oid_symbol => 'DEFAULT_ROLE_SIGNAL_BACKENDID', rolname => 'pg_signal_backend', rolsuper => 'f', rolinherit => 't', rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f', rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1', rolpassword => '_null_', rolvaliduntil => '_null_' }, ] #---------------------------------------------------------------------- # # pg_cast.dat # Initial contents of the pg_cast system relation. # # Portions Copyright (c) 1996-2018, PostgreSQL Global Development Group # Portions Copyright (c) 1994, Regents of the University of California # # src/include/catalog/pg_cast.dat # #---------------------------------------------------------------------- [ # Note: this table has OIDs, but we don't bother to assign them manually, # since nothing needs to know the specific OID of any built-in cast. # Numeric category: implicit casts are allowed in the direction # int2->int4->int8->numeric->float4->float8, while casts in the # reverse direction are assignment-only. { castsource => '20', casttarget => '21', castfunc => '714', castcontext => 'a', castmethod => 'f' }, { castsource => '20', casttarget => '23', castfunc => '480', castcontext => 'a', castmethod => 'f' }, { castsource => '20', casttarget => '700', castfunc => '652', castcontext => 'i', castmethod => 'f' }, { castsource => '20', casttarget => '701', castfunc => '482', castcontext => 'i', castmethod => 'f' }, { castsource => '20', casttarget => '1700', castfunc => '1781', castcontext => 'i', castmethod => 'f' }, { castsource => '21', casttarget => '20', castfunc => '754', castcontext => 'i', castmethod => 'f' }, { castsource => '21', casttarget => '23', castfunc => '313', castcontext => 'i', castmethod => 'f' }, { castsource => '21', casttarget => '700', castfunc => '236', castcontext => 'i', castmethod => 'f' }, { castsource => '21', casttarget => '701', castfunc => '235', castcontext => 'i', castmethod => 'f' }, { castsource => '21', casttarget => '1700', castfunc => '1782', castcontext => 'i', castmethod => 'f' }, { castsource => '23', casttarget => '20', castfunc => '481', castcontext => 'i', castmethod => 'f' }, { castsource => '23', casttarget => '21', castfunc => '314', castcontext => 'a', castmethod => 'f' }, { castsource => '23', casttarget => '700', castfunc => '318', castcontext => 'i', castmethod => 'f' }, { castsource => '23', casttarget => '701', castfunc => '316', castcontext => 'i', castmethod => 'f' }, { castsource => '23', casttarget => '1700', castfunc => '1740', castcontext => 'i', castmethod => 'f' }, { castsource => '700', casttarget => '20', castfunc => '653', castcontext => 'a', castmethod => 'f' }, { castsource => '700', casttarget => '21', castfunc => '238', castcontext => 'a', castmethod => 'f' }, { castsource => '700', casttarget => '23', castfunc => '319', castcontext => 'a', castmethod => 'f' }, { castsource => '700', casttarget => '701', castfunc => '311', castcontext => 'i', castmethod => 'f' }, { castsource => '700', casttarget => '1700', castfunc => '1742', castcontext => 'a', castmethod => 'f' }, { castsource => '701', casttarget => '20', castfunc => '483', castcontext => 'a', castmethod => 'f' }, { castsource => '701', casttarget => '21', castfunc => '237', castcontext => 'a', castmethod => 'f' }, { castsource => '701', casttarget => '23', castfunc => '317', castcontext => 'a', castmethod => 'f' }, { castsource => '701', casttarget => '700', castfunc => '312', castcontext => 'a', castmethod => 'f' }, { castsource => '701', casttarget => '1700', castfunc => '1743', castcontext => 'a', castmethod => 'f' }, { castsource => '1700', casttarget => '20', castfunc => '1779', castcontext => 'a', castmethod => 'f' }, { castsource => '1700', casttarget => '21', castfunc => '1783', castcontext => 'a', castmethod => 'f' }, { castsource => '1700', casttarget => '23', castfunc => '1744', castcontext => 'a', castmethod => 'f' }, { castsource => '1700', casttarget => '700', castfunc => '1745', castcontext => 'i', castmethod => 'f' }, { castsource => '1700', casttarget => '701', castfunc => '1746', castcontext => 'i', castmethod => 'f' }, { castsource => '790', casttarget => '1700', castfunc => '3823', castcontext => 'a', castmethod => 'f' }, { castsource => '1700', casttarget => '790', castfunc => '3824', castcontext => 'a', castmethod => 'f' }, { castsource => '23', casttarget => '790', castfunc => '3811', castcontext => 'a', castmethod => 'f' }, { castsource => '20', casttarget => '790', castfunc => '3812', castcontext => 'a', castmethod => 'f' }, # Allow explicit coercions between int4 and bool { castsource => '23', casttarget => '16', castfunc => '2557', castcontext => 'e', castmethod => 'f' }, { castsource => '16', casttarget => '23', castfunc => '2558', castcontext => 'e', castmethod => 'f' }, # OID category: allow implicit conversion from any integral type (including # int8, to support OID literals > 2G) to OID, as well as assignment coercion # from OID to int4 or int8. Similarly for each OID-alias type. Also allow # implicit coercions between OID and each OID-alias type, as well as # regproc<->regprocedure and regoper<->regoperator. (Other coercions #---------------------------------------------------------------------- # # pg_class.dat # Initial contents of the pg_class system relation. # # Portions Copyright (c) 1996-2018, PostgreSQL Global Development Group # Portions Copyright (c) 1994, Regents of the University of California # # src/include/catalog/pg_class.dat # #---------------------------------------------------------------------- [ # NOTE: only "bootstrapped" relations need to be declared here. Be sure that # the OIDs listed here match those given in their CATALOG macros, and that # the relnatts values are correct. # Note: "3" in the relfrozenxid column stands for FirstNormalTransactionId; # similarly, "1" in relminmxid stands for FirstMultiXactId { oid => '1247', relname => 'pg_type', relnamespace => 'PGNSP', reltype => '71', reloftype => '0', relowner => 'PGUID', relam => '0', relfilenode => '0', reltablespace => '0', relpages => '0', reltuples => '0', relallvisible => '0', reltoastrelid => '0', relhasindex => 'f', relisshared => 'f', relpersistence => 'p', relkind => 'r', relnatts => '30', relchecks => '0', relhasoids => 't', relhasrules => 'f', relhastriggers => 'f', relhassubclass => 'f', relrowsecurity => 'f', relforcerowsecurity => 'f', relispopulated => 't', relreplident => 'n', relispartition => 'f', relrewrite => '0', relfrozenxid => '3', relminmxid => '1', relacl => '_null_', reloptions => '_null_', relpartbound => '_null_' }, { oid => '1249', relname => 'pg_attribute', relnamespace => 'PGNSP', reltype => '75', reloftype => '0', relowner => 'PGUID', relam => '0', relfilenode => '0', reltablespace => '0', relpages => '0', reltuples => '0', relallvisible => '0', reltoastrelid => '0', relhasindex => 'f', relisshared => 'f', relpersistence => 'p', relkind => 'r', relnatts => '22', relchecks => '0', relhasoids => 'f', relhasrules => 'f', relhastriggers => 'f', relhassubclass => 'f', relrowsecurity => 'f', relforcerowsecurity => 'f', relispopulated => 't', relreplident => 'n', relispartition => 'f', relrewrite => '0', relfrozenxid => '3', relminmxid => '1', relacl => '_null_', reloptions => '_null_', relpartbound => '_null_' }, { oid => '1255', relname => 'pg_proc', relnamespace => 'PGNSP', reltype => '81', reloftype => '0', relowner => 'PGUID', relam => '0', relfilenode => '0', reltablespace => '0', relpages => '0', reltuples => '0', relallvisible => '0', reltoastrelid => '0', relhasindex => 'f', relisshared => 'f', relpersistence => 'p', relkind => 'r', relnatts => '28', relchecks => '0', relhasoids => 't', relhasrules => 'f', relhastriggers => 'f', relhassubclass => 'f', relrowsecurity => 'f', relforcerowsecurity => 'f', relispopulated => 't', relreplident => 'n', relispartition => 'f', relrewrite => '0', relfrozenxid => '3', relminmxid => '1', relacl => '_null_', reloptions => '_null_', relpartbound => '_null_' }, { oid => '1259', relname => 'pg_class', relnamespace => 'PGNSP', reltype => '83', reloftype => '0', relowner => 'PGUID', relam => '0', relfilenode => '0', reltablespace => '0', relpages => '0', reltuples => '0', relallvisible => '0', reltoastrelid => '0', relhasindex => 'f', relisshared => 'f', relpersistence => 'p', relkind => 'r', relnatts => '33', relchecks => '0', relhasoids => 't', relhasrules => 'f', relhastriggers => 'f', relhassubclass => 'f', relrowsecurity => 'f', relforcerowsecurity => 'f', relispopulated => 't', relreplident => 'n', relispartition => 'f', relrewrite => '0', relfrozenxid => '3', relminmxid => '1', relacl => '_null_', reloptions => '_null_', relpartbound => '_null_' }, # default selection for replica identity (primary key or nothing) # no replica identity is logged for this relation # all columns are logged as replica identity # an explicitly chosen candidate key's columns are used as replica identity. # Note this will still be set if the index has been dropped; in that case it # has the same meaning as 'd'. ] #---------------------------------------------------------------------- # # pg_collation.dat # Initial contents of the pg_collation system relation. # # Portions Copyright (c) 1996-2018, PostgreSQL Global Development Group # Portions Copyright (c) 1994, Regents of the University of California # # src/include/catalog/pg_collation.dat # #---------------------------------------------------------------------- [ { oid => '100', oid_symbol => 'DEFAULT_COLLATION_OID', descr => 'database\'s default collation', collname => 'default', collnamespace => 'PGNSP', collowner => 'PGUID', collprovider => 'd', collencoding => '-1', collcollate => '', collctype => '', collversion => '_null_' }, { oid => '950', oid_symbol => 'C_COLLATION_OID', descr => 'standard C collation', collname => 'C', collnamespace => 'PGNSP', collowner => 'PGUID', collprovider => 'c', collencoding => '-1', collcollate => 'C', collctype => 'C', collversion => '_null_' }, { oid => '951', oid_symbol => 'POSIX_COLLATION_OID', descr => 'standard POSIX collation', collname => 'POSIX', collnamespace => 'PGNSP', collowner => 'PGUID', collprovider => 'c', collencoding => '-1', collcollate => 'POSIX', collctype => 'POSIX', collversion => '_null_' }, ] #---------------------------------------------------------------------- # # pg_database.dat # Initial contents of the pg_database system relation. # # Portions Copyright (c) 1996-2018, PostgreSQL Global Development Group # Portions Copyright (c) 1994, Regents of the University of California # # src/include/catalog/pg_database.dat # #---------------------------------------------------------------------- [ { oid => '1', oid_symbol => 'TemplateDbOid', shdescr => 'default template for new databases', datname => 'template1', datdba => 'PGUID', encoding => 'ENCODING', datcollate => 'LC_COLLATE', datctype => 'LC_CTYPE', datistemplate => 't', datallowconn => 't', datconnlimit => '-1', datlastsysoid => '0', datfrozenxid => '0', datminmxid => '1', dattablespace => '1663', datacl => '_null_' }, ] #---------------------------------------------------------------------- # # pg_language.dat # Initial contents of the pg_language system relation. # # Portions Copyright (c) 1996-2018, PostgreSQL Global Development Group # Portions Copyright (c) 1994, Regents of the University of California # # src/include/catalog/pg_language.dat # #---------------------------------------------------------------------- [ { oid => '12', oid_symbol => 'INTERNALlanguageId', descr => 'built-in functions', lanname => 'internal', lanowner => 'PGUID', lanispl => 'f', lanpltrusted => 'f', lanplcallfoid => '0', laninline => '0', lanvalidator => '2246', lanacl => '_null_' }, { oid => '13', oid_symbol => 'ClanguageId', descr => 'dynamically-loaded C functions', lanname => 'c', lanowner => 'PGUID', lanispl => 'f', lanpltrusted => 'f', lanplcallfoid => '0', laninline => '0', lanvalidator => '2247', lanacl => '_null_' }, { oid => '14', oid_symbol => 'SQLlanguageId', descr => 'SQL-language functions', lanname => 'sql', lanowner => 'PGUID', lanispl => 'f', lanpltrusted => 't', lanplcallfoid => '0', laninline => '0', lanvalidator => '2248', lanacl => '_null_' }, ] #---------------------------------------------------------------------- # # pg_namespace.dat # Initial contents of the pg_namespace system relation. # # Portions Copyright (c) 1996-2018, PostgreSQL Global Development Group # Portions Copyright (c) 1994, Regents of the University of California # # src/include/catalog/pg_namespace.dat # #---------------------------------------------------------------------- [ { oid => '11', oid_symbol => 'PG_CATALOG_NAMESPACE', descr => 'system catalog schema', nspname => 'pg_catalog', nspowner => 'PGUID', nspacl => '_null_' }, { oid => '99', oid_symbol => 'PG_TOAST_NAMESPACE', descr => 'reserved schema for TOAST tables', nspname => 'pg_toast', nspowner => 'PGUID', nspacl => '_null_' }, { oid => '2200', oid_symbol => 'PG_PUBLIC_NAMESPACE', descr => 'standard public schema', nspname => 'public', nspowner => 'PGUID', nspacl => '_null_' }, # prototypes for functions in pg_namespace.c ] #---------------------------------------------------------------------- # # pg_opclass.dat # Initial contents of the pg_opclass system relation. # # Portions Copyright (c) 1996-2018, PostgreSQL Global Development Group # Portions Copyright (c) 1994, Regents of the University of California # # src/include/catalog/pg_opclass.dat # #---------------------------------------------------------------------- [ # Note: we hard-wire an OID only for a few entries that have to be explicitly # referenced in the C code or in built-in catalog entries. The rest get OIDs # assigned on-the-fly during initdb. { opcmethod => '403', opcname => 'abstime_ops', opcfamily => '421', opcintype => '702' }, { opcmethod => '403', opcname => 'array_ops', opcfamily => '397', opcintype => '2277' }, { opcmethod => '405', opcname => 'array_ops', opcfamily => '627', opcintype => '2277' }, { opcmethod => '403', opcname => 'bit_ops', opcfamily => '423', opcintype => '1560' }, { opcmethod => '403', opcname => 'bool_ops', opcfamily => '424', opcintype => '16' }, { opcmethod => '403', opcname => 'bpchar_ops', opcfamily => '426', opcintype => '1042' }, { opcmethod => '405', opcname => 'bpchar_ops', opcfamily => '427', opcintype => '1042' }, { opcmethod => '403', opcname => 'bytea_ops', opcfamily => '428', opcintype => '17' }, { opcmethod => '403', opcname => 'char_ops', opcfamily => '429', opcintype => '18' }, { opcmethod => '405', opcname => 'char_ops', opcfamily => '431', opcintype => '18' }, { opcmethod => '403', opcname => 'cidr_ops', opcfamily => '1974', opcintype => '869', opcdefault => 'f' }, { opcmethod => '405', opcname => 'cidr_ops', opcfamily => '1975', opcintype => '869', opcdefault => 'f' }, { oid => '3122', oid_symbol => 'DATE_BTREE_OPS_OID', opcmethod => '403', opcname => 'date_ops', opcfamily => '434', opcintype => '1082' }, { opcmethod => '405', opcname => 'date_ops', opcfamily => '435', opcintype => '1082' }, { opcmethod => '403', opcname => 'float4_ops', opcfamily => '1970', opcintype => '700' }, { opcmethod => '405', opcname => 'float4_ops', opcfamily => '1971', opcintype => '700' }, { oid => '3123', oid_symbol => 'FLOAT8_BTREE_OPS_OID', opcmethod => '403', opcname => 'float8_ops', opcfamily => '1970', opcintype => '701' }, { opcmethod => '405', opcname => 'float8_ops', opcfamily => '1971', opcintype => '701' }, { opcmethod => '403', opcname => 'inet_ops', opcfamily => '1974', opcintype => '869' }, { opcmethod => '405', opcname => 'inet_ops', opcfamily => '1975', opcintype => '869' }, { opcmethod => '783', opcname => 'inet_ops', opcfamily => '3550', opcintype => '869', opcdefault => 'f' }, { opcmethod => '4000', opcname => 'inet_ops', opcfamily => '3794', opcintype => '869' }, { oid => '1979', oid_symbol => 'INT2_BTREE_OPS_OID', opcmethod => '403', opcname => 'int2_ops', opcfamily => '1976', opcintype => '21' }, { opcmethod => '405', opcname => 'int2_ops', opcfamily => '1977', opcintype => '21' }, { oid => '1978', oid_symbol => 'INT4_BTREE_OPS_OID', opcmethod => '403', opcname => 'int4_ops', opcfamily => '1976', opcintype => '23' }, { opcmethod => '405', opcname => 'int4_ops', opcfamily => '1977', opcintype => '23' }, { oid => '3124', oid_symbol => 'INT8_BTREE_OPS_OID', opcmethod => '403', opcname => 'int8_ops', opcfamily => '1976', opcintype => '20' }, { opcmethod => '405', opcname => 'int8_ops', opcfamily => '1977', opcintype => '20' }, { opcmethod => '403', opcname => 'interval_ops', opcfamily => '1982', opcintype => '1186' }, { opcmethod => '405', opcname => 'interval_ops', opcfamily => '1983', opcintype => '1186' }, { opcmethod => '403', opcname => 'macaddr_ops', opcfamily => '1984', opcintype => '829' }, { opcmethod => '405', opcname => 'macaddr_ops', opcfamily => '1985', opcintype => '829' }, { opcmethod => '403', opcname => 'macaddr8_ops', opcfamily => '3371', opcintype => '774' }, { opcmethod => '405', opcname => 'macaddr8_ops', opcfamily => '3372', opcintype => '774' }, # Here's an ugly little hack to save space in the system catalog indexes. # btree doesn't ordinarily allow a storage type different from input type; # but cstring and name are the same thing except for trailing padding, # and we can safely omit that within an index entry. So we declare the # btree opclass for name as using cstring storage type. { opcmethod => '403', opcname => 'name_ops', opcfamily => '1986', opcintype => '19', opckeytype => '2275' }, { opcmethod => '405', opcname => 'name_ops', opcfamily => '1987', opcintype => '19' }, #---------------------------------------------------------------------- # # pg_operator.dat # Initial contents of the pg_operator system relation. # # Portions Copyright (c) 1996-2018, PostgreSQL Global Development Group # Portions Copyright (c) 1994, Regents of the University of California # # src/include/catalog/pg_operator.dat # #---------------------------------------------------------------------- [ # Note: every entry in pg_operator.h is expected to have a DESCR() comment. # If the operator is a deprecated equivalent of some other entry, be sure # to comment it as such so that initdb doesn't think it's a preferred name # for the underlying function. { oid => '15', descr => 'equal', oprname => '=', oprcanmerge => 't', oprcanhash => 't', oprleft => '23', oprright => '20', oprresult => '16', oprcom => '416', oprnegate => '36', oprcode => 'int48eq', oprrest => 'eqsel', oprjoin => 'eqjoinsel' }, { oid => '36', descr => 'not equal', oprname => '<>', oprleft => '23', oprright => '20', oprresult => '16', oprcom => '417', oprnegate => '15', oprcode => 'int48ne', oprrest => 'neqsel', oprjoin => 'neqjoinsel' }, { oid => '37', descr => 'less than', oprname => '<', oprleft => '23', oprright => '20', oprresult => '16', oprcom => '419', oprnegate => '82', oprcode => 'int48lt', oprrest => 'scalarltsel', oprjoin => 'scalarltjoinsel' }, { oid => '76', descr => 'greater than', oprname => '>', oprleft => '23', oprright => '20', oprresult => '16', oprcom => '418', oprnegate => '80', oprcode => 'int48gt', oprrest => 'scalargtsel', oprjoin => 'scalargtjoinsel' }, { oid => '80', descr => 'less than or equal', oprname => '<=', oprleft => '23', oprright => '20', oprresult => '16', oprcom => '430', oprnegate => '76', oprcode => 'int48le', oprrest => 'scalarlesel', oprjoin => 'scalarlejoinsel' }, { oid => '82', descr => 'greater than or equal', oprname => '>=', oprleft => '23', oprright => '20', oprresult => '16', oprcom => '420', oprnegate => '37', oprcode => 'int48ge', oprrest => 'scalargesel', oprjoin => 'scalargejoinsel' }, { oid => '58', descr => 'less than', oprname => '<', oprleft => '16', oprright => '16', oprresult => '16', oprcom => '59', oprnegate => '1695', oprcode => 'boollt', oprrest => 'scalarltsel', oprjoin => 'scalarltjoinsel' }, { oid => '59', descr => 'greater than', oprname => '>', oprleft => '16', oprright => '16', oprresult => '16', oprcom => '58', oprnegate => '1694', oprcode => 'boolgt', oprrest => 'scalargtsel', oprjoin => 'scalargtjoinsel' }, { oid => '85', oid_symbol => 'BooleanNotEqualOperator', descr => 'not equal', oprname => '<>', oprleft => '16', oprright => '16', oprresult => '16', oprcom => '85', oprnegate => '91', oprcode => 'boolne', oprrest => 'neqsel', oprjoin => 'neqjoinsel' }, { oid => '91', oid_symbol => 'BooleanEqualOperator', descr => 'equal', oprname => '=', oprcanmerge => 't', oprcanhash => 't', oprleft => '16', oprright => '16', oprresult => '16', oprcom => '91', oprnegate => '85', oprcode => 'booleq', oprrest => 'eqsel', oprjoin => 'eqjoinsel' }, { oid => '1694', descr => 'less than or equal', oprname => '<=', oprleft => '16', oprright => '16', oprresult => '16', oprcom => '1695', oprnegate => '59', oprcode => 'boolle', oprrest => 'scalarlesel', oprjoin => 'scalarlejoinsel' }, { oid => '1695', descr => 'greater than or equal', oprname => '>=', oprleft => '16', oprright => '16', oprresult => '16', oprcom => '1694', oprnegate => '58', oprcode => 'boolge', oprrest => 'scalargesel', oprjoin => 'scalargejoinsel' }, { oid => '92', descr => 'equal', oprname => '=', oprcanmerge => 't', oprcanhash => 't', oprleft => '18', oprright => '18', oprresult => '16', oprcom => '92', oprnegate => '630', oprcode => 'chareq', oprrest => 'eqsel', oprjoin => 'eqjoinsel' }, { oid => '93', descr => 'equal', oprname => '=', oprcanmerge => 't', oprcanhash => 't', oprleft => '19', oprright => '19', oprresult => '16', oprcom => '93', oprnegate => '643', oprcode => 'nameeq', oprrest => 'eqsel', oprjoin => 'eqjoinsel' }, { oid => '94', descr => 'equal', oprname => '=', oprcanmerge => 't', oprcanhash => 't', oprleft => '21', oprright => '21', oprresult => '16', oprcom => '94', oprnegate => '519', oprcode => 'int2eq', oprrest => 'eqsel', oprjoin => 'eqjoinsel' }, { oid => '95', descr => 'less than', oprname => '<', oprleft => '21', oprright => '21', oprresult => '16', oprcom => '520', oprnegate => '524', oprcode => 'int2lt', oprrest => 'scalarltsel', oprjoin => 'scalarltjoinsel' }, { oid => '96', oid_symbol => 'Int4EqualOperator', descr => 'equal', oprname => '=', oprcanmerge => 't', oprcanhash => 't', oprleft => '23', oprright => '23', oprresult => '16', oprcom => '96', oprnegate => '518', oprcode => 'int4eq', oprrest => 'eqsel', oprjoin => 'eqjoinsel' }, { oid => '97', oid_symbol => 'Int4LessOperator', descr => 'less than', oprname => '<', oprleft => '23', oprright => '23', oprresult => '16', oprcom => '521', oprnegate => '525', oprcode => 'int4lt', oprrest => 'scalarltsel', oprjoin => 'scalarltjoinsel' }, { oid => '98', oid_symbol => 'TextEqualOperator', descr => 'equal', oprname => '=', oprcanmerge => 't', oprcanhash => 't', oprleft => '25', oprright => '25', oprresult => '16', oprcom => '98', oprnegate => '531', oprcode => 'texteq', oprrest => 'eqsel', oprjoin => 'eqjoinsel' }, { oid => '349', descr => 'append element onto end of array', oprname => '||', oprleft => '2277', oprright => '2283', oprresult => '2277', #---------------------------------------------------------------------- # # pg_opfamily.dat # Initial contents of the pg_opfamily system relation. # # Portions Copyright (c) 1996-2018, PostgreSQL Global Development Group # Portions Copyright (c) 1994, Regents of the University of California # # src/include/catalog/pg_opfamily.dat # #---------------------------------------------------------------------- [ { oid => '421', opfmethod => '403', opfname => 'abstime_ops' }, { oid => '397', opfmethod => '403', opfname => 'array_ops' }, { oid => '627', opfmethod => '405', opfname => 'array_ops' }, { oid => '423', opfmethod => '403', opfname => 'bit_ops' }, { oid => '424', oid_symbol => 'BOOL_BTREE_FAM_OID', opfmethod => '403', opfname => 'bool_ops' }, { oid => '426', oid_symbol => 'BPCHAR_BTREE_FAM_OID', opfmethod => '403', opfname => 'bpchar_ops' }, { oid => '427', opfmethod => '405', opfname => 'bpchar_ops' }, { oid => '428', oid_symbol => 'BYTEA_BTREE_FAM_OID', opfmethod => '403', opfname => 'bytea_ops' }, { oid => '429', opfmethod => '403', opfname => 'char_ops' }, { oid => '431', opfmethod => '405', opfname => 'char_ops' }, { oid => '434', opfmethod => '403', opfname => 'datetime_ops' }, { oid => '435', opfmethod => '405', opfname => 'date_ops' }, { oid => '1970', opfmethod => '403', opfname => 'float_ops' }, { oid => '1971', opfmethod => '405', opfname => 'float_ops' }, { oid => '1974', oid_symbol => 'NETWORK_BTREE_FAM_OID', opfmethod => '403', opfname => 'network_ops' }, { oid => '1975', opfmethod => '405', opfname => 'network_ops' }, { oid => '3550', opfmethod => '783', opfname => 'network_ops' }, { oid => '3794', opfmethod => '4000', opfname => 'network_ops' }, { oid => '1976', oid_symbol => 'INTEGER_BTREE_FAM_OID', opfmethod => '403', opfname => 'integer_ops' }, { oid => '1977', opfmethod => '405', opfname => 'integer_ops' }, { oid => '1982', opfmethod => '403', opfname => 'interval_ops' }, { oid => '1983', opfmethod => '405', opfname => 'interval_ops' }, { oid => '1984', opfmethod => '403', opfname => 'macaddr_ops' }, { oid => '1985', opfmethod => '405', opfname => 'macaddr_ops' }, { oid => '3371', opfmethod => '403', opfname => 'macaddr8_ops' }, { oid => '3372', opfmethod => '405', opfname => 'macaddr8_ops' }, { oid => '1986', oid_symbol => 'NAME_BTREE_FAM_OID', opfmethod => '403', opfname => 'name_ops' }, { oid => '1987', opfmethod => '405', opfname => 'name_ops' }, { oid => '1988', opfmethod => '403', opfname => 'numeric_ops' }, { oid => '1998', opfmethod => '405', opfname => 'numeric_ops' }, { oid => '1989', oid_symbol => 'OID_BTREE_FAM_OID', opfmethod => '403', opfname => 'oid_ops' }, { oid => '1990', opfmethod => '405', opfname => 'oid_ops' }, { oid => '1991', opfmethod => '403', opfname => 'oidvector_ops' }, { oid => '1992', opfmethod => '405', opfname => 'oidvector_ops' }, { oid => '2994', opfmethod => '403', opfname => 'record_ops' }, { oid => '3194', opfmethod => '403', opfname => 'record_image_ops' }, { oid => '1994', oid_symbol => 'TEXT_BTREE_FAM_OID', opfmethod => '403', opfname => 'text_ops' }, { oid => '1995', opfmethod => '405', opfname => 'text_ops' }, { oid => '1996', opfmethod => '403', opfname => 'time_ops' }, { oid => '1997', opfmethod => '405', opfname => 'time_ops' }, { oid => '1999', opfmethod => '405', opfname => 'timestamptz_ops' }, { oid => '2000', opfmethod => '403', opfname => 'timetz_ops' }, { oid => '2001', opfmethod => '405', opfname => 'timetz_ops' }, #---------------------------------------------------------------------- # # pg_pltemplate.dat # Initial contents of the pg_pltemplate system relation. # # Portions Copyright (c) 1996-2018, PostgreSQL Global Development Group # Portions Copyright (c) 1994, Regents of the University of California # # src/include/catalog/pg_pltemplate.dat # #---------------------------------------------------------------------- [ { tmplname => 'plpgsql', tmpltrusted => 't', tmpldbacreate => 't', tmplhandler => 'plpgsql_call_handler', tmplinline => 'plpgsql_inline_handler', tmplvalidator => 'plpgsql_validator', tmpllibrary => '$libdir/plpgsql', tmplacl => '_null_' }, { tmplname => 'pltcl', tmpltrusted => 't', tmpldbacreate => 't', tmplhandler => 'pltcl_call_handler', tmplinline => '_null_', tmplvalidator => '_null_', tmpllibrary => '$libdir/pltcl', tmplacl => '_null_' }, { tmplname => 'pltclu', tmpltrusted => 'f', tmpldbacreate => 'f', tmplhandler => 'pltclu_call_handler', tmplinline => '_null_', tmplvalidator => '_null_', tmpllibrary => '$libdir/pltcl', tmplacl => '_null_' }, { tmplname => 'plperl', tmpltrusted => 't', tmpldbacreate => 't', tmplhandler => 'plperl_call_handler', tmplinline => 'plperl_inline_handler', tmplvalidator => 'plperl_validator', tmpllibrary => '$libdir/plperl', tmplacl => '_null_' }, { tmplname => 'plperlu', tmpltrusted => 'f', tmpldbacreate => 'f', tmplhandler => 'plperlu_call_handler', tmplinline => 'plperlu_inline_handler', tmplvalidator => 'plperlu_validator', tmpllibrary => '$libdir/plperl', tmplacl => '_null_' }, { tmplname => 'plpythonu', tmpltrusted => 'f', tmpldbacreate => 'f', tmplhandler => 'plpython_call_handler', tmplinline => 'plpython_inline_handler', tmplvalidator => 'plpython_validator', tmpllibrary => '$libdir/plpython2', tmplacl => '_null_' }, { tmplname => 'plpython2u', tmpltrusted => 'f', tmpldbacreate => 'f', tmplhandler => 'plpython2_call_handler', tmplinline => 'plpython2_inline_handler', tmplvalidator => 'plpython2_validator', tmpllibrary => '$libdir/plpython2', tmplacl => '_null_' }, { tmplname => 'plpython3u', tmpltrusted => 'f', tmpldbacreate => 'f', tmplhandler => 'plpython3_call_handler', tmplinline => 'plpython3_inline_handler', tmplvalidator => 'plpython3_validator', tmpllibrary => '$libdir/plpython3', tmplacl => '_null_' }, ] #---------------------------------------------------------------------- # # pg_proc.dat # Initial contents of the pg_proc system relation. # # Portions Copyright (c) 1996-2018, PostgreSQL Global Development Group # Portions Copyright (c) 1994, Regents of the University of California # # src/include/catalog/pg_proc.dat # #---------------------------------------------------------------------- [ # Note: every entry in pg_proc.h is expected to have a DESCR() comment, # except for functions that implement pg_operator.h operators and don't # have a good reason to be called directly rather than via the operator. # (If you do expect such a function to be used directly, you should # duplicate the operator's comment.) initdb will supply suitable default # comments for functions referenced by pg_operator. # Try to follow the style of existing functions' comments. # Some recommended conventions: # "I/O" for typinput, typoutput, typreceive, typsend functions # "I/O typmod" for typmodin, typmodout functions # "aggregate transition function" for aggtransfn functions, unless # they are reasonably useful in their own right # "aggregate final function" for aggfinalfn functions (likewise) # "convert srctypename to desttypename" for cast functions # "less-equal-greater" for B-tree comparison functions # keep the following ordered by OID so that later changes can be made easier # OIDS 1 - 99 { oid => '1242', descr => 'I/O', proname => 'boolin', proisstrict => 't', provolatile => 'i', proparallel => 's', pronargs => '1', prorettype => '16', proargtypes => '2275', prosrc => 'boolin' }, { oid => '1243', descr => 'I/O', proname => 'boolout', proisstrict => 't', provolatile => 'i', proparallel => 's', pronargs => '1', prorettype => '2275', proargtypes => '16', prosrc => 'boolout' }, { oid => '1244', descr => 'I/O', proname => 'byteain', proisstrict => 't', provolatile => 'i', proparallel => 's', pronargs => '1', prorettype => '17', proargtypes => '2275', prosrc => 'byteain' }, { oid => '31', descr => 'I/O', proname => 'byteaout', proisstrict => 't', provolatile => 'i', proparallel => 's', pronargs => '1', prorettype => '2275', proargtypes => '17', prosrc => 'byteaout' }, { oid => '1245', descr => 'I/O', proname => 'charin', proisstrict => 't', provolatile => 'i', proparallel => 's', pronargs => '1', prorettype => '18', proargtypes => '2275', prosrc => 'charin' }, { oid => '33', descr => 'I/O', proname => 'charout', proisstrict => 't', provolatile => 'i', proparallel => 's', pronargs => '1', prorettype => '2275', proargtypes => '18', prosrc => 'charout' }, { oid => '34', descr => 'I/O', proname => 'namein', proisstrict => 't', provolatile => 'i', proparallel => 's', pronargs => '1', prorettype => '19', proargtypes => '2275', prosrc => 'namein' }, { oid => '35', descr => 'I/O', proname => 'nameout', proisstrict => 't', provolatile => 'i', proparallel => 's', pronargs => '1', prorettype => '2275', proargtypes => '19', prosrc => 'nameout' }, { oid => '38', descr => 'I/O', proname => 'int2in', proisstrict => 't', provolatile => 'i', proparallel => 's', pronargs => '1', prorettype => '21', proargtypes => '2275', prosrc => 'int2in' }, { oid => '39', descr => 'I/O', proname => 'int2out', proisstrict => 't', provolatile => 'i', proparallel => 's', pronargs => '1', prorettype => '2275', proargtypes => '21', prosrc => 'int2out' }, { oid => '40', descr => 'I/O', proname => 'int2vectorin', proisstrict => 't', provolatile => 'i', proparallel => 's', pronargs => '1', prorettype => '22', proargtypes => '2275', prosrc => 'int2vectorin' }, { oid => '41', descr => 'I/O', proname => 'int2vectorout', proisstrict => 't', provolatile => 'i', proparallel => 's', pronargs => '1', prorettype => '2275', proargtypes => '22', prosrc => 'int2vectorout' }, { oid => '42', descr => 'I/O', proname => 'int4in', proisstrict => 't', provolatile => 'i', proparallel => 's', pronargs => '1', prorettype => '23', proargtypes => '2275', prosrc => 'int4in' }, { oid => '43', descr => 'I/O', proname => 'int4out', proisstrict => 't', provolatile => 'i', proparallel => 's', pronargs => '1', prorettype => '2275', proargtypes => '23', prosrc => 'int4out' }, { oid => '44', descr => 'I/O', proname => 'regprocin', proisstrict => 't', provolatile => 's', proparallel => 's', pronargs => '1', prorettype => '24', proargtypes => '2275', prosrc => 'regprocin' }, { oid => '45', descr => 'I/O', proname => 'regprocout', proisstrict => 't', provolatile => 's', proparallel => 's', pronargs => '1', prorettype => '2275', proargtypes => '24', prosrc => 'regprocout' }, { oid => '3494', descr => 'convert proname to regproc', proname => 'to_regproc', proisstrict => 't', provolatile => 's', #---------------------------------------------------------------------- # # pg_range.dat # Initial contents of the pg_range system relation. # # Portions Copyright (c) 1996-2018, PostgreSQL Global Development Group # Portions Copyright (c) 1994, Regents of the University of California # # src/include/catalog/pg_range.dat # #---------------------------------------------------------------------- [ { rngtypid => '3904', rngsubtype => '23', rngcollation => '0', rngsubopc => '1978', rngcanonical => 'int4range_canonical', rngsubdiff => 'int4range_subdiff' }, { rngtypid => '3906', rngsubtype => '1700', rngcollation => '0', rngsubopc => '3125', rngcanonical => '-', rngsubdiff => 'numrange_subdiff' }, { rngtypid => '3908', rngsubtype => '1114', rngcollation => '0', rngsubopc => '3128', rngcanonical => '-', rngsubdiff => 'tsrange_subdiff' }, { rngtypid => '3910', rngsubtype => '1184', rngcollation => '0', rngsubopc => '3127', rngcanonical => '-', rngsubdiff => 'tstzrange_subdiff' }, { rngtypid => '3912', rngsubtype => '1082', rngcollation => '0', rngsubopc => '3122', rngcanonical => 'daterange_canonical', rngsubdiff => 'daterange_subdiff' }, { rngtypid => '3926', rngsubtype => '20', rngcollation => '0', rngsubopc => '3124', rngcanonical => 'int8range_canonical', rngsubdiff => 'int8range_subdiff' }, # prototypes for functions in pg_range.c ] #---------------------------------------------------------------------- # # pg_tablespace.dat # Initial contents of the pg_tablespace system relation. # # Portions Copyright (c) 1996-2018, PostgreSQL Global Development Group # Portions Copyright (c) 1994, Regents of the University of California # # src/include/catalog/pg_tablespace.dat # #---------------------------------------------------------------------- [ { oid => '1663', oid_symbol => 'DEFAULTTABLESPACE_OID', spcname => 'pg_default', spcowner => 'PGUID', spcacl => '_null_', spcoptions => '_null_' }, { oid => '1664', oid_symbol => 'GLOBALTABLESPACE_OID', spcname => 'pg_global', spcowner => 'PGUID', spcacl => '_null_', spcoptions => '_null_' }, ] #---------------------------------------------------------------------- # # pg_ts_config.dat # Initial contents of the pg_ts_config system relation. # # Portions Copyright (c) 1996-2018, PostgreSQL Global Development Group # Portions Copyright (c) 1994, Regents of the University of California # # src/include/catalog/pg_ts_config.dat # #---------------------------------------------------------------------- [ { oid => '3748', descr => 'simple configuration', cfgname => 'simple', cfgnamespace => 'PGNSP', cfgowner => 'PGUID', cfgparser => '3722' }, ] #---------------------------------------------------------------------- # # pg_ts_config_map.dat # Initial contents of the pg_ts_config_map system relation. # # Portions Copyright (c) 1996-2018, PostgreSQL Global Development Group # Portions Copyright (c) 1994, Regents of the University of California # # src/include/catalog/pg_ts_config_map.dat # #---------------------------------------------------------------------- [ { mapcfg => '3748', maptokentype => '1', mapseqno => '1', mapdict => '3765' }, { mapcfg => '3748', maptokentype => '2', mapseqno => '1', mapdict => '3765' }, { mapcfg => '3748', maptokentype => '3', mapseqno => '1', mapdict => '3765' }, { mapcfg => '3748', maptokentype => '4', mapseqno => '1', mapdict => '3765' }, { mapcfg => '3748', maptokentype => '5', mapseqno => '1', mapdict => '3765' }, { mapcfg => '3748', maptokentype => '6', mapseqno => '1', mapdict => '3765' }, { mapcfg => '3748', maptokentype => '7', mapseqno => '1', mapdict => '3765' }, { mapcfg => '3748', maptokentype => '8', mapseqno => '1', mapdict => '3765' }, { mapcfg => '3748', maptokentype => '9', mapseqno => '1', mapdict => '3765' }, { mapcfg => '3748', maptokentype => '10', mapseqno => '1', mapdict => '3765' }, { mapcfg => '3748', maptokentype => '11', mapseqno => '1', mapdict => '3765' }, { mapcfg => '3748', maptokentype => '15', mapseqno => '1', mapdict => '3765' }, { mapcfg => '3748', maptokentype => '16', mapseqno => '1', mapdict => '3765' }, { mapcfg => '3748', maptokentype => '17', mapseqno => '1', mapdict => '3765' }, { mapcfg => '3748', maptokentype => '18', mapseqno => '1', mapdict => '3765' }, { mapcfg => '3748', maptokentype => '19', mapseqno => '1', mapdict => '3765' }, { mapcfg => '3748', maptokentype => '20', mapseqno => '1', mapdict => '3765' }, { mapcfg => '3748', maptokentype => '21', mapseqno => '1', mapdict => '3765' }, { mapcfg => '3748', maptokentype => '22', mapseqno => '1', mapdict => '3765' }, ] #---------------------------------------------------------------------- # # pg_ts_dict.dat # Initial contents of the pg_ts_dict system relation. # # Portions Copyright (c) 1996-2018, PostgreSQL Global Development Group # Portions Copyright (c) 1994, Regents of the University of California # # src/include/catalog/pg_ts_dict.dat # #---------------------------------------------------------------------- [ { oid => '3765', descr => 'simple dictionary: just lower case and check for stopword', dictname => 'simple', dictnamespace => 'PGNSP', dictowner => 'PGUID', dicttemplate => '3727', dictinitoption => '_null_' }, ] #---------------------------------------------------------------------- # # pg_ts_parser.dat # Initial contents of the pg_ts_parser system relation. # # Portions Copyright (c) 1996-2018, PostgreSQL Global Development Group # Portions Copyright (c) 1994, Regents of the University of California # # src/include/catalog/pg_ts_parser.dat # #---------------------------------------------------------------------- [ { oid => '3722', descr => 'default word parser', prsname => 'default', prsnamespace => 'PGNSP', prsstart => 'prsd_start', prstoken => 'prsd_nexttoken', prsend => 'prsd_end', prsheadline => 'prsd_headline', prslextype => 'prsd_lextype' }, ] #---------------------------------------------------------------------- # # pg_ts_template.dat # Initial contents of the pg_ts_template system relation. # # Portions Copyright (c) 1996-2018, PostgreSQL Global Development Group # Portions Copyright (c) 1994, Regents of the University of California # # src/include/catalog/pg_ts_template.dat # #---------------------------------------------------------------------- [ { oid => '3727', descr => 'simple dictionary: just lower case and check for stopword', tmplname => 'simple', tmplnamespace => 'PGNSP', tmplinit => 'dsimple_init', tmpllexize => 'dsimple_lexize' }, { oid => '3730', descr => 'synonym dictionary: replace word by its synonym', tmplname => 'synonym', tmplnamespace => 'PGNSP', tmplinit => 'dsynonym_init', tmpllexize => 'dsynonym_lexize' }, { oid => '3733', descr => 'ispell dictionary', tmplname => 'ispell', tmplnamespace => 'PGNSP', tmplinit => 'dispell_init', tmpllexize => 'dispell_lexize' }, { oid => '3742', descr => 'thesaurus dictionary: phrase by phrase substitution', tmplname => 'thesaurus', tmplnamespace => 'PGNSP', tmplinit => 'thesaurus_init', tmpllexize => 'thesaurus_lexize' }, ] #---------------------------------------------------------------------- # # pg_type.dat # Initial contents of the pg_type system relation. # # Portions Copyright (c) 1996-2018, PostgreSQL Global Development Group # Portions Copyright (c) 1994, Regents of the University of California # # src/include/catalog/pg_type.dat # #---------------------------------------------------------------------- [ # Keep the following ordered by OID so that later changes can be made more # easily. # For types used in the system catalogs, make sure the values here match # TypInfo[] in bootstrap.c. # OIDS 1 - 99 { oid => '16', oid_symbol => 'BOOLOID', descr => 'boolean, \'true\'/\'false\'', typname => 'bool', typlen => '1', typbyval => 't', typcategory => 'B', typispreferred => 't', typarray => '1000', typinput => 'boolin', typoutput => 'boolout', typreceive => 'boolrecv', typsend => 'boolsend', typalign => 'c' }, { oid => '17', oid_symbol => 'BYTEAOID', descr => 'variable-length string, binary values escaped', typname => 'bytea', typlen => '-1', typbyval => 'f', typcategory => 'U', typarray => '1001', typinput => 'byteain', typoutput => 'byteaout', typreceive => 'bytearecv', typsend => 'byteasend', typalign => 'i', typstorage => 'x' }, { oid => '18', oid_symbol => 'CHAROID', descr => 'single character', typname => 'char', typlen => '1', typbyval => 't', typcategory => 'S', typarray => '1002', typinput => 'charin', typoutput => 'charout', typreceive => 'charrecv', typsend => 'charsend', typalign => 'c' }, { oid => '19', oid_symbol => 'NAMEOID', descr => '63-byte type for storing system identifiers', typname => 'name', typlen => 'NAMEDATALEN', typbyval => 'f', typcategory => 'S', typelem => '18', typarray => '1003', typinput => 'namein', typoutput => 'nameout', typreceive => 'namerecv', typsend => 'namesend', typalign => 'c' }, { oid => '20', oid_symbol => 'INT8OID', descr => '~18 digit integer, 8-byte storage', typname => 'int8', typlen => '8', typbyval => 'FLOAT8PASSBYVAL', typcategory => 'N', typarray => '1016', typinput => 'int8in', typoutput => 'int8out', typreceive => 'int8recv', typsend => 'int8send', typalign => 'd' }, { oid => '21', oid_symbol => 'INT2OID', descr => '-32 thousand to 32 thousand, 2-byte storage', typname => 'int2', typlen => '2', typbyval => 't', typcategory => 'N', typarray => '1005', typinput => 'int2in', typoutput => 'int2out', typreceive => 'int2recv', typsend => 'int2send', typalign => 's' }, { oid => '22', oid_symbol => 'INT2VECTOROID', descr => 'array of int2, used in system tables', typname => 'int2vector', typlen => '-1', typbyval => 'f', typcategory => 'A', typelem => '21', typarray => '1006', typinput => 'int2vectorin', typoutput => 'int2vectorout', typreceive => 'int2vectorrecv', typsend => 'int2vectorsend', typalign => 'i' }, { oid => '23', oid_symbol => 'INT4OID', descr => '-2 billion to 2 billion integer, 4-byte storage', typname => 'int4', typlen => '4', typbyval => 't', typcategory => 'N', typarray => '1007', typinput => 'int4in', typoutput => 'int4out', typreceive => 'int4recv', typsend => 'int4send', typalign => 'i' }, { oid => '24', oid_symbol => 'REGPROCOID', descr => 'registered procedure', typname => 'regproc', typlen => '4', typbyval => 't', typcategory => 'N', typarray => '1008', typinput => 'regprocin', typoutput => 'regprocout', typreceive => 'regprocrecv', typsend => 'regprocsend', typalign => 'i' }, { oid => '25', oid_symbol => 'TEXTOID', descr => 'variable-length string, no limit specified', typname => 'text', typlen => '-1', typbyval => 'f', typcategory => 'S', typispreferred => 't', typarray => '1009', typinput => 'textin', typoutput => 'textout', typreceive => 'textrecv', typsend => 'textsend', typalign => 'i', typstorage => 'x', typcollation => '100' }, { oid => '26', oid_symbol => 'OIDOID', descr => 'object identifier(oid), maximum 4 billion', typname => 'oid', typlen => '4', typbyval => 't', typcategory => 'N', typispreferred => 't', typarray => '1028', typinput => 'oidin', typoutput => 'oidout', typreceive => 'oidrecv', typsend => 'oidsend', typalign => 'i' }, { oid => '27', oid_symbol => 'TIDOID', descr => '(block, offset), physical location of tuple', typname => 'tid', typlen => '6', typbyval => 'f', typcategory => 'U', typarray => '1010', typinput => 'tidin', typoutput => 'tidout', typreceive => 'tidrecv', typsend => 'tidsend', typalign => 's' }, { oid => '28', oid_symbol => 'XIDOID', descr => 'transaction id', typname => 'xid', typlen => '4', typbyval => 't', typcategory => 'U', typarray => '1011', typinput => 'xidin', typoutput => 'xidout',