Commitd414013

Vladimir Ershov

committed

set extension tables to be dumped by pg_dump

1 parent0e38b2c commitd414013Copy full SHA for d414013

File tree

+28

-0

lines changed

+28

-0

lines changed

Lines changed: 14 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,14 @@`
	`1`	`+DO $$`
	`2`	`+DECLARE oidsoid[];`
	`3`	`+BEGIN`
	`4`	`+oids= array_append(oids,'schedule.at_jobs_submitted'::regclass::oid);`
	`5`	`+oids= array_append(oids,'schedule.at_jobs_submitted_id_seq'::regclass::oid);`
	`6`	`+oids= array_append(oids,'schedule.at_jobs_process'::regclass::oid);`
	`7`	`+oids= array_append(oids,'schedule.at_jobs_done'::regclass::oid);`
	`8`	`+oids= array_append(oids,'schedule.cron'::regclass::oid);`
	`9`	`+oids= array_append(oids,'schedule.cron_id_seq'::regclass::oid);`
	`10`	`+oids= array_append(oids,'schedule.at'::regclass::oid);`
	`11`	`+oids= array_append(oids,'schedule.log'::regclass::oid);`
	`12`	`+`
	`13`	`+UPDATEpg_catalog.pg_extensionSET extconfig= oids, extcondition='{"","","","","","","",""}'where extname='pgpro_scheduler';`
	`14`	`+END$$;`

Lines changed: 14 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -145,6 +145,20 @@ CREATE TYPE cron_job AS(`
`145`	`145`	`messagetext-- error message if one`
`146`	`146`	`);`
`147`	`147`
	`148`	`+----------------------------------`
	`149`	`+-- ADD Extension tables to Dump --`
	`150`	`+----------------------------------`
	`151`	`+`
	`152`	`+select pg_extension_config_dump('at_jobs_submitted'::regclass,'');`
	`153`	`+select pg_extension_config_dump('at_jobs_submitted_id_seq'::regclass,'');`
	`154`	`+select pg_extension_config_dump('at_jobs_process'::regclass,'');`
	`155`	`+select pg_extension_config_dump('at_jobs_done'::regclass,'');`
	`156`	`+select pg_extension_config_dump('cron'::regclass,'');`
	`157`	`+select pg_extension_config_dump('cron_id_seq'::regclass,'');`
	`158`	`+select pg_extension_config_dump('at'::regclass,'');`
	`159`	`+select pg_extension_config_dump('log'::regclass,'');`
	`160`	`+`
	`161`	`+`
`148`	`162`	`---------------`
`149`	`163`	`-- FUNCTIONS --`
`150`	`164`	`---------------`

Comments

(0)