Commit4c0fb09

Vladimir Ershov

committed

Merge commit 'd4140135f2ab13fd106437cfe8d2e68bd26d2a4b' into PGPROEE9_6_scheduler

2 parents847ca14 +d414013 commit4c0fb09Copy full SHA for 4c0fb09

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)