Column | Type | Notes |
---|---|---|
sync | TEXT | NULL |
sourcedb | TEXT | NULL |
targetdb | TEXT | NULL |
ppid | INTEGER | NOT NULL |
pid | INTEGER | NULL |
synctype | TEXT | NULL |
updates | BIGINT | NULL |
inserts | BIGINT | NULL |
deletes | BIGINT | NULL |
started | TIMESTAMPTZ | NULL |
aborted | TIMESTAMPTZ | NULL |
whydie | TEXT | NULL |
ended | TIMESTAMPTZ | NULL |
cdate | TIMESTAMPTZ | NOT NULL DEFAULT now() |
Constraint | Definition |
---|---|
q_sync_fk | FOREIGN KEY ([sync](/Bucardo/sync)) REFERENCES [bucardo.sync](/Bucardo/schema/sync)(name) ON UPDATE CASCADE ON DELETE SET NULL |
q_sdb_fk | FOREIGN KEY ([sourcedb](/Bucardo/object_types/sourcedb)) REFERENCES [bucardo.db](/Bucardo/schema/db)(name) ON UPDATE CASCADE ON DELETE SET NULL |
q_tdb_fk | FOREIGN KEY ([targetdb](/Bucardo/object_types/targetdb)) REFERENCES [bucardo.db](/Bucardo/schema/db)(name) ON UPDATE CASCADE ON DELETE SET NULL |
Index | Unique? | Definition |
---|---|---|
q_unique | Yes | ([sync](/Bucardo/sync),[sourcedb](/Bucardo/object_types/sourcedb),[targetdb](/Bucardo/object_types/targetdb)) WHERE started IS NULL |
q_ppid | No | (ppid,pid) WHERE ended IS NULL AND aborted IS NULL |
q_aborted | No | ([sync](/Bucardo/sync)) WHERE started IS NOT NULL AND aborted IS NOT NULL AND ended IS NULL |
q_cleanup | No | (cdate) WHERE ended IS NOT NULL |
q_stathelper | No | (cdate, [sync](/Bucardo/sync)) WHERE ended IS NOT NULL |
End Point Dev offers professional support for Bucardo, as well as specializing in developing, designing, and marketing effective websites. Since 1995, our diverse team of developers has shown that End Point can handle your organization’s greatest web and database challenges.