Skip to content

Instantly share code, notes, and snippets.

@strk

strk/gist:9b6c7cbee02e8d3fae3f317b052c49f0

Created February 15, 2018 16:03
Show Gist options
  • Save strk/9b6c7cbee02e8d3fae3f317b052c49f0 to your computer and use it in GitHub Desktop.
Save strk/9b6c7cbee02e8d3fae3f317b052c49f0 to your computer and use it in GitHub Desktop.
Download ZIP
create table_version revision disorder
Raw
gistfile1.txt
CREATE EXTENSION table_version;
CREATE TABLE IF NOT EXISTS t (k int primary key, v text);
SELECT table_version.ver_enable_versioning('public','t');
SELECT table_version.ver_create_revision('r1'); -- 1001 (empty)
SELECT table_version.ver_complete_revision();
SELECT table_version.ver_create_revision('r2'); -- 1002
INSERT INTO t VALUES (1, 'a');
INSERT INTO t VALUES (2, 'b');
INSERT INTO t VALUES (3, 'c');
SELECT table_version.ver_complete_revision();
SELECT setval('table_version.revision_id_seq', 1000, true);
SELECT table_version.ver_delete_revision(1001);
SELECT table_version.ver_create_revision('r10');
UPDATE t set v = 'a2' WHERE k = 1;
DELETE FROM t WHERE k = 2;
SELECT table_version.ver_complete_revision();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment