We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see ourdocumentation.
There was an error while loading.Please reload this page.
1 parent77d2473 commitec6d647Copy full SHA for ec6d647
pgpro_scheduler--2.0.sql
@@ -25,12 +25,13 @@ CREATE TABLE at_jobs_submitted(
25
canceledboolean default false,
26
submit_timetimestamp with time zone default now()
27
);
28
-CREATEINDEXat_jobs_submitted_node_at_idxonat_jobs_submitted (node, at);
+CREATEINDEXONat_jobs_submitted(at,submit_time);
29
30
CREATETABLEat_jobs_process(
31
start_timetimestamp with time zone default now()
32
) INHERITS (at_jobs_submitted);
33
34
+ALTERTABLE at_jobs_process ADDprimary key (id);
35
CREATEINDEXat_jobs_process_node_at_idxon at_jobs_process (node, at);
36
37
CREATETABLEat_jobs_done(
@@ -39,6 +40,7 @@ CREATE TABLE at_jobs_done(
39
40
done_timetimestamp with time zone default now()
41
) INHERITS (at_jobs_process);
42
43
+ALTERTABLE at_jobs_done ADDprimary key (id);
44
CREATEINDEXat_jobs_done_node_at_idxon at_jobs_done (node, at);
45
46
CREATETABLEcron(
