-- -- Selected TOC Entries: -- -- -- TOC Entry ID 1 (OID 18816) -- -- Name: megatab Type: TABLE Owner: pgsql -- \connect - pgsql CREATE TABLE "megatab" ( "a_adbin" text, "a_adnum" int2, "a_adrelid" oid, "a_adsrc" text, "a_aggbasetype" oid, "a_aggfinalfn" regproc, "a_aggfinaltype" oid, "a_agginitval1" text, "a_agginitval2" text, "a_aggname" name, "a_aggowner" int4, "a_aggtransfn1" regproc, "a_aggtransfn2" regproc, "a_aggtranstype1" oid, "a_aggtranstype2" oid, "a_ambeginscan" regproc, "a_ambuild" regproc, "a_amclose" regproc, "a_amcostestimate" regproc, "a_amcreate" regproc, "a_amdelete" regproc, "a_amdestroy" regproc, "a_amendscan" regproc, "a_amfreetuple" regproc, "a_amgetattr" regproc, "a_amgettuple" regproc, "a_amid" oid, "a_aminsert" regproc, "a_ammarkpos" regproc, "a_amname" name, "a_amopclaid" oid, "a_amopen" regproc, "a_amopid" oid, "a_amopopr" oid, "a_amopstrategy" int2, "a_amorderstrategy" int2, "a_amowner" int4, "a_amprocnum" int2, "a_amproc" oid, "a_amrescan" regproc, "a_amrestrpos" regproc, "a_amsetlock" regproc, "a_amsettid" regproc, "a_amstrategies" int2, "a_amsupport" int2, "a_attalign" character, "a_attbyval" bool, "a_attcacheoff" int4, "a_attdisbursion" float4, "a_atthasdef" bool, "a_attisset" bool, "a_attlen" int2, "a_attname" name, "a_attnelems" int4, "a_attnotnull" bool, "a_attnum" int2, "a_attrelid" oid, "a_attstorage" character, "a_atttypid" oid, "a_atttypmod" int4, "a_chunk_data" bytea, "a_chunk_id" oid, "a_chunk_seq" int4, "a_datdba" int4, "a_datname" name, "a_datpath" text, "a_definition" text, "a_description" text, "a_encoding" int4, "a_ev_action" lztext, "a_ev_attr" int2, "a_ev_class" oid, "a_ev_qual" lztext, "a_ev_type" character, "a_grolist" "_int4", "a_groname" name, "a_grosysid" int4, "a_hasindexes" bool, "a_hasrules" bool, "a_hastriggers" bool, "a_indclass" oidvector, "a_indexdef" text, "a_indexname" name, "a_indexrelid" oid, "a_indhaskeytype" bool, "a_indisclustered" bool, "a_indislossy" bool, "a_indisprimary" bool, "a_indisunique" bool, "a_indkey" int2vector, "a_indpred" text, "a_indproc" oid, "a_indreference" oid, "a_ierxY(@(@Y(@(@Yint4inYint4(@(@int4inYint4outY0Y,(@(@-Z16564Zpgsql(Z165788Z501HZpg_indexXZ4hZ4xZint4inZint4outZint4inZint4outZ0Z,Z-Z16577Zpgsql[16599[501([pg_statistic@[4P[4`[int4inp[int4out[int4in[int4out[0[,[-[16598[pgsql[16616\501\pg_opera \40\4@\int4inP\int4out`\int4inp\int4out\0\,\-\16615\pgsql\16642\501\pg_opcla]4]4 ]int4in0]int4out@]int4inP]int4out`]0p],]-]16641]pgsql]16653]501]pg_am]4]4^int4in^int4out ^int4in0^int4out@^0P^,`^-p^16652^pgsql^16685^501^pg_amop^4^4^int4in^int4out_int4in_int4out _00_,@_-P_16684`_pgsqlp_16862_501_pg_ampro_4_4_int4in_int4out_int4in_int4out`0`, `-0`16861@`pgsqlP`16928``501p`pg_langu`4`4`int4in`int4out`int4in`int4out`0`,a-a16927 apgsql0a16942@a501Papg_aggregateha4xa4aint4inaint4outaint4inaint4outa0a,a-a16941bpgsqlb17007(b5018bpg_iplHb4Xb4hbint4inxbint4outbint4inbint4outb0b,b-b17006bpgsqlb17019c501cpg_inheritproc0c4@c4Pcint4in`cint4outpcint4incint4outc0c,c-c17018cpgsqlc17032c501dpg_rewrid4 d40dint4in@dint4outPdint4in`dint4outpd0d,d-d17031dpgsqld17048d501dpg_listed4e4eint4in eint4out0eint4in@eint4outPe0`e,pe-e17047epgsqle17060e501epg_descriptione4e4eint4infint4outfint4in(fint4out8f0Hf,Xf-hf17059xfpgsqlf17281f501fpg_toast_17031f4f4fint4infint4outgint4ingint4out g00g,@g-Pg17280`gpgsqlpg17313g501gpg_userg4g4gint4ingint4outgint4ingint4outh0h, h-0h17312@hpgsqlPh17345`h501phpg_rulesh4h4hint4inhint4outhint4inhint4outh0h,i-i17344 ipgsql0i17377@i501Pipg_views`i4pi4iint4iniint4outiint4iniint4outi0i,i-i17376jpgsqlj17409 j5010jpg_table@j4Pj4`jint4inpjint4outjint4injint4outj0j,j-j17408jpgsqlj17441k501kpg_index k40k4@kint4inPkint4out`kint4inpkint4outk0k,k-k17440kpgsqlk18817k501kmegatabl4l4 lint4in0lint4out@lint4inPlint4out`l0pl,l-l18816lpgsqll19507l501lpg_toast_18816l4l4mint4inmint4out(mint4in8mint4outHm0Xm,hm-xm19506mpgsqlm19522m501mmegaviewm4m4mint4inmint4outnint4innint4out(n08n,Hn-Xn19521hnpgsql; SELECT description FROM pg_description WHERE objoid = 18874 "a_adsrc" text, "a_aggbasetype" oid, "a_aggfinalfn" regproc, "a_aggfinaltype" oid, "a_agginitval1" text, "a_agginitval2" text, "a_aggname" name, "a_aggowner" int4, "a_aggtransfn1" regproc, ; SELECT description FROM pg_description WHERE objoid = 18875pro ld" (@(@descriptionmcostestimate" regproc, "a_amcreate" regproc, "a_amdelete" regproc, "a_amdestroy" regproc, "a_amendscan" regproc, "a_amfreetupl; SELECT description FROM pg_description WHERE objoid = 18876pro kposq (@(@descriptionpclaid" oid, "a_amopen" regproc, "a_amopid" oid, "a_amopopr" oid, "a_amopstrategy" int2, "a_amorderstrategy" int2, "a_amowner"; SELECT description FROM pg_description WHERE objoid = 18877 "a regpY (@(@descriptionrategies" int2, "a_amsupport" int2, "a_attalign" character, "a_attbyval" bool, "a_attcacheoff" int4, "a_attdisbursion" float4, ; SELECT description FROM pg_description WHERE objoid = 18878int tnulA (@(@descriptionlid" oid, "a_attstorage" character, "a_atttypid" oid, "a_atttypmod" int4, "a_chunk_data" bytea, "a_chunk_id" oid, "a_chunk_seq; SELECT description FROM pg_description WHERE objoid = 18879cri  "a) (@(@descriptionxt, "a_ev_attr" int2, "a_ev_class" oid, "a_ev_qual" lztext, "a_ev_type" character, "a_grolist" "_int4", "a_groname" name, "a_; SELECT description FROM pg_description WHERE objoid = 18880" o a_in (@(@description"a_indexrelid" oid, "a_indhaskeytype" bool, "a_indisclustered" bool, "a_indislossy" bool, "a_indisprimary" bool, "a_indisunique0; SELECT description FROM pg_description WHERE objoid = 18882"a_ d, p ع@id" oid, "a_inhdefrelid" oid, "a_inhparent" oid, "a_inhproc" oid, "a_inhproname" name, "a_inhrelid" oid, "a_inhseqno" int4, "a_iplipl" oid, "a_iplre SELECT description FROM pg_description WHERE objoid = 189140@ " ame,@@llfoid" oid, "a_lanpltrusted" bool, "a_listenerpid" int4, "a_logfoo" oid, "a_not(@(@nt4, "a_objoid" oid, "a_opcdeftype" oid, SELECT description FROM pg_description WHERE objoid = 189150@ bo oin"@@a_oprkind" character, "a_oprleft" oid, "a_oprlsortop" oid, "a_oprname" name, "a_oprnegate" oid, i(@(@" int4, "a_oprprec" int2, SELECT description FROM pg_description WHERE objoid = 189160@tex gtypx@x@r, "a_probin" bytea, "a_probyte_pct" int4, "a_proiscachable" bool, "a_proisinh" bool, "a_proisstrict" bool, "aQ(@(@d" bool, "a SELECT description FROM pg_description WHERE objoid = 18917in_ratio" int4, "a_proowner" int4, "a_properbyte_cpu" int4, "a_propercall_cpu" int4, "a_proretset" bool, "a_prorettype" oid, "a_prosrc" text, "a_rcbin" text, "a_rcname" name, "a_rcrel9(@ SELECT description FROM pg_description WHERE objoid = 189180@int sind8@8@a_relhaspkey" bool, "a_relhasrules" bool, "a_relhassubclass" bool, "a_relisshared" bool, "a_relkind" character, "a_relname" name, "a_r SELECT description FROM pg_description WHERE objoid = 189190@oid streظ@ظ@a_reltriggers" int2, "a_reltuples" int4, "a_reltype" oid, "a_relukeys" int2, "a_rulename" name, "a_staattnum" int2, "a_stacommonfrac" SELECT description FROM pg_description WHERE objoid = 189200@t4, oid,з@з@d" oid, "a_tablename" name, "a_tableowner" name, "a_tgargs" byteaa(@(@" int2vector, "a_tgconstrname" name, "a_tgconstrrelid" rr8;19539@}a_ambuildregproc19540@Xa_amcloseregproc)19541@*a_amcostestimate,regproc.19542@x/a_amcreateregproc219543@3a_amdeleteregproc619544@l8a_amdestroyregproc8;19545@<a_amendscanregproct?19546@4a_amfreetuplePregproc19547@ a_amgetattrregproc 19548@xa_amgettuple  regproc"19549@l#a_amid@(oid(@`*19550@+a_aminsertregproc.19551@ 0a_ammarkposregproc319552@4a_amname5name@l719553@Aa_amopclaidoid(@C19554@\Ea_amopenFregprocHH19555@Ia_amopidKoid(@L19556@Na_amopoproid(@Q19557@Ra_amopstrategyTint2@V19558@|Wa_amorderstrategyint2@X[19559@\a_amowner( @(@ription((((19654132a_oprrsortopoid-1ff().)2);)@)C)E)19655133a_passwdtext-1ff)) ) ))))19656134a_proargtypesoidvector-1) @(@)))**19657135a_probinbytea-1ff<*B* F*T*Y*\*^*19658136a_probyte_pctint4-1ff*******19659137a_proiscachablebool-1f@@megatabABLETABLE@ "a$ ;% ;& ;|;};~;;;;P1;X2;`3;h4;p5;l-1+ DROP TABLE "megaview"; +,-,19663141a_prolangoid-1ffh,n, r,|,,,,19664142a_pronamename-1ff,, ,,,,,19665143a_pronargsint2-1ffnam--; SELECT description FROM pg_description WHERE objoid = 18871 "a_adsrc" text, "a_aggbasetype" oid, "a_aggfinalfn" regproc, "a_aggfinaltype" oid, "a_agginitval1" text, "a_agginitval2" text, "a_aggname" name, "a_aggowner" int4, "a_aggtransfn1" regproc, .; SELECT description FROM pg_description WHERE objoid = 18872pro ld" ) (@(@descriptionmcostestimate" regproc, "a_amcreate" regproc, "a_amdelete" regproc, "a_amdestroy" regproc, "a_amendscan" regproc, "a_amfreetupl0/; SELECT description FROM pg_description WHERE objoid = 18873pro kpos (@(@descriptionpclaid" oid, "a_amopen" regproc, "a_amopid" oid, "a_amopopr" oid, "a_amopstrategy" int2, "a_amorderstrategy" int2, "a_amowner"H0; SELECT description-- -- TOC Entry ID 2 (OID 19521) -- -- Name: megaview Type: TABLE Owner: pgsql -- CREATE TABLE "megaview" ( "a_adbin" text, "a_adnum" int2, "a_adrelid" oid, "a_adsrc" text, "a_aggbasetype" oid, "a_aggfinalfn" regproc, "a_aggfinaltype" oid, "a_agginitval1" text, "a_agginitval2" text, "a_aggname" name, "a_aggowner" int4, "a_aggtransfn1" regproc, "a_aggtransfn2" regproc, "a_aggtranstype1" oid, "a_aggtranstype2" oid, "a_ambeginscan" regproc, "a_ambuild" regproc, "a_amclose" regproc, "a_amcostestimate" regproc, "a_amcreate" regproc, "a_amdelete" regproc, "a_amdestroy" regproc, "a_amendscan" regproc, "a_amfreetuple" regproc, "a_amgetattr" regproc, "a_amgettuple" regproc, "a_amid" oid, "a_aminsert" regproc, "a_ammarkpos" regproc, "a_amname" name, "a_amopclaid" oid, "a_amopen" regproc, "a_amopid" oid, "a_amopopr" oid, "a_amopstrategy" int2, "a_amorderstrategy" int2, "a_amowner" int4, "a_amprocnum" int2, "a_amproc" oid, "a_amrescan" regproc, "a_amrestrpos" regproc, "a_amsetlock" regproc, "a_amsettid" regproc, "a_amstrategies" int2, "a_amsupport" int2, "a_attalign" character, "a_attbyval" bool, "a_attcacheoff" int4, "a_attdisbursion" float4, "a_atthasdef" bool, "a_attisset" bool, "a_attlen" int2, "a_attname" name, "a_attnelems" int4, "a_attnotnull" bool, "a_attnum" int2, "a_attrelid" oid, "a_attstorage" character, "a_atttypid" oid, "a_atttypmod" int4, "a_chunk_data" bytea, "a_chunk_id" oid, "a_chunk_seq" int4, "a_datdba" int4, "a_datname" name, "a_datpath" text, "a_definition" text, "a_description" text, "a_encoding" int4, "a_ev_action" lztext, "a_ev_attr" int2, "a_ev_class" oid, "a_ev_qual" lztext, "a_ev_type" character, "a_grolist" "_int4", "a_groname" name, "a_grosysid" int4, "a_hasindexes" bool, "a_hasrules" bool, "a_hastriggers" bool, "a_indclass" oidvector, "a_indexdef" text, "a_indexname" name, "a_indexrelid" oid, "a_indhaskeytype" bool, "a_indisclustered" bool, "a_indislossy" bool, "a_indisprimary" bool, "a_indisunique" bool, "a_indkey" int2vector, "a_indpred" text, "a_indproc" oid, "a_indreference" oid, "a_erxY(@(@Y(@(@Yint4inYint4(@(@int4inYint4outY0Y,(@(@-Z16564Zpgsql(Z165788Z501HZpg_indexXZ4hZ4xZint4inZint4outZint4inZint4outZ0Z,Z-Z16577Zpgsql[16599[501([pg_statistic@[4P[4`[int4inp[int4out[int4in[int4out[0[,[-[16598[pgsql[16616\501\pg_opera \40\4@\int4inP\int4out`\int4inp\int4out\0\,\-\16615\pgsql\16642\501\pg_opcla]4]4 ]int4in0]int4out@]int4inP]int4out`]0p],]-]16641]pgsql]16653]501]pg_am]4]4^int4in^int4out ^int4in0^int4out@^0P^,`^-p^16652^pgsql^16685^501^pg_amop^4^4^int4in^int4out_int4in_int4out _00_,@_-P_16684`_pgsqlp_16862_501_pg_ampro_4_4_int4in_int4out_int4in_int4out`0`, `-0`16861@`pgsqlP`16928``501p`pg_langu`4`4`int4in`int4out`int4in`int4out`0`,a-a16927 apgsql0a16942@a501Papg_aggregateha4xa4aint4inaint4outaint4inaint4outa0a,a-a16941bpgsqlb17007(b5018bpg_iplHb4Xb4hbint4inxbint4outbint4inbint4outb0b,b-b17006bpgsqlb17019c501cpg_inheritproc0c4@c4Pcint4in`cint4outpcint4incint4outc0c,c-c17018cpgsqlc17032c501dpg_rewrid4 d40dint4in@dint4outPdint4in`dint4outpd0d,d-d17031dpgsqld17048d501dpg_listed4e4eint4in eint4out0eint4in@eint4outPe0`e,pe-e17047epgsqle17060e501epg_descriptione4e4eint4infint4outfint4in(fint4out8f0Hf,Xf-hf17059xfpgsqlf17281f501fpg_toast_17031f4f4fint4infint4outgint4ingint4out g00g,@g-Pg17280`gpgsqlpg17313g501gpg_userg4g4gint4ingint4outgint4ingint4outh0h, h-0h17312@hpgsqlPh17345`h501phpg_rulesh4h4hint4inhint4outhint4inhint4outh0h,i-i17344 ipgsql0i17377@i501Pipg_views`i4pi4iint4iniint4outiint4iniint4outi0i,i-i17376jpgsqlj17409 j5010jpg_table@j4Pj4`jint4inpjint4outjint4injint4outj0j,j-j17408jpgsqlj17441k501kpg_index k40k4@kint4inPkint4out`kint4inpkint4outk0k,k-k17440kpgsqlk18817k501kmegatabl4l4 lint4in0lint4out@lint4inPlint4out`l0pl,l-l18816lpgsqll19507l501lpg_toast_18816l4l4mint4inmint4out(mint4in8mint4outHm0Xm,hm-xm19506mpgsqlm19522m501mmegaviewm4m4mint4inmint4outnint4innint4out(n08n,Hn-Xn19521hnpgsql; SELECT description FROM pg_description WHERE objoid = 18874 "a_adsrc" text, "a_aggbasetype" oid, "a_aggfinalfn" regproc, "a_aggfinaltype" oid, "a_agginitval1" text, "a_agginitval2" text, "a_aggname" name, "a_aggowner" int4, "a_aggtransfn1" regproc, ; SELECT description FROM pg_description WHERE objoid = 18875pro ld" (@(@descriptionmcostestimate" regproc, "a_amcreate" regproc, "a_amdelete" regproc, "a_amdestroy" regproc, "a_amendscan" regproc, "a_amfreetupl; SELECT description FROM pg_description WHERE objoid = 18876pro kposq (@(@descriptionpclaid" oid, "a_amopen" regproc, "a_amopid" oid, "a_amopopr" oid, "a_amopstrategy" int2, "a_amorderstrategy" int2, "a_amowner"; SELECT description FROM pg_description WHERE objoid = 18877 "a regpY (@(@descriptionrategies" int2, "a_amsupport" int2, "a_attalign" character, "a_attbyval" bool, "a_attcacheoff" int4, "a_attdisbursion" float4, ; SELECT description FROM pg_description WHERE objoid = 18878int tnulA (@(@descriptionlid" oid, "a_attstorage" character, "a_atttypid" oid, "a_atttypmod" int4, "a_chunk_data" bytea, "a_chunk_id" oid, "a_chunk_seq; SELECT description FROM pg_description WHERE objoid = 18879cri  "a) (@(@descriptionxt, "a_ev_attr" int2, "a_ev_class" oid, "a_ev_qual" lztext, "a_ev_type" character, "a_grolist" "_int4", "a_groname" name, "a_; SELECT description FROM pg_description WHERE objoid = 18880" o a_in (@(@description"a_indexrelid" oid, "a_indhaskeytype" bool, "a_indisclustered" bool, "a_indislossy" bool, "a_indisprimary" bool, "a_indisunique0; SELECT description FROM pg_description WHERE objoid = 18882"a_ d, p ع@id" oid, "a_inhdefrelid" oid, "a_inhparent" oid, "a_inhproc" oid, "a_inhproname" name, "a_inhrelid" oid, "a_inhseqno" int4, "a_iplipl" oid, "a_iplre SELECT description FROM pg_description WHERE objoid = 189140@ " ame,@@llfoid" oid, "a_lanpltrusted" bool, "a_listenerpid" int4, "a_logfoo" oid, "a_not(@(@nt4, "a_objoid" oid, "a_opcdeftype" oid, SELECT description FROM pg_description WHERE objoid = 189150@ bo oin"@@a_oprkind" character, "a_oprleft" oid, "a_oprlsortop" oid, "a_oprname" name, "a_oprnegate" oid, i(@(@" int4, "a_oprprec" int2, SELECT description FROM pg_description WHERE objoid = 189160@tex gtypx@x@r, "a_probin" bytea, "a_probyte_pct" int4, "a_proiscachable" bool, "a_proisinh" bool, "a_proisstrict" bool, "aQ(@(@d" bool, "a SELECT description FROM pg_description WHERE objoid = 18917in_ratio" int4, "a_proowner" int4, "a_properbyte_cpu" int4, "a_propercall_cpu" int4, "a_proretset" bool, "a_prorettype" oid, "a_prosrc" text, "a_rcbin" text, "a_rcname" name, "a_rcrel9(@ SELECT description FROM pg_description WHERE objoid = 189180@int sind8@8@a_relhaspkey" bool, "a_relhasrules" bool, "a_relhassubclass" bool, "a_relisshared" bool, "a_relkind" character, "a_relname" name, "a_r SELECT description FROM pg_description WHERE objoid = 189190@oid streظ@ظ@a_reltriggers" int2, "a_reltuples" int4, "a_reltype" oid, "a_relukeys" int2, "a_rulename" name, "a_staattnum" int2, "a_stacommonfrac" SELECT description FROM pg_description WHERE objoid = 189200@t4, oid,з@з@d" oid, "a_tablename" name, "a_tableowner" name, "a_tgargs" byteaa(@(@" int2vector, "a_tgconstrname" name, "a_tgconstrrelid" rr8;19539@}a_ambuildregproc19540@Xa_amcloseregproc)19541@*a_amcostestimate,regproc.19542@x/a_amcreateregproc219543@3a_amdeleteregproc619544@l8a_amdestroyregproc8;19545@<a_amendscanregproct?19546@4a_amfreetuplePregproc19547@ a_amgetattrregproc 19548@xa_amgettuple  regproc"19549@l#a_amid@(oid(@`*19550@+a_aminsertregproc.19551@ 0a_ammarkposregproc319552@4a_amname5name@l719553@Aa_amopclaidoid(@C19554@\Ea_amopenFregprocHH19555@Ia_amopidKoid(@L19556@Na_amopoproid(@Q19557@Ra_amopstrategyTint2@V19558@|Wa_amorderstrategyint2@X[19559@\a_amowner( @(@ription((((19654132a_oprrsortopoid-1ff().)2);)@)C)E)19655133a_passwdtext-1ff)) ) ))))19656134a_proargtypesoidvector-1) @(@)))**19657135a_probinbytea-1ff<*B* F*T*Y*\*^*19658136a_probyte_pctint4-1ff*******19659137a_proiscachablebool-1f@@megatabABLETABLE@ "a$ ;% ;& ;|;};~;;;;P1;X2;`3;h4;p5;l-1+ DROP TABLE "megaview"; +,-,19663141a_prolangoid-1ffh,n, r,|,,,,19664142a_pronamename-1ff,, ,,,,,19665143a_pronargsint2-1ffnam--; SELECT description FROM pg_description WHERE objoid = 18871 "a_adsrc" text, "a_aggbasetype" oid, "a_aggfinalfn" regproc, "a_aggfinaltype" oid, "a_agginitval1" text, "a_agginitval2" text, "a_aggname" name, "a_aggowner" int4, "a_aggtransfn1" regproc, .; SELECT description FROM pg_description WHERE objoid = 18872pro ld" ) (@(@descriptionmcostestimate" regproc, "a_amcreate" regproc, "a_amdelete" regproc, "a_amdestroy" regproc, "a_amendscan" regproc, "a_amfreetupl0/; SELECT description FROM pg_description WHERE objoid = 18873pro kpos (@(@descriptionpclaid" oid, "a_amopen" regproc, "a_amopid" oid, "a_amopopr" oid, "a_amopstrategy" int2, "a_amorderstrategy" int2, "a_amowner"H0; SELECT description -- Disable triggers UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" !~ '^pg_'; COPY "megatab" FROM stdin; \. -- Enable triggers BEGIN TRANSACTION; CREATE TEMP TABLE "tr" ("tmp_relname" name, "tmp_reltriggers" smallint); INSERT INTO "tr" SELECT C."relname", count(T."oid") FROM "pg_class" C, "pg_trigger" T WHERE C."oid" = T."tgrelid" AND C."relname" !~ '^pg_' GROUP BY 1; UPDATE "pg_class" SET "reltriggers" = TMP."tmp_reltriggers" FROM "tr" TMP WHERE "pg_class"."relname" = TMP."tmp_relname"; DROP TABLE "tr"; COMMIT TRANSACTION; -- -- TOC Entry ID 4 (OID 20211) -- -- Name: _RETmegaview Type: RULE Owner: -- CREATE RULE "_RETmegaview" AS ON SELECT TO megaview DO INSTEAD SELECT megatab.a_adbin, megatab.a_adnum, megatab.a_adrelid, megatab.a_adsrc, megatab.a_aggbasetype, megatab.a_aggfinalfn, megatab.a_aggfinaltype, megatab.a_agginitval1, megatab.a_agginitval2, megatab.a_aggname, megatab.a_aggowner, megatab.a_aggtransfn1, megatab.a_aggtransfn2, megatab.a_aggtranstype1, megatab.a_aggtranstype2, megatab.a_ambeginscan, megatab.a_ambuild, megatab.a_amclose, megatab.a_amcostestimate, megatab.a_amcreate, megatab.a_amdelete, megatab.a_amdestroy, megatab.a_amendscan, megatab.a_amfreetuple, megatab.a_amgetattr, megatab.a_amgettuple, megatab.a_amid, megatab.a_aminsert, megatab.a_ammarkpos, megatab.a_amname, megatab.a_amopclaid, megatab.a_amopen, megatab.a_amopid, megatab.a_amopopr, megatab.a_amopstrategy, megatab.a_amorderstrategy, megatab.a_amowner, megatab.a_amprocnum, megatab.a_amproc, megatab.a_amrescan, megatab.a_amrestrpos, megatab.a_amsetlock, megatab.a_amsettid, megatab.a_amstrategies, megatab.a_amsupport, megatab.a_attalign, megatab.a_attbyval, megatab.a_attcacheoff, megatab.a_attdisbursion, megatab.a_atthasdef, megatab.a_attisset, megatab.a_attlen, megatab.a_attname, megatab.a_attnelems, megatab.a_attnotnull, megatab.a_attnum, megatab.a_attrelid, megatab.a_attstorage, megatab.a_atttypid, megatab.a_atttypmod, megatab.a_chunk_data, megatab.a_chunk_id, megatab.a_chunk_seq, megatab.a_datdba, megatab.a_datname, megatab.a_datpath, megatab.a_definition, megatab.a_description, megatab.a_encoding, megatab.a_ev_action, megatab.a_ev_attr, megatab.a_ev_class, megatab.a_ev_qual, megatab.a_ev_type, megatab.a_grolist, megatab.a_groname, megatab.a_grosysid, megatab.a_hasindexes, megatab.a_hasrules, megatab.a_hastriggers, megatab.a_indclass, megatab.a_indexdef, megatab.a_indexname, megatab.a_indexrelid, megatab.a_indhaskeytype, megatab.a_indisclustered, megatab.a_indislossy, megatab.a_indisprimary, megatab.a_indisunique, megatab.a_indkey, megatab.a_indpred, megatab.a_indproc, megatab.a_indreference, megatab.a_indrelid, megatab.a_inhargrelid,Y(@(@(@(@y(@q(@(@Zpgsql(Z165788Z501HZpg_indexXZ4(@(@4 (@(@int4inZint4outZint4inZint4outZ0Z,(@(@-Z16577Zpgsql[1659i(@(@501([pg_statistic@[4P[4`[int4inp[int4out[int4in[int4out[0[,[-[16598[pgsql[16616\501\pg_opera \40\4@\int4inP\int4out`\int4inp\int4out\0\,\-\16615\pgsql\16642\501\pg_opcla]4]4 ]int4in0]int4out@]int4inP]int4out`]0p],]-]16641]pgsql]16653]501]pg_am]4]4^int4in^int4out ^int4in0^int4out@^0P^,`^-p^16652^pgsql^16685^501^pg_amop^4^4^int4in^int4out_int4in_int4out _00_,@_-P_16684`_pgsqlp_16862_501_pg_ampro_4_4_int4in_int4out_int4in_int4out`0`, `-0`16861@`pgsqlP`16928``501p`pg_langu`4`4`int4in`int4out`int4in`int4out`0`,a-a16927 apgsql0a16942@a501Papg_aggregateha4xa4aint4inaint4outaint4inaint4outa0a,a-a16941bpgsqlb17007(b5018bpg_iplHb4Xb4hbint4inxbint4outbint4inbint4outb0b,b-b17006bpgsqlb17019c501cpg_inheritproc0c4@c4Pcint4in`cint4outpcint4incint4outc0c,c-c17018cpgsqlc17032c501dpg_rewrid4 d40dint4in@dint4outPdint4in`dint4outpd0d,d-d17031dpgsqld17048d501dpg_listed4e4eint4in eint4out0eint4in@eint4outPe0`e,pe-e17047epgsqle17060e501epg_descriptione4e4eint4infint4outfint4in(fint4out8f0Hf,Xf-hf17059xfpgsqlf17281f501fpg_toast_17031f4f4fint4infint4outgint4ingint4out g00g,@g-Pg17280`gpgsqlpg17313g501gpg_userg4g4gint4ingint4outgint4ingint4outh0h, h-0h17312@hpgsqlPh17345`h501phpg_rulesh4h4hint4inhint4outhint4inhint4outh0h,i-i17344 ipgsql0i17377@i501Pipg_views`i4pi4iint4iniint4outiint4iniint4outi0i,i-i17376jpgsqlj17409 j5010jpg_table@j4Pj4`jint4inpjint4outjint4injint4outj0j,j-j17408jpgsqlj17441k501kpg_index k40k4@kint4inPkint4out`kint4inpkint4outk0k,k-k17440kpgsqlk18817k501kmegatabl4l4 lint4in0lint4out@lint4inPlint4out`l0pl,l-l18816lpgsqll19507l501lpg_toast_18816l4l4mint4inmint4out(mint4in8mint4outHm0Xm,hm-xm19506mpgsqlm19522m501mmegaviewm4m4mint4inmint4outnint4innint4out(n08n,Hn-Xn19521hnpgsql; SELECT description FROM pg_description WHERE objoid = 18874 "a_adsrc" text, "a_aggbasetype" oid, "a_aggfinalfn" regproc, "a_aggfinaltype" oid, "a_agginitval1" text, "a_agginitval2" text, "a_aggname" name, "a_aggowner" int4, "a_aggtransfn1" regproc, ; SELECT description FROM pg_description WHERE objoid = 18875pro ld" (@(@descriptionmcostestimate" regproc, "a_amcreate" regproc, "a_amdelete" regproc, "a_amdestroy" regproc, "a_amendscan" regproc, "a_amfreetupl; SELECT description FROM pg_description WHERE objoid = 18876pro kposq (@(@descriptionpclaid" oid, "a_amopen" regproc, "a_amopid" oid, "a_amopopr" oid, "a_amopstrategy" int2, "a_amorderstrategy" int2, "a_amowner"; SELECT description FROM pg_description WHERE objoid = 18877 "a regpY (@(@descriptionrategies" int2, "a_amsupport" int2, "a_attalign" character, "a_attbyval" bool, "a_attcacheoff" int4, "a_attdisbursion" float4, ; SELECT description FROM pg_description WHERE objoid = 18878int tnulA (@(@descriptionlid" oid, "a_attstorage" character, "a_atttypid" oid, "a_atttypmod" int4, "a_chunk_data" bytea, "a_chunk_id" oid, "a_chunk_seq; SELECT description FROM pg_description WHERE objoid = 18879cri  "a) (@(@descriptionxt, "a_ev_attr" int2, "a_ev_class" oid, "a_ev_qual" lztext, "a_ev_type" character, "a_grolist" "_int4", "a_groname" name, "a_; SELECT description FROM pg_description WHERE objoid = 18880" o a_in (@(@description"a_indexrelid" oid, "a_indhaskeytype" bool, "a_indisclustered" bool, "a_indislossy" bool, "a_indisprimary" bool, "a_indisunique0; SELECT description FROM pg_description WHERE objoid = 18882"a_ d, p ع@id" oid, "a_inhdefrelid" oid, "a_inhparent" oid, "a_inhproc" oid, "a_inhproname" name, "a_inhrelid" oid, "a_inhseqno" int4, "a_iplipl" oid, "a_iplre SELECT description FROM pg_description WHERE objoid = 189140@ " ame,@@llfoid" oid, "a_lanpltrusted" bool, "a_listenerpid" int4, "a_logfoo" oid, "a_not(@(@nt4, "a_objoid" oid, "a_opcdeftype" oid, SELECT description FROM pg_description WHERE objoid = 189150@ bo oin"@@a_oprkind" character, "a_oprleft" oid, "a_oprlsortop" oid, "a_oprname" name, "a_oprnegate" oid, i(@(@" int4, "a_oprprec" int2, SELECT description FROM pg_description WHERE objoid = 189160@tex gtypx@x@r, "a_probin" bytea, "a_probyte_pct" int4, "a_proiscachable" bool, "a_proisinh" bool, "a_proisstrict" bool, "aQ(@(@d" bool, "a SELECT description FROM pg_description WHERE objoid = 18917in_ratio" int4, "a_proowner" int4, "a_properbyte_cpu" int4, "a_propercall_cpu" int4, "a_proretset" bool, "a_prorettype" oid, "a_prosrc" text, "a_rcbin" text, "a_rcname" name, "a_rcrel9(@ SELECT description FROM pg_description WHERE objoid = 189180@int sind8@8@a_relhaspkey" bool, "a_relhasrules" bool, "a_relhassubclass" bool, "a_relisshared" bool, "a_relkind" character, "a_relname" name, "a_r SELECT description FROM pg_description WHERE objoid = 189190@oid streظ@ظ@a_reltriggers" int2, "a_reltuples" int4, "a_reltype" oid, "a_relukeys" int2, "a_rulename" name, "a_staattnum" int2, "a_stacommonfrac" SELECT description FROM pg_description WHERE objoid = 189200@t4, oid,з@з@d" oid, "a_tablename" name, "a_tableowner" name, "a_tgargs" byteaa(@(@" int2vector, "a_tgconstrname" name, "a_tgconstrrelid" rr8;19539@}a_ambuildregproc19540@Xa_amcloseregproc)19541@*a_amcostestimate,regproc.19542@x/a_amcreateregproc219543@3a_amdeleteregproc619544@l8a_amdestroyregproc8;19545@<a_amendscanregproct?19546@4a_amfreetuplePregproc19547@ a_amgetattrregproc 19548@xa_amgettuple  regproc"19549@l#a_amid@(oid(@`*19550@+a_aminsertregproc.19551@ 0a_ammarkposregproc319552@4a_amname5name@l719553@Aa_amopclaidoid(@C19554@\Ea_amopenFregprocHH19555@Ia_amopidKoid(@L19556@Na_amopoproid(@Q19557@Ra_amopstrategyTint2@V19558@|Wa_amorderstrategyint2@X[19559@\a_amowner( @(@ription((((19654132a_oprrsortopoid-1ff().)2);)@)C)E)19655133a_passwdtext-1ff)) ) ))))19656134a_proargtypesoidvector-1) @(@)))**19657135a_probinbytea-1ff<*B* F*T*Y*\*^*19658136a_probyte_pctint4-1ff*******19659137a_proiscachablebool-1f@@megatabABLETABLE@ "a$ ;% ;& ;|;};~;;;;P1;X2;`3;h4;p5;l-1+ DROP TABLE "megaview"; +,-,19663141a_prolangoid-1ffh,n, r,|,,,,19664142a_pronamename-1ff,, ,,,,,19665143a_pronargsint2-1ffnam--; SELECT description FROM pg_description WHERE objoid = 18871 "a_adsrc" text, "a_aggbasetype" oid, "a_aggfinalfn" regproc, "a_aggfinaltype" oid, "a_agginitval1" text, "a_agginitval2" text, "a_aggname" name, "a_aggowner" int4, "a_aggtransfn1" regproc, .; SELECT description FROM pg_description WHERE objoid = 18872pro ld" ) (@(@descriptionmcostestimate" regproc, "a_amcreate" regproc, "a_amdelete" regproc, "a_amdestroy" regproc, "a_amendscan" regproc, "a_amfreetupl0/; SELECT description FROM pg_description WHERE objoid = 18873pro kpos