\set ECHO none
1..94
ok 1 - Schema table_version should exist
ok 2 - Should have revision table
ok 3 - Should have tables_changed table
ok 4 - Should have versioned_tables table
ok 5 - Function table_version.ver_complete_revision() should exist
ok 6 - Function table_version.ver_create_revision(text, timestamp without time zone, boolean) should exist
ok 7 - Function table_version.ver_create_table_functions(name, name, name) should exist
ok 8 - Function table_version.ver_create_version_trigger(name, name, name) should exist
ok 9 - Function table_version.ver_delete_revision(integer) should exist
ok 10 - Function table_version.ver_enable_versioning(name, name) should exist
ok 11 - Function table_version.ver_disable_versioning(name, name) should exist
ok 12 - Function table_version.ver_expandtemplate(text, text[]) should exist
ok 13 - Function table_version.ver_get_last_revision() should exist
ok 14 - Function table_version.ver_get_modified_tables(integer) should exist
ok 15 - Function table_version.ver_get_modified_tables(integer, integer) should exist
ok 16 - Function table_version.ver_get_revision(timestamp without time zone) should exist
ok 17 - Function table_version.ver_get_revision(integer) should exist
ok 18 - Function table_version.ver_get_revisions(integer[]) should exist
ok 19 - Function table_version.ver_get_revisions(timestamp without time zone, timestamp without time zone) should exist
ok 20 - Function table_version.ver_get_table_base_revision(name, name) should exist
ok 21 - Function table_version.ver_get_table_last_revision(name, name) should exist
ok 22 - Function table_version.ver_get_version_table(name, name) should exist
ok 23 - Function table_version.ver_get_version_table_full(name, name) should exist
ok 24 - Function table_version.ver_get_versioned_table_key(name, name) should exist
ok 25 - Function table_version.ver_get_versioned_tables() should exist
ok 26 - Function table_version.ver_is_table_versioned(name, name) should exist
ok 27 - Function table_version.ver_versioned_table_change_column_type(name, name, name, text) should exist
ok 28 - Function table_version.ver_versioned_table_add_column(name, name, name, text) should exist
ok 29 - Function table_version.ver_versioned_table_drop_column(name, name, name) should exist
ok 30 - Enable versioning on foo.bar
ok 31 - Check table is revisioned versioning on foo.bar
ok 32 - Check table foo.bar table key
ok 33 - Check table base revision
ok 34 - Function table_version.ver_get_foo_bar_revision(integer) should exist
ok 35 - Function table_version.ver_get_foo_bar_diff(integer, integer) should exist
ok 36 - Check get table revision function API
ok 37 - Foo bar diff for table creation
ok 38 - Create edit 1 revision
ok 39 - Complete edit 1 revision
ok 40 - Foo bar diff for edit 1
ok 41 - Create edit 2 revision
ok 42 - Complete edit 2 revision
ok 43 - Foo bar diff for edit 1 (recheck)
ok 44 - Foo bar diff range for edit 1-2
ok 45 - Foo bar diff for edit 2
ok 46 - Foo bar diff for edit 2 (larger range parameter)
ok 47 - Create edit 3 revision
ok 48 - Complete edit 3 revision
ok 49 - Foo bar diff check to ensure a row created and deleted in between revisions is not returned
ok 50 - Create edit 4 revision
ok 51 - Complete edit 4 revision
ok 52 - Foo bar diff for edit 4
ok 53 - Foo bar diff check to ensure a feature created and delete in between revision does not show (delete does not occur in last revision)
ok 54 - Create edit 4 revision
ok 55 - Complete edit 4 revision
ok 56 - Foo bar diff check re-insert a prevoiusly deleted row #1
ok 57 - Foo bar diff check re-insert a prevoiusly deleted row #2
ok 58 - Change column datatype
ok 59 - Add column datatype
ok 60 - Drop column
ok 61 - Disable versioning on foo.bar
ok 62 - Enable versioning of text primary key on foo.bar2
ok 63 - Check table is revisioned versioning on foo.bar2
ok 64 - Check table foo.bar table key
ok 65 - Create edit text PK
ok 66 - Complete edit text PK
ok 67 - Foo bar2 diff for text PK edit
ok 68 - Disable versioning on foo.bar2
ok 69 - Diff function between foo3 and foo4
ok 70 - Apply diff to table function between foo3 and foo4
ok 71 - Enable versioning on table with permissions
ok 72 - Test foo_bar5_revision ownership
ok 73 - Test foo_bar5_revision permission for test_user
ok 74 - Disable versioning on foo.bar5
ok 75 - Diff function between fOo.Bar3 and foO.bAr4
ok 76 - Diff function between fOo.Bar3 and foO.bAr4 (with unique column)
ok 77 - enable versioning on foo.dropme
ok 78 - foo.dropme is versioned
ok 79 - foo.dropme is returned by ver_get_versioned_tables
ok 80 - foo.dropme versioned table key is "id"
ok 81 - foo.dropme can only be drop with CASCADE
WARNING:  Table foo.dropme does not exist
ok 82 - foo.dropme is not versioned after drop cascade
WARNING:  Table foo.dropme does not exist
ok 83 - foo.dropme is not returned by ver_get_versioned_tables after drop
WARNING:  Table foo.dropme does not exist
ok 84 - foo.dropme versioned table key is null after drop
WARNING:  Table foo.dropme is known as versioned but lacks versioning triggers
ok 85 - foo.dropme is not versioned after re-create
WARNING:  Table foo.dropme is known as versioned but lacks versioning triggers
ok 86 - foo.dropme is not returned by ver_get_versioned_tables after re-create
WARNING:  Table foo.dropme is known as versioned but lacks versioning triggers
ok 87 - foo.dropme versioned table key is null after re-create
ok 88 - can enable versioning on drop-recreated table foo.dropme
ok 89 - foo.dropme is versioned after re-create and ver_enable_versioning
ok 90 - foo.dropme is returned by ver_get_versioned_tables after re-create and ver_enable_versioning
ok 91 - foo.dropme versioned table key is "id" after re-create and ver_enable_versioning
ok 92 - ver_enable_versioning throws when called on already-versioned table
ok 93 - Function table_version.ver_version() should exist
ok 94 - Function table_version.ver_enable_versioning(regclass) should exist