test/dummy/log/test.log in rails_sql_views4-0.0.1 vs test/dummy/log/test.log in rails_sql_views4-0.0.2

- old
+ new

@@ -29316,5 +29316,4965 @@  (0.1ms)  SELECT name FROM sqlite_master WHERE type = 'view' AND NOT name = 'sqlite_sequence'   (0.3ms) rollback transaction + ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.1ms) BEGIN +------------------------------------ +SchemaDumperTest: test_dump_and_load +------------------------------------ +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +----------------------------------- +SchemaDumperTest: test_regex_ignore +----------------------------------- +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------ +SchemaDumperTest: test_symbol_ignore +------------------------------------ +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------- +SchemaDumperTest: test_union +---------------------------- +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (1.7ms) SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type IN ('BASE TABLE', 'VIEW') + +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.5ms) INSERT INTO "people" ("first_name", "last_name", "ssn") VALUES ($1, $2, $3) RETURNING "id" [["first_name", "Joe"], ["last_name", "User"], ["ssn", "123456789"]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.4ms) INSERT INTO "people2" ("first_name", "last_name", "ssn", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["first_name", "Jane"], ["last_name", "Doe"], ["ssn", "222334444"], ["created_at", "2015-01-11 19:18:30.511652"], ["updated_at", "2015-01-11 19:18:30.511652"]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) DROP VIEW "v_profile" +PG::UndefinedTable: ERROR: view "v_profile" does not exist +: DROP VIEW "v_profile" +  (0.2ms) CREATE VIEW "v_profile" ("first_name", "last_name", "ssn") AS select first_name, last_name, ssn from people + UNION + select first_name, last_name, ssn from people2 + +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_profile" ("first_name", "last_name", "ssn") AS select first_name, last_name, ssn from people + UNION + select first_name, last_name, ssn from people2 + +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------- +SchemaDumperTest: test_view +--------------------------- +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------------ +SchemaDumperTest: test_view_creation_order +------------------------------------------ +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------ +ViewOperationsTest: test_create_view +------------------------------------ +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.2ms) INSERT INTO "people" ("first_name", "last_name", "ssn") VALUES ($1, $2, $3) RETURNING "id" [["first_name", "John"], ["last_name", "Doe"], ["ssn", "123456789"]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security") AS select id, first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security") AS select id, first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------------- +ViewOperationsTest: test_drop_view +---------------------------------- +  (0.2ms) DROP VIEW "v_place" +PG::UndefinedTable: ERROR: view "v_place" does not exist +: DROP VIEW "v_place" +  (0.1ms) CREATE VIEW "v_place" ("v_address", "v_city", "v_state", "v_country") AS select address, city, cstate, country from places +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_place" ("v_address", "v_city", "v_state", "v_country") AS select address, city, cstate, country from places +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------- +ViewOperationsTest: test_no_view_raises_error +--------------------------------------------- +  (1.9ms)  SELECT view_definition + FROM information_schema.views + WHERE table_catalog = (SELECT catalog_name FROM information_schema.information_schema_catalog_name) + AND table_schema IN ('"$user"','public') + AND table_name = 'foo' + +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +----------------------------- +AdapterTest: test_base_tables +----------------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------- +AdapterTest: test_columns +------------------------- +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------------- +AdapterTest: test_current_database +---------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_mapped_columns +-------------------------------- +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------ +AdapterTest: test_mapped_views +------------------------------ +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------- +AdapterTest: test_old_name_not_found_error_during_mapping +--------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------------------------------- +AdapterTest: test_only_base_table_triggers_are_dropped_for_disabled_ref_integrity +--------------------------------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_supports_views +-------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------ +AdapterTest: test_tables +------------------------ +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------- +AdapterTest: test_view_select_statement +--------------------------------------- +  (0.5ms) SELECT view_definition + FROM information_schema.views + WHERE table_catalog = (SELECT catalog_name FROM information_schema.information_schema_catalog_name) + AND table_schema IN ('"$user"','public') + AND table_name = 'v_people' + +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +----------------------- +AdapterTest: test_views +----------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------------------------------- +ViewModelTest: test_access_cloned_belongs_to_association +-------------------------------------------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------------------------ +ViewModelTest: test_access_cloned_has_many_association +------------------------------------------------------ +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------------------------------- +ViewModelTest: test_cloned_belongs_to_association_exists +-------------------------------------------------------- +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------- +ViewModelTest: test_cloned_habtm_association_exists +--------------------------------------------------- +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------------------------ +ViewModelTest: test_cloned_has_many_association_exists +------------------------------------------------------ +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------- +ViewModelTest: test_same_person +------------------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------------- +RailsSqlViews4Test: test_test_the_true +-------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------ +RailsSqlViews4Test: test_truth +------------------------------ +  (0.1ms) ROLLBACK + ActiveRecord::SchemaMigration Load (0.5ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.2ms) BEGIN +----------------------------- +AdapterTest: test_base_tables +----------------------------- +  (0.4ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------- +AdapterTest: test_columns +------------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------------- +AdapterTest: test_current_database +---------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_mapped_columns +-------------------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------ +AdapterTest: test_mapped_views +------------------------------ +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------- +AdapterTest: test_old_name_not_found_error_during_mapping +--------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------------------------------- +AdapterTest: test_only_base_table_triggers_are_dropped_for_disabled_ref_integrity +--------------------------------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_supports_views +-------------------------------- +  (0.0ms) ROLLBACK +  (0.1ms) BEGIN +------------------------ +AdapterTest: test_tables +------------------------ +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------- +AdapterTest: test_view_select_statement +--------------------------------------- +  (1.9ms)  SELECT view_definition + FROM information_schema.views + WHERE table_catalog = (SELECT catalog_name FROM information_schema.information_schema_catalog_name) + AND table_schema IN ('"$user"','public') + AND table_name = 'v_people' + +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +----------------------- +AdapterTest: test_views +----------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------ +SchemaDumperTest: test_dump_and_load +------------------------------------ +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +----------------------------------- +SchemaDumperTest: test_regex_ignore +----------------------------------- +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.2ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------ +SchemaDumperTest: test_symbol_ignore +------------------------------------ +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------- +SchemaDumperTest: test_union +---------------------------- +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (1.3ms)  SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type IN ('BASE TABLE', 'VIEW') + +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "people" ("first_name", "last_name", "ssn") VALUES ($1, $2, $3) RETURNING "id" [["first_name", "Joe"], ["last_name", "User"], ["ssn", "123456789"]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.2ms) INSERT INTO "people2" ("first_name", "last_name", "ssn", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["first_name", "Jane"], ["last_name", "Doe"], ["ssn", "222334444"], ["created_at", "2015-01-11 19:20:27.855386"], ["updated_at", "2015-01-11 19:20:27.855386"]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) DROP VIEW "v_profile" +PG::UndefinedTable: ERROR: view "v_profile" does not exist +: DROP VIEW "v_profile" +  (0.2ms) CREATE VIEW "v_profile" ("first_name", "last_name", "ssn") AS select first_name, last_name, ssn from people + UNION + select first_name, last_name, ssn from people2 + +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_profile" ("first_name", "last_name", "ssn") AS select first_name, last_name, ssn from people + UNION + select first_name, last_name, ssn from people2 + +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------- +SchemaDumperTest: test_view +--------------------------- +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------------ +SchemaDumperTest: test_view_creation_order +------------------------------------------ +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------------------------------- +ViewModelTest: test_access_cloned_belongs_to_association +-------------------------------------------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------------------------ +ViewModelTest: test_access_cloned_has_many_association +------------------------------------------------------ +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------------------------------- +ViewModelTest: test_cloned_belongs_to_association_exists +-------------------------------------------------------- +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------- +ViewModelTest: test_cloned_habtm_association_exists +--------------------------------------------------- +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------------------------ +ViewModelTest: test_cloned_has_many_association_exists +------------------------------------------------------ +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------- +ViewModelTest: test_same_person +------------------------------- +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------ +ViewOperationsTest: test_create_view +------------------------------------ +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.2ms) INSERT INTO "people" ("first_name", "last_name", "ssn") VALUES ($1, $2, $3) RETURNING "id" [["first_name", "John"], ["last_name", "Doe"], ["ssn", "123456789"]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security") AS select id, first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security") AS select id, first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------------- +ViewOperationsTest: test_drop_view +---------------------------------- +  (0.2ms) DROP VIEW "v_place" +PG::UndefinedTable: ERROR: view "v_place" does not exist +: DROP VIEW "v_place" +  (0.1ms) CREATE VIEW "v_place" ("v_address", "v_city", "v_state", "v_country") AS select address, city, cstate, country from places +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_place" ("v_address", "v_city", "v_state", "v_country") AS select address, city, cstate, country from places +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------- +ViewOperationsTest: test_no_view_raises_error +--------------------------------------------- +  (0.6ms) SELECT view_definition + FROM information_schema.views + WHERE table_catalog = (SELECT catalog_name FROM information_schema.information_schema_catalog_name) + AND table_schema IN ('"$user"','public') + AND table_name = 'foo' + +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------------- +RailsSqlViews4Test: test_test_the_true +-------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------ +RailsSqlViews4Test: test_truth +------------------------------ +  (0.1ms) ROLLBACK + ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.1ms) BEGIN +----------------------------- +AdapterTest: test_base_tables +----------------------------- +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------- +AdapterTest: test_columns +------------------------- +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------------- +AdapterTest: test_current_database +---------------------------------- + ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.1ms) BEGIN +-------------------------------------------------------- +ViewModelTest: test_access_cloned_belongs_to_association +-------------------------------------------------------- +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------------------------ +ViewModelTest: test_access_cloned_has_many_association +------------------------------------------------------ +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------------------------------- +ViewModelTest: test_cloned_belongs_to_association_exists +-------------------------------------------------------- +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------- +ViewModelTest: test_cloned_habtm_association_exists +--------------------------------------------------- +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------------------------ +ViewModelTest: test_cloned_has_many_association_exists +------------------------------------------------------ +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------- +ViewModelTest: test_same_person +------------------------------- +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------ +ViewOperationsTest: test_create_view +------------------------------------ +  (2.1ms)  SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type IN ('BASE TABLE', 'VIEW') + +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.5ms) INSERT INTO "people" ("first_name", "last_name", "ssn") VALUES ($1, $2, $3) RETURNING "id" [["first_name", "John"], ["last_name", "Doe"], ["ssn", "123456789"]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security") AS select id, first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security") AS select id, first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------------- +ViewOperationsTest: test_drop_view +---------------------------------- +  (0.2ms) DROP VIEW "v_place" +PG::UndefinedTable: ERROR: view "v_place" does not exist +: DROP VIEW "v_place" +  (0.1ms) CREATE VIEW "v_place" ("v_address", "v_city", "v_state", "v_country") AS select address, city, cstate, country from places +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_place" ("v_address", "v_city", "v_state", "v_country") AS select address, city, cstate, country from places +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------- +ViewOperationsTest: test_no_view_raises_error +--------------------------------------------- +  (1.3ms)  SELECT view_definition + FROM information_schema.views + WHERE table_catalog = (SELECT catalog_name FROM information_schema.information_schema_catalog_name) + AND table_schema IN ('"$user"','public') + AND table_name = 'foo' + +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------ +SchemaDumperTest: test_dump_and_load +------------------------------------ +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +----------------------------------- +SchemaDumperTest: test_regex_ignore +----------------------------------- +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------ +SchemaDumperTest: test_symbol_ignore +------------------------------------ +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.2ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------- +SchemaDumperTest: test_union +---------------------------- +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.2ms) INSERT INTO "people" ("first_name", "last_name", "ssn") VALUES ($1, $2, $3) RETURNING "id" [["first_name", "Joe"], ["last_name", "User"], ["ssn", "123456789"]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.4ms) INSERT INTO "people2" ("first_name", "last_name", "ssn", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["first_name", "Jane"], ["last_name", "Doe"], ["ssn", "222334444"], ["created_at", "2015-01-11 19:24:08.738879"], ["updated_at", "2015-01-11 19:24:08.738879"]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) DROP VIEW "v_profile" +PG::UndefinedTable: ERROR: view "v_profile" does not exist +: DROP VIEW "v_profile" +  (0.2ms) CREATE VIEW "v_profile" ("first_name", "last_name", "ssn") AS select first_name, last_name, ssn from people + UNION + select first_name, last_name, ssn from people2 + +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_profile" ("first_name", "last_name", "ssn") AS select first_name, last_name, ssn from people + UNION + select first_name, last_name, ssn from people2 + +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------- +SchemaDumperTest: test_view +--------------------------- +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------------ +SchemaDumperTest: test_view_creation_order +------------------------------------------ +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +----------------------------- +AdapterTest: test_base_tables +----------------------------- +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------- +AdapterTest: test_columns +------------------------- +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------------- +AdapterTest: test_current_database +---------------------------------- +  (0.4ms) ROLLBACK +  (0.2ms) BEGIN +-------------------------------- +AdapterTest: test_mapped_columns +-------------------------------- +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------ +AdapterTest: test_mapped_views +------------------------------ +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +--------------------------------------------------------- +AdapterTest: test_old_name_not_found_error_during_mapping +--------------------------------------------------------- +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------------------------------- +AdapterTest: test_only_base_table_triggers_are_dropped_for_disabled_ref_integrity +--------------------------------------------------------------------------------- +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +-------------------------------- +AdapterTest: test_supports_views +-------------------------------- +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +------------------------ +AdapterTest: test_tables +------------------------ +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------- +AdapterTest: test_view_select_statement +--------------------------------------- +  (0.6ms) SELECT view_definition + FROM information_schema.views + WHERE table_catalog = (SELECT catalog_name FROM information_schema.information_schema_catalog_name) + AND table_schema IN ('"$user"','public') + AND table_name = 'v_people' + +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +----------------------- +AdapterTest: test_views +----------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------------- +RailsSqlViews4Test: test_test_the_true +-------------------------------------- +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +------------------------------ +RailsSqlViews4Test: test_truth +------------------------------ +  (0.2ms) ROLLBACK + ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.1ms) BEGIN +-------------------------------------------------------- +ViewModelTest: test_access_cloned_belongs_to_association +-------------------------------------------------------- +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------------------------ +ViewModelTest: test_access_cloned_has_many_association +------------------------------------------------------ +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------------------------------- +ViewModelTest: test_cloned_belongs_to_association_exists +-------------------------------------------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------- +ViewModelTest: test_cloned_habtm_association_exists +--------------------------------------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------------------------ +ViewModelTest: test_cloned_has_many_association_exists +------------------------------------------------------ +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------- +ViewModelTest: test_same_person +------------------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------ +SchemaDumperTest: test_dump_and_load +------------------------------------ +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +----------------------------------- +SchemaDumperTest: test_regex_ignore +----------------------------------- +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------ +SchemaDumperTest: test_symbol_ignore +------------------------------------ +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------- +SchemaDumperTest: test_union +---------------------------- +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (1.9ms) SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type IN ('BASE TABLE', 'VIEW') + +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.4ms) INSERT INTO "people" ("first_name", "last_name", "ssn") VALUES ($1, $2, $3) RETURNING "id" [["first_name", "Joe"], ["last_name", "User"], ["ssn", "123456789"]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "people2" ("first_name", "last_name", "ssn", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["first_name", "Jane"], ["last_name", "Doe"], ["ssn", "222334444"], ["created_at", "2015-01-11 19:25:51.927476"], ["updated_at", "2015-01-11 19:25:51.927476"]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) DROP VIEW "v_profile" +PG::UndefinedTable: ERROR: view "v_profile" does not exist +: DROP VIEW "v_profile" +  (0.1ms) CREATE VIEW "v_profile" ("first_name", "last_name", "ssn") AS select first_name, last_name, ssn from people + UNION + select first_name, last_name, ssn from people2 + +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_profile" ("first_name", "last_name", "ssn") AS select first_name, last_name, ssn from people + UNION + select first_name, last_name, ssn from people2 + +  (0.2ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------- +SchemaDumperTest: test_view +--------------------------- +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------------ +SchemaDumperTest: test_view_creation_order +------------------------------------------ +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------------- +RailsSqlViews4Test: test_test_the_true +-------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------ +RailsSqlViews4Test: test_truth +------------------------------ +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------ +ViewOperationsTest: test_create_view +------------------------------------ +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.2ms) INSERT INTO "people" ("first_name", "last_name", "ssn") VALUES ($1, $2, $3) RETURNING "id" [["first_name", "John"], ["last_name", "Doe"], ["ssn", "123456789"]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security") AS select id, first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security") AS select id, first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------------- +ViewOperationsTest: test_drop_view +---------------------------------- +  (0.1ms) DROP VIEW "v_place" +PG::UndefinedTable: ERROR: view "v_place" does not exist +: DROP VIEW "v_place" +  (0.1ms) CREATE VIEW "v_place" ("v_address", "v_city", "v_state", "v_country") AS select address, city, cstate, country from places +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_place" ("v_address", "v_city", "v_state", "v_country") AS select address, city, cstate, country from places +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------- +ViewOperationsTest: test_no_view_raises_error +--------------------------------------------- +  (1.1ms)  SELECT view_definition + FROM information_schema.views + WHERE table_catalog = (SELECT catalog_name FROM information_schema.information_schema_catalog_name) + AND table_schema IN ('"$user"','public') + AND table_name = 'foo' + +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +----------------------------- +AdapterTest: test_base_tables +----------------------------- +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------- +AdapterTest: test_columns +------------------------- +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------------- +AdapterTest: test_current_database +---------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_mapped_columns +-------------------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------ +AdapterTest: test_mapped_views +------------------------------ +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------- +AdapterTest: test_old_name_not_found_error_during_mapping +--------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------------------------------- +AdapterTest: test_only_base_table_triggers_are_dropped_for_disabled_ref_integrity +--------------------------------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_supports_views +-------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------ +AdapterTest: test_tables +------------------------ +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------- +AdapterTest: test_view_select_statement +--------------------------------------- +  (0.5ms) SELECT view_definition + FROM information_schema.views + WHERE table_catalog = (SELECT catalog_name FROM information_schema.information_schema_catalog_name) + AND table_schema IN ('"$user"','public') + AND table_name = 'v_people' + +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +----------------------- +AdapterTest: test_views +----------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK + ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.1ms) BEGIN +------------------------------------ +SchemaDumperTest: test_dump_and_load +------------------------------------ +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +----------------------------------- +SchemaDumperTest: test_regex_ignore +----------------------------------- +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------ +SchemaDumperTest: test_symbol_ignore +------------------------------------ +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------- +SchemaDumperTest: test_union +---------------------------- +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (2.2ms) SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type IN ('BASE TABLE', 'VIEW') + +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "people" ("first_name", "last_name", "ssn") VALUES ($1, $2, $3) RETURNING "id" [["first_name", "Joe"], ["last_name", "User"], ["ssn", "123456789"]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "people2" ("first_name", "last_name", "ssn", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["first_name", "Jane"], ["last_name", "Doe"], ["ssn", "222334444"], ["created_at", "2015-01-11 19:27:01.045298"], ["updated_at", "2015-01-11 19:27:01.045298"]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) DROP VIEW "v_profile" +PG::UndefinedTable: ERROR: view "v_profile" does not exist +: DROP VIEW "v_profile" +  (0.2ms) CREATE VIEW "v_profile" ("first_name", "last_name", "ssn") AS select first_name, last_name, ssn from people + UNION + select first_name, last_name, ssn from people2 + +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_profile" ("first_name", "last_name", "ssn") AS select first_name, last_name, ssn from people + UNION + select first_name, last_name, ssn from people2 + +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------- +SchemaDumperTest: test_view +--------------------------- +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------------ +SchemaDumperTest: test_view_creation_order +------------------------------------------ +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +----------------------------- +AdapterTest: test_base_tables +----------------------------- +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------- +AdapterTest: test_columns +------------------------- +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------------- +AdapterTest: test_current_database +---------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_mapped_columns +-------------------------------- +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------ +AdapterTest: test_mapped_views +------------------------------ +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------- +AdapterTest: test_old_name_not_found_error_during_mapping +--------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------------------------------- +AdapterTest: test_only_base_table_triggers_are_dropped_for_disabled_ref_integrity +--------------------------------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_supports_views +-------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------ +AdapterTest: test_tables +------------------------ +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people + ActiveRecord::SchemaMigration Load (0.4ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.2ms) BEGIN +----------------------------- +AdapterTest: test_base_tables +----------------------------- +  (1.5ms) DROP VIEW "v_people" +  (1.2ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (1.9ms)  SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type = 'BASE TABLE' + +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +------------------------- +AdapterTest: test_columns +------------------------- +  (0.4ms) DROP VIEW "v_people" +  (0.5ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------------- +AdapterTest: test_current_database +---------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_mapped_columns +-------------------------------- +  (0.4ms) DROP VIEW "v_people" +  (0.5ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------ +AdapterTest: test_mapped_views +------------------------------ +  (0.3ms) DROP VIEW "v_people" +  (0.6ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (1.0ms) SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type = 'VIEW' + +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------- +AdapterTest: test_old_name_not_found_error_during_mapping +--------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------------------------------- +AdapterTest: test_only_base_table_triggers_are_dropped_for_disabled_ref_integrity +--------------------------------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_supports_views +-------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------ +AdapterTest: test_tables +------------------------ +  (0.9ms) DROP VIEW "v_people" +  (2.2ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (2.2ms)  SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type IN ('BASE TABLE', 'VIEW') + +  (0.4ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------- +AdapterTest: test_view_select_statement +--------------------------------------- +  (1.4ms) SELECT view_definition + FROM information_schema.views + WHERE table_catalog = (SELECT catalog_name FROM information_schema.information_schema_catalog_name) + AND table_schema IN ('"$user"','public') + AND table_name = 'v_people' + +  (0.5ms) ROLLBACK +  (0.2ms) BEGIN +----------------------- +AdapterTest: test_views +----------------------- +  (0.4ms) DROP VIEW "v_people" +  (0.6ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.8ms)  SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type = 'VIEW' + +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------ +ViewOperationsTest: test_create_view +------------------------------------ +  (0.8ms) SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type IN ('BASE TABLE', 'VIEW') + +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.4ms) INSERT INTO "people" ("first_name", "last_name", "ssn") VALUES ($1, $2, $3) RETURNING "id" [["first_name", "John"], ["last_name", "Doe"], ["ssn", "123456789"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.4ms) DROP VIEW "v_people" +  (0.6ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security") AS select id, first_name, last_name, ssn from people + Person Load (0.5ms) SELECT "people".* FROM "people" ORDER BY "people"."id" ASC LIMIT 1 + VPerson Load (0.2ms) SELECT "v_people".* FROM "v_people" LIMIT 1 +  (0.3ms) ROLLBACK +  (0.2ms) BEGIN +---------------------------------- +ViewOperationsTest: test_drop_view +---------------------------------- +  (0.4ms) DROP VIEW "v_place" +PG::UndefinedTable: ERROR: view "v_place" does not exist +: DROP VIEW "v_place" +  (0.3ms) CREATE VIEW "v_place" ("v_address", "v_city", "v_state", "v_country") AS select address, city, cstate, country from places +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_place" ("v_address", "v_city", "v_state", "v_country") AS select address, city, cstate, country from places +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +--------------------------------------------- +ViewOperationsTest: test_no_view_raises_error +--------------------------------------------- +  (0.7ms) SELECT view_definition + FROM information_schema.views + WHERE table_catalog = (SELECT catalog_name FROM information_schema.information_schema_catalog_name) + AND table_schema IN ('"$user"','public') + AND table_name = 'foo' + +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------ +SchemaDumperTest: test_dump_and_load +------------------------------------ +  (0.4ms) drop view if exists V_PEOPLE +  (0.2ms) drop view if exists V_PROFILE +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.4ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.2ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +----------------------------------- +SchemaDumperTest: test_regex_ignore +----------------------------------- +  (0.4ms) drop view if exists V_PEOPLE +  (0.2ms) drop view if exists V_PROFILE +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.2ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------ +SchemaDumperTest: test_symbol_ignore +------------------------------------ +  (0.4ms) drop view if exists V_PEOPLE +  (0.2ms) drop view if exists V_PROFILE +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.2ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +---------------------------- +SchemaDumperTest: test_union +---------------------------- +  (0.5ms) drop view if exists V_PEOPLE +  (0.2ms) drop view if exists V_PROFILE +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "people" ("first_name", "last_name", "ssn") VALUES ($1, $2, $3) RETURNING "id" [["first_name", "Joe"], ["last_name", "User"], ["ssn", "123456789"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.4ms) INSERT INTO "people2" ("first_name", "last_name", "ssn", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["first_name", "Jane"], ["last_name", "Doe"], ["ssn", "222334444"], ["created_at", "2015-01-11 19:41:16.687584"], ["updated_at", "2015-01-11 19:41:16.687584"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.3ms) DROP VIEW "v_profile" +PG::UndefinedTable: ERROR: view "v_profile" does not exist +: DROP VIEW "v_profile" +  (0.2ms) CREATE VIEW "v_profile" ("first_name", "last_name", "ssn") AS select first_name, last_name, ssn from people + UNION + select first_name, last_name, ssn from people2 + +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_profile" ("first_name", "last_name", "ssn") AS select first_name, last_name, ssn from people + UNION + select first_name, last_name, ssn from people2 + +  (0.2ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +--------------------------- +SchemaDumperTest: test_view +--------------------------- +  (0.4ms) drop view if exists V_PEOPLE +  (0.2ms) drop view if exists V_PROFILE +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.2ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------------ +SchemaDumperTest: test_view_creation_order +------------------------------------------ +  (0.4ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.2ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.2ms) BEGIN +-------------------------------------------------------- +ViewModelTest: test_access_cloned_belongs_to_association +-------------------------------------------------------- +  (0.4ms) DROP VIEW "v_people" +  (0.8ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::UndefinedTable: ERROR: relation "places" does not exist +LINE 5: WHERE a.attrelid = '"places"'::regclass + ^ +: SELECT a.attname, format_type(a.atttypid, a.atttypmod), + pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod + FROM pg_attribute a LEFT JOIN pg_attrdef d + ON a.attrelid = d.adrelid AND a.attnum = d.adnum + WHERE a.attrelid = '"places"'::regclass + AND a.attnum > 0 AND NOT a.attisdropped + ORDER BY a.attnum + +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +------------------------------------------------------ +ViewModelTest: test_access_cloned_has_many_association +------------------------------------------------------ +  (0.4ms) DROP VIEW "v_people" +  (0.8ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::UndefinedTable: ERROR: relation "places" does not exist +LINE 5: WHERE a.attrelid = '"places"'::regclass + ^ +: SELECT a.attname, format_type(a.atttypid, a.atttypmod), + pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod + FROM pg_attribute a LEFT JOIN pg_attrdef d + ON a.attrelid = d.adrelid AND a.attnum = d.adnum + WHERE a.attrelid = '"places"'::regclass + AND a.attnum > 0 AND NOT a.attisdropped + ORDER BY a.attnum + +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +-------------------------------------------------------- +ViewModelTest: test_cloned_belongs_to_association_exists +-------------------------------------------------------- +  (0.4ms) DROP VIEW "v_people" +  (0.7ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::UndefinedTable: ERROR: relation "places" does not exist +LINE 5: WHERE a.attrelid = '"places"'::regclass + ^ +: SELECT a.attname, format_type(a.atttypid, a.atttypmod), + pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod + FROM pg_attribute a LEFT JOIN pg_attrdef d + ON a.attrelid = d.adrelid AND a.attnum = d.adnum + WHERE a.attrelid = '"places"'::regclass + AND a.attnum > 0 AND NOT a.attisdropped + ORDER BY a.attnum + +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------- +ViewModelTest: test_cloned_habtm_association_exists +--------------------------------------------------- +  (0.4ms) DROP VIEW "v_people" +  (0.6ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::UndefinedTable: ERROR: relation "places" does not exist +LINE 5: WHERE a.attrelid = '"places"'::regclass + ^ +: SELECT a.attname, format_type(a.atttypid, a.atttypmod), + pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod + FROM pg_attribute a LEFT JOIN pg_attrdef d + ON a.attrelid = d.adrelid AND a.attnum = d.adnum + WHERE a.attrelid = '"places"'::regclass + AND a.attnum > 0 AND NOT a.attisdropped + ORDER BY a.attnum + +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +------------------------------------------------------ +ViewModelTest: test_cloned_has_many_association_exists +------------------------------------------------------ +  (0.5ms) DROP VIEW "v_people" +  (0.7ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::UndefinedTable: ERROR: relation "places" does not exist +LINE 5: WHERE a.attrelid = '"places"'::regclass + ^ +: SELECT a.attname, format_type(a.atttypid, a.atttypmod), + pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod + FROM pg_attribute a LEFT JOIN pg_attrdef d + ON a.attrelid = d.adrelid AND a.attnum = d.adnum + WHERE a.attrelid = '"places"'::regclass + AND a.attnum > 0 AND NOT a.attisdropped + ORDER BY a.attnum + +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------- +ViewModelTest: test_same_person +------------------------------- +  (0.4ms) DROP VIEW "v_people" +  (0.6ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::UndefinedTable: ERROR: relation "places" does not exist +LINE 5: WHERE a.attrelid = '"places"'::regclass + ^ +: SELECT a.attname, format_type(a.atttypid, a.atttypmod), + pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod + FROM pg_attribute a LEFT JOIN pg_attrdef d + ON a.attrelid = d.adrelid AND a.attnum = d.adnum + WHERE a.attrelid = '"places"'::regclass + AND a.attnum > 0 AND NOT a.attisdropped + ORDER BY a.attnum + +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +-------------------------------------- +RailsSqlViews4Test: test_test_the_true +-------------------------------------- +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------ +RailsSqlViews4Test: test_truth +------------------------------ +  (0.1ms) ROLLBACK +  (113.6ms) DROP DATABASE IF EXISTS "rails_sql_views_unittest" +  (264.8ms) CREATE DATABASE "rails_sql_views_unittest" ENCODING = 'unicode' +  (113.7ms) DROP DATABASE IF EXISTS "rails_sql_views_unittest" +  (238.3ms) CREATE DATABASE "rails_sql_views_unittest" ENCODING = 'unicode' + SQL (0.7ms) CREATE EXTENSION IF NOT EXISTS "plpgsql" +  (4.2ms) CREATE TABLE "items" ("id" serial primary key, "person_id" integer, "created_at" timestamp, "updated_at" timestamp) +  (1.6ms) CREATE TABLE "items_people" ("id" serial primary key, "person_id" integer, "item_id" integer, "created_at" timestamp, "updated_at" timestamp)  +  (2.8ms) CREATE TABLE "people" ("id" serial primary key, "first_name" character varying, "last_name" character varying, "ssn" character varying, "address_id" integer) +  (3.2ms) CREATE TABLE "people2" ("id" serial primary key, "first_name" character varying, "last_name" character varying, "ssn" character varying, "created_at" timestamp, "updated_at" timestamp)  +  (3.0ms) CREATE TABLE "places" ("id" serial primary key, "address" text, "city" character varying, "cstate" character varying, "country" character varying, "created_at" timestamp, "updated_at" timestamp) +  (1.6ms) CREATE TABLE "schema_migrations" ("version" character varying NOT NULL)  +  (1.0ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") +  (0.3ms) SELECT version FROM "schema_migrations" +  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141228200440') +  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141228200436') +  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141228200437') +  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141228200438') +  (0.2ms) INSERT INTO "schema_migrations" (version) VALUES ('20141228200439') + ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.1ms) BEGIN +------------------------------------ +SchemaDumperTest: test_dump_and_load +------------------------------------ +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +----------------------------------- +SchemaDumperTest: test_regex_ignore +----------------------------------- +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------ +SchemaDumperTest: test_symbol_ignore +------------------------------------ +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------- +SchemaDumperTest: test_union +---------------------------- +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (2.0ms) SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type IN ('BASE TABLE', 'VIEW') + +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.5ms) INSERT INTO "people" ("first_name", "last_name", "ssn") VALUES ($1, $2, $3) RETURNING "id" [["first_name", "Joe"], ["last_name", "User"], ["ssn", "123456789"]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.7ms) INSERT INTO "people2" ("first_name", "last_name", "ssn", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["first_name", "Jane"], ["last_name", "Doe"], ["ssn", "222334444"], ["created_at", "2015-01-12 09:15:10.521336"], ["updated_at", "2015-01-12 09:15:10.521336"]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +  (0.3ms) DROP VIEW "v_profile" +PG::UndefinedTable: ERROR: view "v_profile" does not exist +: DROP VIEW "v_profile" +  (0.3ms) CREATE VIEW "v_profile" ("first_name", "last_name", "ssn") AS select first_name, last_name, ssn from people + UNION + select first_name, last_name, ssn from people2 + +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_profile" ("first_name", "last_name", "ssn") AS select first_name, last_name, ssn from people + UNION + select first_name, last_name, ssn from people2 + +  (0.2ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------- +SchemaDumperTest: test_view +--------------------------- +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.2ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------------ +SchemaDumperTest: test_view_creation_order +------------------------------------------ +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------------- +RailsSqlViews4Test: test_test_the_true +-------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------ +RailsSqlViews4Test: test_truth +------------------------------ +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------------------------------- +ViewModelTest: test_access_cloned_belongs_to_association +-------------------------------------------------------- +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------------------------ +ViewModelTest: test_access_cloned_has_many_association +------------------------------------------------------ +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------------------------------- +ViewModelTest: test_cloned_belongs_to_association_exists +-------------------------------------------------------- +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------- +ViewModelTest: test_cloned_habtm_association_exists +--------------------------------------------------- +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------------------------ +ViewModelTest: test_cloned_has_many_association_exists +------------------------------------------------------ +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------- +ViewModelTest: test_same_person +------------------------------- +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------ +ViewOperationsTest: test_create_view +------------------------------------ +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.2ms) INSERT INTO "people" ("first_name", "last_name", "ssn") VALUES ($1, $2, $3) RETURNING "id" [["first_name", "John"], ["last_name", "Doe"], ["ssn", "123456789"]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security") AS select id, first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security") AS select id, first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------------- +ViewOperationsTest: test_drop_view +---------------------------------- +  (0.2ms) DROP VIEW "v_place" +PG::UndefinedTable: ERROR: view "v_place" does not exist +: DROP VIEW "v_place" +  (0.1ms) CREATE VIEW "v_place" ("v_address", "v_city", "v_state", "v_country") AS select address, city, cstate, country from places +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_place" ("v_address", "v_city", "v_state", "v_country") AS select address, city, cstate, country from places +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------- +ViewOperationsTest: test_no_view_raises_error +--------------------------------------------- +  (1.2ms)  SELECT view_definition + FROM information_schema.views + WHERE table_catalog = (SELECT catalog_name FROM information_schema.information_schema_catalog_name) + AND table_schema IN ('"$user"','public') + AND table_name = 'foo' + +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +----------------------------- +AdapterTest: test_base_tables +----------------------------- +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------- +AdapterTest: test_columns +------------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------------- +AdapterTest: test_current_database +---------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_mapped_columns +-------------------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------ +AdapterTest: test_mapped_views +------------------------------ +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------- +AdapterTest: test_old_name_not_found_error_during_mapping +--------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------------------------------- +AdapterTest: test_only_base_table_triggers_are_dropped_for_disabled_ref_integrity +--------------------------------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_supports_views +-------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------ +AdapterTest: test_tables +------------------------ + ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.1ms) BEGIN +----------------------------- +AdapterTest: test_base_tables +----------------------------- +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------- +AdapterTest: test_columns +------------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------------- +AdapterTest: test_current_database +---------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_mapped_columns +-------------------------------- +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------ +AdapterTest: test_mapped_views +------------------------------ +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------- +AdapterTest: test_old_name_not_found_error_during_mapping +--------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------------------------------- +AdapterTest: test_only_base_table_triggers_are_dropped_for_disabled_ref_integrity +--------------------------------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_supports_views +-------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------ +AdapterTest: test_tables +------------------------ +  (0.5ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +Could not log "sql.active_record" event. SignalException: SIGHUP ["/Users/laurent/.rvm/gems/ruby-2.1.5/gems/activesupport-4.2.0.rc3/lib/active_support/tagged_logging.rb:46:in `current_tags'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/activesupport-4.2.0.rc3/lib/active_support/tagged_logging.rb:51:in `tags_text'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/activesupport-4.2.0.rc3/lib/active_support/tagged_logging.rb:21:in `call'", "/Users/laurent/.rvm/rubies/ruby-2.1.5/lib/ruby/2.1.0/logger.rb:491:in `format_message'", "/Users/laurent/.rvm/rubies/ruby-2.1.5/lib/ruby/2.1.0/logger.rb:379:in `add'", "/Users/laurent/.rvm/rubies/ruby-2.1.5/lib/ruby/2.1.0/logger.rb:400:in `debug'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/activesupport-4.2.0.rc3/lib/active_support/log_subscriber.rb:93:in `debug'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.0.rc3/lib/active_record/log_subscriber.rb:62:in `sql'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/activesupport-4.2.0.rc3/lib/active_support/subscriber.rb:100:in `finish'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/activesupport-4.2.0.rc3/lib/active_support/log_subscriber.rb:83:in `finish'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/activesupport-4.2.0.rc3/lib/active_support/notifications/fanout.rb:102:in `finish'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/activesupport-4.2.0.rc3/lib/active_support/notifications/fanout.rb:46:in `block in finish'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/activesupport-4.2.0.rc3/lib/active_support/notifications/fanout.rb:46:in `each'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/activesupport-4.2.0.rc3/lib/active_support/notifications/fanout.rb:46:in `finish'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/activesupport-4.2.0.rc3/lib/active_support/notifications/instrumenter.rb:36:in `finish'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/activesupport-4.2.0.rc3/lib/active_support/notifications/instrumenter.rb:25:in `instrument'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.0.rc3/lib/active_record/connection_adapters/abstract_adapter.rb:460:in `log'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.0.rc3/lib/active_record/connection_adapters/postgresql/database_statements.rb:154:in `execute'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.0.rc3/lib/active_record/connection_adapters/postgresql/database_statements.rb:227:in `rollback_db_transaction'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.0.rc3/lib/active_record/connection_adapters/abstract/transaction.rb:149:in `rollback'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.0.rc3/lib/active_record/connection_adapters/abstract/transaction.rb:183:in `rollback_transaction'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.0.rc3/lib/active_record/connection_adapters/abstract/database_statements.rb:221:in `rollback_transaction'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.0.rc3/lib/active_record/fixtures.rb:960:in `block in teardown_fixtures'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.0.rc3/lib/active_record/fixtures.rb:959:in `each'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.0.rc3/lib/active_record/fixtures.rb:959:in `teardown_fixtures'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/activerecord-4.2.0.rc3/lib/active_record/fixtures.rb:829:in `after_teardown'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/minitest-5.5.1/lib/minitest/test.rb:113:in `block (4 levels) in run'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/minitest-5.5.1/lib/minitest/test.rb:206:in `capture_exceptions'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/minitest-5.5.1/lib/minitest/test.rb:112:in `block (3 levels) in run'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/minitest-5.5.1/lib/minitest/test.rb:111:in `each'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/minitest-5.5.1/lib/minitest/test.rb:111:in `block (2 levels) in run'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/minitest-5.5.1/lib/minitest/test.rb:258:in `time_it'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/minitest-5.5.1/lib/minitest/test.rb:104:in `block in run'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/minitest-5.5.1/lib/minitest.rb:327:in `on_signal'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/minitest-5.5.1/lib/minitest/test.rb:278:in `with_info_handler'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/minitest-5.5.1/lib/minitest/test.rb:103:in `run'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/minitest-5.5.1/lib/minitest.rb:774:in `run_one_method'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/minitest-5.5.1/lib/minitest.rb:301:in `run_one_method'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/minitest-5.5.1/lib/minitest.rb:289:in `block (2 levels) in run'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/minitest-5.5.1/lib/minitest.rb:288:in `each'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/minitest-5.5.1/lib/minitest.rb:288:in `block in run'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/minitest-5.5.1/lib/minitest.rb:327:in `on_signal'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/minitest-5.5.1/lib/minitest.rb:314:in `with_info_handler'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/minitest-5.5.1/lib/minitest.rb:287:in `run'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/minitest-5.5.1/lib/minitest.rb:150:in `block in __run'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/minitest-5.5.1/lib/minitest.rb:150:in `map'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/minitest-5.5.1/lib/minitest.rb:150:in `__run'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/minitest-5.5.1/lib/minitest.rb:127:in `run'", "/Users/laurent/.rvm/gems/ruby-2.1.5/gems/minitest-5.5.1/lib/minitest.rb:56:in `block in autorun'"] +  (113.0ms) DROP DATABASE IF EXISTS "rails_sql_views_unittest" +  (236.2ms) CREATE DATABASE "rails_sql_views_unittest" ENCODING = 'unicode' +  (113.1ms) DROP DATABASE IF EXISTS "rails_sql_views_unittest" +  (236.8ms) CREATE DATABASE "rails_sql_views_unittest" ENCODING = 'unicode' + SQL (0.9ms) CREATE EXTENSION IF NOT EXISTS "plpgsql" +  (3.9ms) CREATE TABLE "items" ("id" serial primary key, "person_id" integer, "created_at" timestamp, "updated_at" timestamp) +  (1.7ms) CREATE TABLE "items_people" ("id" serial primary key, "person_id" integer, "item_id" integer, "created_at" timestamp, "updated_at" timestamp)  +  (2.3ms) CREATE TABLE "people" ("id" serial primary key, "first_name" character varying, "last_name" character varying, "ssn" character varying, "address_id" integer) +  (2.9ms) CREATE TABLE "people2" ("id" serial primary key, "first_name" character varying, "last_name" character varying, "ssn" character varying, "created_at" timestamp, "updated_at" timestamp)  +  (2.4ms) CREATE TABLE "places" ("id" serial primary key, "address" text, "city" character varying, "cstate" character varying, "country" character varying, "created_at" timestamp, "updated_at" timestamp) +  (1.4ms) CREATE TABLE "schema_migrations" ("version" character varying NOT NULL)  +  (0.9ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") +  (0.2ms) SELECT version FROM "schema_migrations" +  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141228200440') +  (0.4ms) INSERT INTO "schema_migrations" (version) VALUES ('20141228200436') +  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141228200437') +  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141228200438') +  (0.3ms) INSERT INTO "schema_migrations" (version) VALUES ('20141228200439') + ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.1ms) BEGIN +-------------------------------------- +RailsSqlViews4Test: test_test_the_true +-------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------ +RailsSqlViews4Test: test_truth +------------------------------ +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +----------------------------- +AdapterTest: test_base_tables +----------------------------- +  (0.5ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.4ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +------------------------- +AdapterTest: test_columns +------------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------------- +AdapterTest: test_current_database +---------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_mapped_columns +-------------------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------ +AdapterTest: test_mapped_views +------------------------------ +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------- +AdapterTest: test_old_name_not_found_error_during_mapping +--------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------------------------------- +AdapterTest: test_only_base_table_triggers_are_dropped_for_disabled_ref_integrity +--------------------------------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_supports_views +-------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------ +AdapterTest: test_tables +------------------------ +  (0.6ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.6ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.5ms) ROLLBACK +  (0.2ms) BEGIN +--------------------------------------- +AdapterTest: test_view_select_statement +--------------------------------------- +  (2.5ms)  SELECT view_definition + FROM information_schema.views + WHERE table_catalog = (SELECT catalog_name FROM information_schema.information_schema_catalog_name) + AND table_schema IN ('"$user"','public') + AND table_name = 'v_people' + +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +----------------------- +AdapterTest: test_views +----------------------- +  (0.5ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.5ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +-------------------------------------------------------- +ViewModelTest: test_access_cloned_belongs_to_association +-------------------------------------------------------- +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +------------------------------------------------------ +ViewModelTest: test_access_cloned_has_many_association +------------------------------------------------------ +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------------------------------- +ViewModelTest: test_cloned_belongs_to_association_exists +-------------------------------------------------------- +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.2ms) ROLLBACK +  (0.3ms) BEGIN +--------------------------------------------------- +ViewModelTest: test_cloned_habtm_association_exists +--------------------------------------------------- +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +------------------------------------------------------ +ViewModelTest: test_cloned_has_many_association_exists +------------------------------------------------------ +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +------------------------------- +ViewModelTest: test_same_person +------------------------------- +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.2ms) BEGIN +------------------------------------ +ViewOperationsTest: test_create_view +------------------------------------ +  (1.9ms) SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type IN ('BASE TABLE', 'VIEW') + +  (0.3ms) SAVEPOINT active_record_1 + SQL (0.6ms) INSERT INTO "people" ("first_name", "last_name", "ssn") VALUES ($1, $2, $3) RETURNING "id" [["first_name", "John"], ["last_name", "Doe"], ["ssn", "123456789"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.4ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security") AS select id, first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security") AS select id, first_name, last_name, ssn from people +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------------- +ViewOperationsTest: test_drop_view +---------------------------------- +  (0.3ms) DROP VIEW "v_place" +PG::UndefinedTable: ERROR: view "v_place" does not exist +: DROP VIEW "v_place" +  (0.3ms) CREATE VIEW "v_place" ("v_address", "v_city", "v_state", "v_country") AS select address, city, cstate, country from places +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_place" ("v_address", "v_city", "v_state", "v_country") AS select address, city, cstate, country from places +  (0.3ms) ROLLBACK +  (0.2ms) BEGIN +--------------------------------------------- +ViewOperationsTest: test_no_view_raises_error +--------------------------------------------- +  (0.7ms) SELECT view_definition + FROM information_schema.views + WHERE table_catalog = (SELECT catalog_name FROM information_schema.information_schema_catalog_name) + AND table_schema IN ('"$user"','public') + AND table_name = 'foo' + +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------ +SchemaDumperTest: test_dump_and_load +------------------------------------ +  (0.2ms) drop view if exists V_PEOPLE +  (0.2ms) drop view if exists V_PROFILE +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.3ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +----------------------------------- +SchemaDumperTest: test_regex_ignore +----------------------------------- +  (0.2ms) drop view if exists V_PEOPLE +  (0.2ms) drop view if exists V_PROFILE +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.3ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +------------------------------------ +SchemaDumperTest: test_symbol_ignore +------------------------------------ +  (0.2ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.4ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.4ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.3ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------- +SchemaDumperTest: test_union +---------------------------- +  (0.2ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.4ms) INSERT INTO "people" ("first_name", "last_name", "ssn") VALUES ($1, $2, $3) RETURNING "id" [["first_name", "Joe"], ["last_name", "User"], ["ssn", "123456789"]] +  (0.4ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.5ms) INSERT INTO "people2" ("first_name", "last_name", "ssn", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["first_name", "Jane"], ["last_name", "Doe"], ["ssn", "222334444"], ["created_at", "2015-01-12 09:25:12.040851"], ["updated_at", "2015-01-12 09:25:12.040851"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.4ms) DROP VIEW "v_profile" +PG::UndefinedTable: ERROR: view "v_profile" does not exist +: DROP VIEW "v_profile" +  (0.3ms) CREATE VIEW "v_profile" ("first_name", "last_name", "ssn") AS select first_name, last_name, ssn from people + UNION + select first_name, last_name, ssn from people2 + +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_profile" ("first_name", "last_name", "ssn") AS select first_name, last_name, ssn from people + UNION + select first_name, last_name, ssn from people2 + +  (0.3ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------- +SchemaDumperTest: test_view +--------------------------- +  (0.2ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.3ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +------------------------------------------ +SchemaDumperTest: test_view_creation_order +------------------------------------------ +  (0.2ms) drop view if exists V_PEOPLE +  (0.2ms) drop view if exists V_PROFILE +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.3ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.2ms) ROLLBACK + ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.1ms) BEGIN +----------------------------- +AdapterTest: test_base_tables +----------------------------- +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------- +AdapterTest: test_columns +------------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------------- +AdapterTest: test_current_database +---------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_mapped_columns +-------------------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------ +AdapterTest: test_mapped_views +------------------------------ +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------- +AdapterTest: test_old_name_not_found_error_during_mapping +--------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------------------------------- +AdapterTest: test_only_base_table_triggers_are_dropped_for_disabled_ref_integrity +--------------------------------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_supports_views +-------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------ +AdapterTest: test_tables +------------------------ +  (0.7ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.6ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.5ms) ROLLBACK +  (0.2ms) BEGIN +--------------------------------------- +AdapterTest: test_view_select_statement +--------------------------------------- +  (2.0ms)  SELECT view_definition + FROM information_schema.views + WHERE table_catalog = (SELECT catalog_name FROM information_schema.information_schema_catalog_name) + AND table_schema IN ('"$user"','public') + AND table_name = 'v_people' + +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +----------------------- +AdapterTest: test_views +----------------------- +  (0.4ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.2ms) ROLLBACK +  (0.3ms) BEGIN +-------------------------------------- +RailsSqlViews4Test: test_test_the_true +-------------------------------------- +  (0.3ms) ROLLBACK +  (0.2ms) BEGIN +------------------------------ +RailsSqlViews4Test: test_truth +------------------------------ +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +------------------------------------ +ViewOperationsTest: test_create_view +------------------------------------ +  (1.4ms) SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type IN ('BASE TABLE', 'VIEW') + +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.4ms) INSERT INTO "people" ("first_name", "last_name", "ssn") VALUES ($1, $2, $3) RETURNING "id" [["first_name", "John"], ["last_name", "Doe"], ["ssn", "123456789"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.4ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security") AS select id, first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security") AS select id, first_name, last_name, ssn from people +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------------- +ViewOperationsTest: test_drop_view +---------------------------------- +  (0.3ms) DROP VIEW "v_place" +PG::UndefinedTable: ERROR: view "v_place" does not exist +: DROP VIEW "v_place" +  (0.3ms) CREATE VIEW "v_place" ("v_address", "v_city", "v_state", "v_country") AS select address, city, cstate, country from places +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_place" ("v_address", "v_city", "v_state", "v_country") AS select address, city, cstate, country from places +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +--------------------------------------------- +ViewOperationsTest: test_no_view_raises_error +--------------------------------------------- +  (0.7ms) SELECT view_definition + FROM information_schema.views + WHERE table_catalog = (SELECT catalog_name FROM information_schema.information_schema_catalog_name) + AND table_schema IN ('"$user"','public') + AND table_name = 'foo' + +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +-------------------------------------------------------- +ViewModelTest: test_access_cloned_belongs_to_association +-------------------------------------------------------- +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +------------------------------------------------------ +ViewModelTest: test_access_cloned_has_many_association +------------------------------------------------------ +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +-------------------------------------------------------- +ViewModelTest: test_cloned_belongs_to_association_exists +-------------------------------------------------------- +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +--------------------------------------------------- +ViewModelTest: test_cloned_habtm_association_exists +--------------------------------------------------- +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +------------------------------------------------------ +ViewModelTest: test_cloned_has_many_association_exists +------------------------------------------------------ +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +------------------------------- +ViewModelTest: test_same_person +------------------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------ +SchemaDumperTest: test_dump_and_load +------------------------------------ +  (0.2ms) drop view if exists V_PEOPLE +  (0.2ms) drop view if exists V_PROFILE +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.2ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +----------------------------------- +SchemaDumperTest: test_regex_ignore +----------------------------------- +  (0.2ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.2ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +------------------------------------ +SchemaDumperTest: test_symbol_ignore +------------------------------------ +  (0.1ms) drop view if exists V_PEOPLE +  (0.2ms) drop view if exists V_PROFILE +  (0.4ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.3ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.3ms) ROLLBACK +  (0.2ms) BEGIN +---------------------------- +SchemaDumperTest: test_union +---------------------------- +  (0.2ms) drop view if exists V_PEOPLE +  (0.2ms) drop view if exists V_PROFILE +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.2ms) INSERT INTO "people" ("first_name", "last_name", "ssn") VALUES ($1, $2, $3) RETURNING "id" [["first_name", "Joe"], ["last_name", "User"], ["ssn", "123456789"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.3ms) SAVEPOINT active_record_1 + SQL (0.4ms) INSERT INTO "people2" ("first_name", "last_name", "ssn", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["first_name", "Jane"], ["last_name", "Doe"], ["ssn", "222334444"], ["created_at", "2015-01-12 09:40:09.285243"], ["updated_at", "2015-01-12 09:40:09.285243"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.3ms) DROP VIEW "v_profile" +PG::UndefinedTable: ERROR: view "v_profile" does not exist +: DROP VIEW "v_profile" +  (0.3ms) CREATE VIEW "v_profile" ("first_name", "last_name", "ssn") AS select first_name, last_name, ssn from people + UNION + select first_name, last_name, ssn from people2 + +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_profile" ("first_name", "last_name", "ssn") AS select first_name, last_name, ssn from people + UNION + select first_name, last_name, ssn from people2 + +  (0.2ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +--------------------------- +SchemaDumperTest: test_view +--------------------------- +  (0.2ms) drop view if exists V_PEOPLE +  (0.2ms) drop view if exists V_PROFILE +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.3ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.2ms) BEGIN +------------------------------------------ +SchemaDumperTest: test_view_creation_order +------------------------------------------ +  (0.2ms) drop view if exists V_PEOPLE +  (0.2ms) drop view if exists V_PROFILE +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.2ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.2ms) ROLLBACK + ActiveRecord::SchemaMigration Load (0.6ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.2ms) BEGIN +------------------------------------ +SchemaDumperTest: test_dump_and_load +------------------------------------ +  (0.3ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.5ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.4ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +----------------------------------- +SchemaDumperTest: test_regex_ignore +----------------------------------- +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------ +SchemaDumperTest: test_symbol_ignore +------------------------------------ +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------- +SchemaDumperTest: test_union +---------------------------- +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (3.0ms) SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type IN ('BASE TABLE', 'VIEW') + +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "people" ("first_name", "last_name", "ssn") VALUES ($1, $2, $3) RETURNING "id" [["first_name", "Joe"], ["last_name", "User"], ["ssn", "123456789"]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.4ms) INSERT INTO "people2" ("first_name", "last_name", "ssn", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["first_name", "Jane"], ["last_name", "Doe"], ["ssn", "222334444"], ["created_at", "2015-01-12 09:40:42.493888"], ["updated_at", "2015-01-12 09:40:42.493888"]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +  (0.4ms) DROP VIEW "v_profile" +PG::UndefinedTable: ERROR: view "v_profile" does not exist +: DROP VIEW "v_profile" +  (0.2ms) CREATE VIEW "v_profile" ("first_name", "last_name", "ssn") AS select first_name, last_name, ssn from people + UNION + select first_name, last_name, ssn from people2 + +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_profile" ("first_name", "last_name", "ssn") AS select first_name, last_name, ssn from people + UNION + select first_name, last_name, ssn from people2 + +  (0.2ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------- +SchemaDumperTest: test_view +--------------------------- +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.2ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------------ +SchemaDumperTest: test_view_creation_order +------------------------------------------ +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.3ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------ +ViewOperationsTest: test_create_view +------------------------------------ +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "people" ("first_name", "last_name", "ssn") VALUES ($1, $2, $3) RETURNING "id" [["first_name", "John"], ["last_name", "Doe"], ["ssn", "123456789"]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +  (0.5ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security") AS select id, first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security") AS select id, first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------------- +ViewOperationsTest: test_drop_view +---------------------------------- +  (0.2ms) DROP VIEW "v_place" +PG::UndefinedTable: ERROR: view "v_place" does not exist +: DROP VIEW "v_place" +  (0.1ms) CREATE VIEW "v_place" ("v_address", "v_city", "v_state", "v_country") AS select address, city, cstate, country from places +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_place" ("v_address", "v_city", "v_state", "v_country") AS select address, city, cstate, country from places +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------- +ViewOperationsTest: test_no_view_raises_error +--------------------------------------------- +  (1.7ms)  SELECT view_definition + FROM information_schema.views + WHERE table_catalog = (SELECT catalog_name FROM information_schema.information_schema_catalog_name) + AND table_schema IN ('"$user"','public') + AND table_name = 'foo' + +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------------- +RailsSqlViews4Test: test_test_the_true +-------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------ +RailsSqlViews4Test: test_truth +------------------------------ +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +----------------------------- +AdapterTest: test_base_tables +----------------------------- +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------- +AdapterTest: test_columns +------------------------- +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------------- +AdapterTest: test_current_database +---------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_mapped_columns +-------------------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------ +AdapterTest: test_mapped_views +------------------------------ +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------- +AdapterTest: test_old_name_not_found_error_during_mapping +--------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------------------------------- +AdapterTest: test_only_base_table_triggers_are_dropped_for_disabled_ref_integrity +--------------------------------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_supports_views +-------------------------------- +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +------------------------ +AdapterTest: test_tables +------------------------ + ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.1ms) BEGIN +----------------------------- +AdapterTest: test_base_tables +----------------------------- +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------- +AdapterTest: test_columns +------------------------- +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------------- +AdapterTest: test_current_database +---------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_mapped_columns +-------------------------------- +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------ +AdapterTest: test_mapped_views +------------------------------ +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------- +AdapterTest: test_old_name_not_found_error_during_mapping +--------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------------------------------- +AdapterTest: test_only_base_table_triggers_are_dropped_for_disabled_ref_integrity +--------------------------------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_supports_views +-------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------ +AdapterTest: test_tables +------------------------ +  (2.8ms) CREATE VIEW "toto" AS select id, first_name from people +  (0.5ms) CREATE VIEW "toto" AS select id, first_name from people +PG::DuplicateTable: ERROR: relation "toto" already exists +: CREATE VIEW "toto" AS select id, first_name from people +  (0.4ms) DROP VIEW "totota" +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: DROP VIEW "totota" +  (0.3ms) CREATE VIEW "totota" AS select id, first_name from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "totota" AS select id, first_name from people +  (0.7ms) CREATE VIEW "totota" AS select id, first_name from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "totota" AS select id, first_name from people +  (0.4ms) CREATE VIEW "totota" AS select id, first_name from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "totota" AS select id, first_name from people +  (0.3ms) CREATE VIEW "totota" AS select id, first_name from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "totota" AS select id, first_name from people +  (0.3ms) CREATE VIEW "totota" AS select id, first_name from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "totota" AS select id, first_name from people +  (0.3ms) CREATE VIEW "totota" AS select id, first_name from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "totota" AS select id, first_name from people + ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.3ms) BEGIN +----------------------------- +AdapterTest: test_base_tables +----------------------------- +  (0.6ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +------------------------- +AdapterTest: test_columns +------------------------- +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------------- +AdapterTest: test_current_database +---------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_mapped_columns +-------------------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------ +AdapterTest: test_mapped_views +------------------------------ +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------- +AdapterTest: test_old_name_not_found_error_during_mapping +--------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------------------------------- +AdapterTest: test_only_base_table_triggers_are_dropped_for_disabled_ref_integrity +--------------------------------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_supports_views +-------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------ +AdapterTest: test_tables +------------------------ +  (2.4ms) CREATE VIEW "tata" AS select id, first_name from people +  (1.0ms) CREATE VIEW "tataplus" AS select id, first_name from people +  (0.5ms) DROP VIEW "tatamoins" +PG::UndefinedTable: ERROR: view "tatamoins" does not exist +: DROP VIEW "tatamoins" +  (0.3ms) CREATE VIEW "tatamoins" AS select id, first_name from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "tatamoins" AS select id, first_name from people + ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.2ms) BEGIN +----------------------------- +AdapterTest: test_base_tables +----------------------------- +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------- +AdapterTest: test_columns +------------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------------- +AdapterTest: test_current_database +---------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_mapped_columns +-------------------------------- +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------ +AdapterTest: test_mapped_views +------------------------------ +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------- +AdapterTest: test_old_name_not_found_error_during_mapping +--------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------------------------------- +AdapterTest: test_only_base_table_triggers_are_dropped_for_disabled_ref_integrity +--------------------------------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_supports_views +-------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------ +AdapterTest: test_tables +------------------------ +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" + ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.2ms) BEGIN +------------------------------------ +SchemaDumperTest: test_dump_and_load +------------------------------------ +  (0.2ms) drop view if exists V_PEOPLE +  (0.2ms) drop view if exists V_PROFILE +  (0.5ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.2ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +----------------------------------- +SchemaDumperTest: test_regex_ignore +----------------------------------- +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.2ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------ +SchemaDumperTest: test_symbol_ignore +------------------------------------ +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------- +SchemaDumperTest: test_union +---------------------------- +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (2.2ms) SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type IN ('BASE TABLE', 'VIEW') + +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "people" ("first_name", "last_name", "ssn") VALUES ($1, $2, $3) RETURNING "id" [["first_name", "Joe"], ["last_name", "User"], ["ssn", "123456789"]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "people2" ("first_name", "last_name", "ssn", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["first_name", "Jane"], ["last_name", "Doe"], ["ssn", "222334444"], ["created_at", "2015-01-12 10:36:59.142744"], ["updated_at", "2015-01-12 10:36:59.142744"]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) DROP VIEW "v_profile" +PG::UndefinedTable: ERROR: view "v_profile" does not exist +: DROP VIEW "v_profile" +  (0.2ms) CREATE VIEW "v_profile" ("first_name", "last_name", "ssn") AS select first_name, last_name, ssn from people + UNION + select first_name, last_name, ssn from people2 + +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_profile" ("first_name", "last_name", "ssn") AS select first_name, last_name, ssn from people + UNION + select first_name, last_name, ssn from people2 + +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------- +SchemaDumperTest: test_view +--------------------------- +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------------ +SchemaDumperTest: test_view_creation_order +------------------------------------------ +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------------------------------- +ViewModelTest: test_access_cloned_belongs_to_association +-------------------------------------------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------------------------ +ViewModelTest: test_access_cloned_has_many_association +------------------------------------------------------ +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------------------------------- +ViewModelTest: test_cloned_belongs_to_association_exists +-------------------------------------------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------- +ViewModelTest: test_cloned_habtm_association_exists +--------------------------------------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------------------------ +ViewModelTest: test_cloned_has_many_association_exists +------------------------------------------------------ +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------- +ViewModelTest: test_same_person +------------------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +----------------------------- +AdapterTest: test_base_tables +----------------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------- +AdapterTest: test_columns +------------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------------- +AdapterTest: test_current_database +---------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_mapped_columns +-------------------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------ +AdapterTest: test_mapped_views +------------------------------ +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.1ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------- +AdapterTest: test_old_name_not_found_error_during_mapping +--------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------------------------------- +AdapterTest: test_only_base_table_triggers_are_dropped_for_disabled_ref_integrity +--------------------------------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_supports_views +-------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------ +AdapterTest: test_tables +------------------------ +  (0.7ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.6ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.5ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------- +AdapterTest: test_view_select_statement +--------------------------------------- +  (1.3ms) SELECT view_definition + FROM information_schema.views + WHERE table_catalog = (SELECT catalog_name FROM information_schema.information_schema_catalog_name) + AND table_schema IN ('"$user"','public') + AND table_name = 'v_people' + +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +----------------------- +AdapterTest: test_views +----------------------- +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +-------------------------------------- +RailsSqlViews4Test: test_test_the_true +-------------------------------------- +  (0.7ms) ROLLBACK +  (0.2ms) BEGIN +------------------------------ +RailsSqlViews4Test: test_truth +------------------------------ +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------ +ViewOperationsTest: test_create_view +------------------------------------ +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.5ms) INSERT INTO "people" ("first_name", "last_name", "ssn") VALUES ($1, $2, $3) RETURNING "id" [["first_name", "John"], ["last_name", "Doe"], ["ssn", "123456789"]] +  (0.3ms) RELEASE SAVEPOINT active_record_1 +  (0.4ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security") AS select id, first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security") AS select id, first_name, last_name, ssn from people +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +---------------------------------- +ViewOperationsTest: test_drop_view +---------------------------------- +  (0.3ms) DROP VIEW "v_place" +PG::UndefinedTable: ERROR: view "v_place" does not exist +: DROP VIEW "v_place" +  (0.2ms) CREATE VIEW "v_place" ("v_address", "v_city", "v_state", "v_country") AS select address, city, cstate, country from places +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_place" ("v_address", "v_city", "v_state", "v_country") AS select address, city, cstate, country from places +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------- +ViewOperationsTest: test_no_view_raises_error +--------------------------------------------- +  (0.7ms) SELECT view_definition + FROM information_schema.views + WHERE table_catalog = (SELECT catalog_name FROM information_schema.information_schema_catalog_name) + AND table_schema IN ('"$user"','public') + AND table_name = 'foo' + +  (0.1ms) ROLLBACK + ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.3ms) BEGIN +------------------------------------ +SchemaDumperTest: test_dump_and_load +------------------------------------ +  (0.2ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (1.8ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people + ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (1.9ms)  SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type = 'BASE TABLE' + +  (0.9ms) SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type = 'VIEW' + +  (1.9ms)  SELECT view_definition + FROM information_schema.views + WHERE table_catalog = (SELECT catalog_name FROM information_schema.information_schema_catalog_name) + AND table_schema IN ('"$user"','public') + AND table_name = 'v_people' + + SQL (0.2ms) CREATE EXTENSION IF NOT EXISTS "plpgsql" +  (0.7ms) DROP TABLE "items" CASCADE +  (1.8ms) CREATE TABLE "items" ("id" serial primary key, "person_id" integer, "created_at" timestamp, "updated_at" timestamp) +  (0.5ms) DROP TABLE "items_people" CASCADE +  (1.6ms) CREATE TABLE "items_people" ("id" serial primary key, "person_id" integer, "item_id" integer, "created_at" timestamp, "updated_at" timestamp) +  (1.2ms) DROP TABLE "people" CASCADE +  (2.7ms) CREATE TABLE "people" ("id" serial primary key, "first_name" character varying, "last_name" character varying, "ssn" character varying, "address_id" integer) +  (0.9ms) DROP TABLE "people2" CASCADE +  (3.1ms) CREATE TABLE "people2" ("id" serial primary key, "first_name" character varying, "last_name" character varying, "ssn" character varying, "created_at" timestamp, "updated_at" timestamp) +  (0.8ms) DROP TABLE "places" CASCADE +  (2.6ms) CREATE TABLE "places" ("id" serial primary key, "address" text, "city" character varying, "cstate" character varying, "country" character varying, "created_at" timestamp, "updated_at" timestamp) +  (4.4ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS SELECT people.id, + people.first_name AS f_name, + people.last_name AS l_name, + people.ssn AS social_security, + people.address_id + FROM people; +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS SELECT people.id, + people.first_name AS f_name, + people.last_name AS l_name, + people.ssn AS social_security, + people.address_id + FROM people; +  (0.2ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +----------------------------------- +SchemaDumperTest: test_regex_ignore +----------------------------------- +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (1.0ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people + ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (1.1ms) SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type = 'BASE TABLE' + +  (0.9ms)  SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type = 'VIEW' + + SQL (0.2ms) CREATE EXTENSION IF NOT EXISTS "plpgsql" +  (0.5ms) DROP TABLE "items" CASCADE +  (1.4ms) CREATE TABLE "items" ("id" serial primary key, "person_id" integer, "created_at" timestamp, "updated_at" timestamp) +  (0.5ms) DROP TABLE "items_people" CASCADE +  (1.5ms) CREATE TABLE "items_people" ("id" serial primary key, "person_id" integer, "item_id" integer, "created_at" timestamp, "updated_at" timestamp) +  (0.8ms) DROP TABLE "people" CASCADE +  (2.7ms) CREATE TABLE "people" ("id" serial primary key, "first_name" character varying, "last_name" character varying, "ssn" character varying, "address_id" integer) +  (0.5ms) DROP TABLE "people2" CASCADE +  (1.9ms) CREATE TABLE "people2" ("id" serial primary key, "first_name" character varying, "last_name" character varying, "ssn" character varying, "created_at" timestamp, "updated_at" timestamp) +  (0.5ms) DROP TABLE "places" CASCADE +  (2.3ms) CREATE TABLE "places" ("id" serial primary key, "address" text, "city" character varying, "cstate" character varying, "country" character varying, "created_at" timestamp, "updated_at" timestamp) +  (0.5ms) SELECT version FROM "schema_migrations" +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (2.5ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------ +SchemaDumperTest: test_symbol_ignore +------------------------------------ +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (1.0ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people + ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (1.9ms) SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type = 'BASE TABLE' + +  (0.8ms)  SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type = 'VIEW' + + SQL (0.1ms) CREATE EXTENSION IF NOT EXISTS "plpgsql" +  (0.6ms) DROP TABLE "items" CASCADE +  (2.0ms) CREATE TABLE "items" ("id" serial primary key, "person_id" integer, "created_at" timestamp, "updated_at" timestamp) +  (0.6ms) DROP TABLE "items_people" CASCADE +  (1.9ms) CREATE TABLE "items_people" ("id" serial primary key, "person_id" integer, "item_id" integer, "created_at" timestamp, "updated_at" timestamp) +  (0.7ms) DROP TABLE "people" CASCADE +  (2.0ms) CREATE TABLE "people" ("id" serial primary key, "first_name" character varying, "last_name" character varying, "ssn" character varying, "address_id" integer) +  (0.5ms) DROP TABLE "people2" CASCADE +  (2.0ms) CREATE TABLE "people2" ("id" serial primary key, "first_name" character varying, "last_name" character varying, "ssn" character varying, "created_at" timestamp, "updated_at" timestamp) +  (0.9ms) DROP TABLE "places" CASCADE +  (2.8ms) CREATE TABLE "places" ("id" serial primary key, "address" text, "city" character varying, "cstate" character varying, "country" character varying, "created_at" timestamp, "updated_at" timestamp) +  (0.2ms) SELECT version FROM "schema_migrations" +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (2.2ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------- +SchemaDumperTest: test_union +---------------------------- +  (0.2ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.9ms) SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type IN ('BASE TABLE', 'VIEW') + +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.4ms) INSERT INTO "people" ("first_name", "last_name", "ssn") VALUES ($1, $2, $3) RETURNING "id" [["first_name", "Joe"], ["last_name", "User"], ["ssn", "123456789"]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.4ms) INSERT INTO "people2" ("first_name", "last_name", "ssn", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["first_name", "Jane"], ["last_name", "Doe"], ["ssn", "222334444"], ["created_at", "2015-01-12 10:37:34.124008"], ["updated_at", "2015-01-12 10:37:34.124008"]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) DROP VIEW "v_profile" +PG::UndefinedTable: ERROR: view "v_profile" does not exist +: DROP VIEW "v_profile" +  (0.2ms) CREATE VIEW "v_profile" ("first_name", "last_name", "ssn") AS select first_name, last_name, ssn from people + UNION + select first_name, last_name, ssn from people2 + +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_profile" ("first_name", "last_name", "ssn") AS select first_name, last_name, ssn from people + UNION + select first_name, last_name, ssn from people2 + +  (0.2ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------- +SchemaDumperTest: test_view +--------------------------- +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.9ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people + ActiveRecord::SchemaMigration Load (0.1ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.9ms) SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type = 'BASE TABLE' + +  (0.6ms)  SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type = 'VIEW' + +  (0.6ms) SELECT view_definition + FROM information_schema.views + WHERE table_catalog = (SELECT catalog_name FROM information_schema.information_schema_catalog_name) + AND table_schema IN ('"$user"','public') + AND table_name = 'v_people' + +  (0.4ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------------ +SchemaDumperTest: test_view_creation_order +------------------------------------------ +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.7ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people + ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.9ms)  SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type = 'BASE TABLE' + +  (0.7ms) SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type = 'VIEW' + +  (1.1ms)  SELECT view_definition + FROM information_schema.views + WHERE table_catalog = (SELECT catalog_name FROM information_schema.information_schema_catalog_name) + AND table_schema IN ('"$user"','public') + AND table_name = 'v_people' + +  (0.7ms) SELECT view_definition + FROM information_schema.views + WHERE table_catalog = (SELECT catalog_name FROM information_schema.information_schema_catalog_name) + AND table_schema IN ('"$user"','public') + AND table_name = 'v_people' + + SQL (0.1ms) CREATE EXTENSION IF NOT EXISTS "plpgsql" +  (0.5ms) DROP TABLE "items" CASCADE +  (1.4ms) CREATE TABLE "items" ("id" serial primary key, "person_id" integer, "created_at" timestamp, "updated_at" timestamp)  +  (0.4ms) DROP TABLE "items_people" CASCADE +  (1.3ms) CREATE TABLE "items_people" ("id" serial primary key, "person_id" integer, "item_id" integer, "created_at" timestamp, "updated_at" timestamp)  +  (0.9ms) DROP TABLE "people" CASCADE +  (2.5ms) CREATE TABLE "people" ("id" serial primary key, "first_name" character varying, "last_name" character varying, "ssn" character varying, "address_id" integer)  +  (0.5ms) DROP TABLE "people2" CASCADE +  (2.2ms) CREATE TABLE "people2" ("id" serial primary key, "first_name" character varying, "last_name" character varying, "ssn" character varying, "created_at" timestamp, "updated_at" timestamp)  +  (1.0ms) DROP TABLE "places" CASCADE +  (3.2ms) CREATE TABLE "places" ("id" serial primary key, "address" text, "city" character varying, "cstate" character varying, "country" character varying, "created_at" timestamp, "updated_at" timestamp)  +  (3.0ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.3ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS SELECT people.id, + people.first_name AS f_name, + people.last_name AS l_name, + people.ssn AS social_security, + people.address_id + FROM people; +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS SELECT people.id, + people.first_name AS f_name, + people.last_name AS l_name, + people.ssn AS social_security, + people.address_id + FROM people; +  (0.2ms) drop view if exists V_PEOPLE +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: drop view if exists V_PEOPLE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +----------------------------- +AdapterTest: test_base_tables +----------------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------- +AdapterTest: test_columns +------------------------- +  (0.2ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------------- +AdapterTest: test_current_database +---------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_mapped_columns +-------------------------------- +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------ +AdapterTest: test_mapped_views +------------------------------ +  (0.3ms) DROP VIEW "v_people" +PG::UndefinedTable: ERROR: view "v_people" does not exist +: DROP VIEW "v_people" +  (0.2ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +PG::InFailedSqlTransaction: ERROR: current transaction is aborted, commands ignored until end of transaction block +: CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------- +AdapterTest: test_old_name_not_found_error_during_mapping +--------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------------------------------- +AdapterTest: test_only_base_table_triggers_are_dropped_for_disabled_ref_integrity +--------------------------------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_supports_views +-------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------ +AdapterTest: test_tables +------------------------ + ActiveRecord::SchemaMigration Load (1.3ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.2ms) BEGIN +-------------------------------------- +RailsSqlViews4Test: test_test_the_true +-------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------ +RailsSqlViews4Test: test_truth +------------------------------ +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------ +ViewOperationsTest: test_create_view +------------------------------------ +  (2.9ms)  SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type IN ('BASE TABLE', 'VIEW') + +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.4ms) INSERT INTO "people" ("first_name", "last_name", "ssn") VALUES ($1, $2, $3) RETURNING "id" [["first_name", "John"], ["last_name", "Doe"], ["ssn", "123456789"]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +  (1.7ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security") AS select id, first_name, last_name, ssn from people + Person Load (0.6ms) SELECT "people".* FROM "people" ORDER BY "people"."id" ASC LIMIT 1 + VPerson Load (0.2ms) SELECT "v_people".* FROM "v_people" LIMIT 1 +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------------- +ViewOperationsTest: test_drop_view +---------------------------------- +  (0.7ms) CREATE VIEW "v_place" ("v_address", "v_city", "v_state", "v_country") AS select address, city, cstate, country from places +  (0.4ms) DROP VIEW "v_place" +  (0.3ms) SELECT * FROM v_place +PG::UndefinedTable: ERROR: relation "v_place" does not exist +LINE 1: SELECT * FROM v_place + ^ +: SELECT * FROM v_place +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------- +ViewOperationsTest: test_no_view_raises_error +--------------------------------------------- +  (1.1ms)  SELECT view_definition + FROM information_schema.views + WHERE table_catalog = (SELECT catalog_name FROM information_schema.information_schema_catalog_name) + AND table_schema IN ('"$user"','public') + AND table_name = 'foo' + +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +----------------------------- +AdapterTest: test_base_tables +----------------------------- +  (0.8ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (1.3ms)  SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type = 'BASE TABLE' + +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------- +AdapterTest: test_columns +------------------------- +  (0.8ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (0.5ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------------- +AdapterTest: test_current_database +---------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_mapped_columns +-------------------------------- +  (1.1ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------ +AdapterTest: test_mapped_views +------------------------------ +  (0.6ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.7ms)  SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type = 'VIEW' + +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------- +AdapterTest: test_old_name_not_found_error_during_mapping +--------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------------------------------- +AdapterTest: test_only_base_table_triggers_are_dropped_for_disabled_ref_integrity +--------------------------------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_supports_views +-------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------ +AdapterTest: test_tables +------------------------ +  (1.4ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (1.3ms)  SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type IN ('BASE TABLE', 'VIEW') + +  (0.6ms) ROLLBACK +  (0.2ms) BEGIN +--------------------------------------- +AdapterTest: test_view_select_statement +--------------------------------------- +  (1.1ms) SELECT view_definition + FROM information_schema.views + WHERE table_catalog = (SELECT catalog_name FROM information_schema.information_schema_catalog_name) + AND table_schema IN ('"$user"','public') + AND table_name = 'v_people' + +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +----------------------- +AdapterTest: test_views +----------------------- +  (1.0ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (1.7ms) SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type = 'VIEW' + +  (0.5ms) ROLLBACK +  (0.5ms) BEGIN +------------------------------------ +SchemaDumperTest: test_dump_and_load +------------------------------------ +  (0.4ms) drop view if exists V_PEOPLE +  (0.2ms) drop view if exists V_PROFILE +  (0.8ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people + ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.8ms)  SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type = 'BASE TABLE' + +  (0.8ms) SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type = 'VIEW' + +  (0.9ms)  SELECT view_definition + FROM information_schema.views + WHERE table_catalog = (SELECT catalog_name FROM information_schema.information_schema_catalog_name) + AND table_schema IN ('"$user"','public') + AND table_name = 'v_people' + + SQL (0.2ms) CREATE EXTENSION IF NOT EXISTS "plpgsql" +  (0.8ms) DROP TABLE "items" CASCADE +  (1.9ms) CREATE TABLE "items" ("id" serial primary key, "person_id" integer, "created_at" timestamp, "updated_at" timestamp) +  (0.6ms) DROP TABLE "items_people" CASCADE +  (1.6ms) CREATE TABLE "items_people" ("id" serial primary key, "person_id" integer, "item_id" integer, "created_at" timestamp, "updated_at" timestamp) +  (1.0ms) DROP TABLE "people" CASCADE +  (2.8ms) CREATE TABLE "people" ("id" serial primary key, "first_name" character varying, "last_name" character varying, "ssn" character varying, "address_id" integer) +  (1.1ms) DROP TABLE "people2" CASCADE +  (2.4ms) CREATE TABLE "people2" ("id" serial primary key, "first_name" character varying, "last_name" character varying, "ssn" character varying, "created_at" timestamp, "updated_at" timestamp) +  (1.0ms) DROP TABLE "places" CASCADE +  (3.4ms) CREATE TABLE "places" ("id" serial primary key, "address" text, "city" character varying, "cstate" character varying, "country" character varying, "created_at" timestamp, "updated_at" timestamp) +  (1.3ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS SELECT people.id, + people.first_name AS f_name, + people.last_name AS l_name, + people.ssn AS social_security, + people.address_id + FROM people; +  (0.2ms) SELECT version FROM "schema_migrations" +  (0.4ms) drop view if exists V_PEOPLE +  (0.2ms) drop view if exists V_PROFILE +  (2.9ms) ROLLBACK +  (0.2ms) BEGIN +----------------------------------- +SchemaDumperTest: test_regex_ignore +----------------------------------- +  (0.2ms) drop view if exists V_PEOPLE +  (0.2ms) drop view if exists V_PROFILE +  (1.0ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people + ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (1.0ms)  SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type = 'BASE TABLE' + +  (1.4ms) SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type = 'VIEW' + + SQL (0.2ms) CREATE EXTENSION IF NOT EXISTS "plpgsql" +  (0.6ms) DROP TABLE "items" CASCADE +  (1.6ms) CREATE TABLE "items" ("id" serial primary key, "person_id" integer, "created_at" timestamp, "updated_at" timestamp)  +  (0.5ms) DROP TABLE "items_people" CASCADE +  (1.4ms) CREATE TABLE "items_people" ("id" serial primary key, "person_id" integer, "item_id" integer, "created_at" timestamp, "updated_at" timestamp)  +  (0.7ms) DROP TABLE "people" CASCADE +  (2.1ms) CREATE TABLE "people" ("id" serial primary key, "first_name" character varying, "last_name" character varying, "ssn" character varying, "address_id" integer)  +  (1.1ms) DROP TABLE "people2" CASCADE +  (3.0ms) CREATE TABLE "people2" ("id" serial primary key, "first_name" character varying, "last_name" character varying, "ssn" character varying, "created_at" timestamp, "updated_at" timestamp)  +  (1.1ms) DROP TABLE "places" CASCADE +  (2.2ms) CREATE TABLE "places" ("id" serial primary key, "address" text, "city" character varying, "cstate" character varying, "country" character varying, "created_at" timestamp, "updated_at" timestamp)  +  (0.2ms) SELECT version FROM "schema_migrations" +  (0.2ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (2.1ms) ROLLBACK +  (0.3ms) BEGIN +------------------------------------ +SchemaDumperTest: test_symbol_ignore +------------------------------------ +  (0.3ms) drop view if exists V_PEOPLE +  (0.3ms) drop view if exists V_PROFILE +  (1.2ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people + ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (1.1ms)  SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type = 'BASE TABLE' + +  (0.7ms) SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type = 'VIEW' + + SQL (0.2ms) CREATE EXTENSION IF NOT EXISTS "plpgsql" +  (0.8ms) DROP TABLE "items" CASCADE +  (2.0ms) CREATE TABLE "items" ("id" serial primary key, "person_id" integer, "created_at" timestamp, "updated_at" timestamp)  +  (0.8ms) DROP TABLE "items_people" CASCADE +  (2.1ms) CREATE TABLE "items_people" ("id" serial primary key, "person_id" integer, "item_id" integer, "created_at" timestamp, "updated_at" timestamp)  +  (0.9ms) DROP TABLE "people" CASCADE +  (2.6ms) CREATE TABLE "people" ("id" serial primary key, "first_name" character varying, "last_name" character varying, "ssn" character varying, "address_id" integer)  +  (0.6ms) DROP TABLE "people2" CASCADE +  (2.1ms) CREATE TABLE "people2" ("id" serial primary key, "first_name" character varying, "last_name" character varying, "ssn" character varying, "created_at" timestamp, "updated_at" timestamp)  +  (0.6ms) DROP TABLE "places" CASCADE +  (3.0ms) CREATE TABLE "places" ("id" serial primary key, "address" text, "city" character varying, "cstate" character varying, "country" character varying, "created_at" timestamp, "updated_at" timestamp)  +  (0.5ms) SELECT version FROM "schema_migrations" +  (0.3ms) drop view if exists V_PEOPLE +  (0.2ms) drop view if exists V_PROFILE +  (2.1ms) ROLLBACK +  (0.2ms) BEGIN +---------------------------- +SchemaDumperTest: test_union +---------------------------- +  (0.3ms) drop view if exists V_PEOPLE +  (0.2ms) drop view if exists V_PROFILE +  (0.4ms) SAVEPOINT active_record_1 + SQL (0.7ms) INSERT INTO "people" ("first_name", "last_name", "ssn") VALUES ($1, $2, $3) RETURNING "id" [["first_name", "Joe"], ["last_name", "User"], ["ssn", "123456789"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.4ms) INSERT INTO "people2" ("first_name", "last_name", "ssn", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["first_name", "Jane"], ["last_name", "Doe"], ["ssn", "222334444"], ["created_at", "2015-01-12 10:42:10.917253"], ["updated_at", "2015-01-12 10:42:10.917253"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.9ms) CREATE VIEW "v_profile" ("first_name", "last_name", "ssn") AS select first_name, last_name, ssn from people + UNION + select first_name, last_name, ssn from people2 + + ActiveRecord::SchemaMigration Load (0.4ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.9ms)  SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type = 'BASE TABLE' + +  (0.7ms) SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type = 'VIEW' + +  (0.7ms)  SELECT view_definition + FROM information_schema.views + WHERE table_catalog = (SELECT catalog_name FROM information_schema.information_schema_catalog_name) + AND table_schema IN ('"$user"','public') + AND table_name = 'v_profile' + + SQL (0.3ms) CREATE EXTENSION IF NOT EXISTS "plpgsql" +  (0.6ms) DROP TABLE "items" CASCADE +  (1.5ms) CREATE TABLE "items" ("id" serial primary key, "person_id" integer, "created_at" timestamp, "updated_at" timestamp) +  (0.5ms) DROP TABLE "items_people" CASCADE +  (1.4ms) CREATE TABLE "items_people" ("id" serial primary key, "person_id" integer, "item_id" integer, "created_at" timestamp, "updated_at" timestamp) +  (0.9ms) DROP TABLE "people" CASCADE +  (3.7ms) CREATE TABLE "people" ("id" serial primary key, "first_name" character varying, "last_name" character varying, "ssn" character varying, "address_id" integer) +  (0.8ms) DROP TABLE "people2" CASCADE +  (2.2ms) CREATE TABLE "people2" ("id" serial primary key, "first_name" character varying, "last_name" character varying, "ssn" character varying, "created_at" timestamp, "updated_at" timestamp) +  (0.9ms) DROP TABLE "places" CASCADE +  (2.1ms) CREATE TABLE "places" ("id" serial primary key, "address" text, "city" character varying, "cstate" character varying, "country" character varying, "created_at" timestamp, "updated_at" timestamp) +  (1.3ms) CREATE VIEW "v_profile" ("first_name", "last_name", "ssn") AS SELECT people.first_name, + people.last_name, + people.ssn + FROM people +UNION + SELECT people2.first_name, + people2.last_name, + people2.ssn + FROM people2; +  (0.3ms) SELECT version FROM "schema_migrations" +  (0.2ms) drop view if exists V_PEOPLE +  (0.4ms) drop view if exists V_PROFILE +  (3.3ms) ROLLBACK +  (0.2ms) BEGIN +--------------------------- +SchemaDumperTest: test_view +--------------------------- +  (0.3ms) drop view if exists V_PEOPLE +  (0.3ms) drop view if exists V_PROFILE +  (1.0ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people + ActiveRecord::SchemaMigration Load (0.4ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (1.0ms)  SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type = 'BASE TABLE' + +  (0.8ms) SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type = 'VIEW' + +  (0.7ms)  SELECT view_definition + FROM information_schema.views + WHERE table_catalog = (SELECT catalog_name FROM information_schema.information_schema_catalog_name) + AND table_schema IN ('"$user"','public') + AND table_name = 'v_people' + +  (0.6ms) drop view if exists V_PEOPLE +  (0.2ms) drop view if exists V_PROFILE +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +------------------------------------------ +SchemaDumperTest: test_view_creation_order +------------------------------------------ +  (0.2ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.7ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people + ActiveRecord::SchemaMigration Load (0.2ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (1.2ms) SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type = 'BASE TABLE' + +  (0.7ms)  SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type = 'VIEW' + +  (0.7ms) SELECT view_definition + FROM information_schema.views + WHERE table_catalog = (SELECT catalog_name FROM information_schema.information_schema_catalog_name) + AND table_schema IN ('"$user"','public') + AND table_name = 'v_people' + +  (0.8ms)  SELECT view_definition + FROM information_schema.views + WHERE table_catalog = (SELECT catalog_name FROM information_schema.information_schema_catalog_name) + AND table_schema IN ('"$user"','public') + AND table_name = 'v_people' + + SQL (0.3ms) CREATE EXTENSION IF NOT EXISTS "plpgsql" +  (0.6ms) DROP TABLE "items" CASCADE +  (1.6ms) CREATE TABLE "items" ("id" serial primary key, "person_id" integer, "created_at" timestamp, "updated_at" timestamp) +  (0.6ms) DROP TABLE "items_people" CASCADE +  (1.8ms) CREATE TABLE "items_people" ("id" serial primary key, "person_id" integer, "item_id" integer, "created_at" timestamp, "updated_at" timestamp) +  (0.8ms) DROP TABLE "people" CASCADE +  (3.5ms) CREATE TABLE "people" ("id" serial primary key, "first_name" character varying, "last_name" character varying, "ssn" character varying, "address_id" integer) +  (0.7ms) DROP TABLE "people2" CASCADE +  (2.3ms) CREATE TABLE "people2" ("id" serial primary key, "first_name" character varying, "last_name" character varying, "ssn" character varying, "created_at" timestamp, "updated_at" timestamp) +  (1.3ms) DROP TABLE "places" CASCADE +  (3.7ms) CREATE TABLE "places" ("id" serial primary key, "address" text, "city" character varying, "cstate" character varying, "country" character varying, "created_at" timestamp, "updated_at" timestamp) +  (0.8ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS SELECT people.id, + people.first_name AS f_name, + people.last_name AS l_name, + people.ssn AS social_security, + people.address_id + FROM people; +  (0.4ms) DROP VIEW "v_people" +  (0.6ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS SELECT people.id, + people.first_name AS f_name, + people.last_name AS l_name, + people.ssn AS social_security, + people.address_id + FROM people; +  (0.4ms) SELECT version FROM "schema_migrations" +  (0.5ms) drop view if exists V_PEOPLE +  (0.2ms) drop view if exists V_PROFILE +  (2.1ms) ROLLBACK +  (0.2ms) BEGIN +-------------------------------------------------------- +ViewModelTest: test_access_cloned_belongs_to_association +-------------------------------------------------------- +  (0.8ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.4ms) SAVEPOINT active_record_1 + SQL (0.6ms) INSERT INTO "places" ("created_at", "updated_at") VALUES ($1, $2) RETURNING "id" [["created_at", "2015-01-12 10:42:11.280688"], ["updated_at", "2015-01-12 10:42:11.280688"]] +  (0.4ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.4ms) INSERT INTO "people" ("first_name", "address_id") VALUES ($1, $2) RETURNING "id" [["first_name", "Primus"], ["address_id", 1]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.6ms) INSERT INTO "items" ("person_id", "created_at", "updated_at") VALUES ($1, $2, $3) RETURNING "id" [["person_id", 12], ["created_at", "2015-01-12 10:42:11.339139"], ["updated_at", "2015-01-12 10:42:11.339139"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "items" ("person_id", "created_at", "updated_at") VALUES ($1, $2, $3) RETURNING "id" [["person_id", 12], ["created_at", "2015-01-12 10:42:11.352711"], ["updated_at", "2015-01-12 10:42:11.352711"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.2ms) INSERT INTO "items" ("created_at", "updated_at") VALUES ($1, $2) RETURNING "id" [["created_at", "2015-01-12 10:42:11.359863"], ["updated_at", "2015-01-12 10:42:11.359863"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.2ms) INSERT INTO "items" ("created_at", "updated_at") VALUES ($1, $2) RETURNING "id" [["created_at", "2015-01-12 10:42:11.366814"], ["updated_at", "2015-01-12 10:42:11.366814"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "items" ("created_at", "updated_at") VALUES ($1, $2) RETURNING "id" [["created_at", "2015-01-12 10:42:11.373017"], ["updated_at", "2015-01-12 10:42:11.373017"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.6ms) INSERT INTO "items_people" ("person_id", "item_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["person_id", 12], ["item_id", 3], ["created_at", "2015-01-12 10:42:11.402621"], ["updated_at", "2015-01-12 10:42:11.402621"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "items_people" ("person_id", "item_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["person_id", 12], ["item_id", 5], ["created_at", "2015-01-12 10:42:11.415887"], ["updated_at", "2015-01-12 10:42:11.415887"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +------------------------------------------------------ +ViewModelTest: test_access_cloned_has_many_association +------------------------------------------------------ +  (0.7ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.4ms) INSERT INTO "places" ("created_at", "updated_at") VALUES ($1, $2) RETURNING "id" [["created_at", "2015-01-12 10:42:11.449764"], ["updated_at", "2015-01-12 10:42:11.449764"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "people" ("first_name", "address_id") VALUES ($1, $2) RETURNING "id" [["first_name", "Primus"], ["address_id", 2]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.6ms) INSERT INTO "items" ("person_id", "created_at", "updated_at") VALUES ($1, $2, $3) RETURNING "id" [["person_id", 13], ["created_at", "2015-01-12 10:42:11.474353"], ["updated_at", "2015-01-12 10:42:11.474353"]] +  (0.4ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "items" ("person_id", "created_at", "updated_at") VALUES ($1, $2, $3) RETURNING "id" [["person_id", 13], ["created_at", "2015-01-12 10:42:11.488502"], ["updated_at", "2015-01-12 10:42:11.488502"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.2ms) INSERT INTO "items" ("created_at", "updated_at") VALUES ($1, $2) RETURNING "id" [["created_at", "2015-01-12 10:42:11.496881"], ["updated_at", "2015-01-12 10:42:11.496881"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.2ms) INSERT INTO "items" ("created_at", "updated_at") VALUES ($1, $2) RETURNING "id" [["created_at", "2015-01-12 10:42:11.504797"], ["updated_at", "2015-01-12 10:42:11.504797"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "items" ("created_at", "updated_at") VALUES ($1, $2) RETURNING "id" [["created_at", "2015-01-12 10:42:11.513317"], ["updated_at", "2015-01-12 10:42:11.513317"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.5ms) INSERT INTO "items_people" ("person_id", "item_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["person_id", 13], ["item_id", 8], ["created_at", "2015-01-12 10:42:11.531264"], ["updated_at", "2015-01-12 10:42:11.531264"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "items_people" ("person_id", "item_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["person_id", 13], ["item_id", 10], ["created_at", "2015-01-12 10:42:11.548963"], ["updated_at", "2015-01-12 10:42:11.548963"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +-------------------------------------------------------- +ViewModelTest: test_cloned_belongs_to_association_exists +-------------------------------------------------------- +  (0.8ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "places" ("created_at", "updated_at") VALUES ($1, $2) RETURNING "id" [["created_at", "2015-01-12 10:42:11.574063"], ["updated_at", "2015-01-12 10:42:11.574063"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "people" ("first_name", "address_id") VALUES ($1, $2) RETURNING "id" [["first_name", "Primus"], ["address_id", 3]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.4ms) INSERT INTO "items" ("person_id", "created_at", "updated_at") VALUES ($1, $2, $3) RETURNING "id" [["person_id", 14], ["created_at", "2015-01-12 10:42:11.603929"], ["updated_at", "2015-01-12 10:42:11.603929"]] +  (0.3ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "items" ("person_id", "created_at", "updated_at") VALUES ($1, $2, $3) RETURNING "id" [["person_id", 14], ["created_at", "2015-01-12 10:42:11.619299"], ["updated_at", "2015-01-12 10:42:11.619299"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.2ms) INSERT INTO "items" ("created_at", "updated_at") VALUES ($1, $2) RETURNING "id" [["created_at", "2015-01-12 10:42:11.627367"], ["updated_at", "2015-01-12 10:42:11.627367"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.2ms) INSERT INTO "items" ("created_at", "updated_at") VALUES ($1, $2) RETURNING "id" [["created_at", "2015-01-12 10:42:11.634435"], ["updated_at", "2015-01-12 10:42:11.634435"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.2ms) INSERT INTO "items" ("created_at", "updated_at") VALUES ($1, $2) RETURNING "id" [["created_at", "2015-01-12 10:42:11.642652"], ["updated_at", "2015-01-12 10:42:11.642652"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.4ms) INSERT INTO "items_people" ("person_id", "item_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["person_id", 14], ["item_id", 13], ["created_at", "2015-01-12 10:42:11.660672"], ["updated_at", "2015-01-12 10:42:11.660672"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "items_people" ("person_id", "item_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["person_id", 14], ["item_id", 15], ["created_at", "2015-01-12 10:42:11.677236"], ["updated_at", "2015-01-12 10:42:11.677236"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.3ms) ROLLBACK +  (0.2ms) BEGIN +--------------------------------------------------- +ViewModelTest: test_cloned_habtm_association_exists +--------------------------------------------------- +  (0.7ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "places" ("created_at", "updated_at") VALUES ($1, $2) RETURNING "id" [["created_at", "2015-01-12 10:42:11.705260"], ["updated_at", "2015-01-12 10:42:11.705260"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "people" ("first_name", "address_id") VALUES ($1, $2) RETURNING "id" [["first_name", "Primus"], ["address_id", 4]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.4ms) INSERT INTO "items" ("person_id", "created_at", "updated_at") VALUES ($1, $2, $3) RETURNING "id" [["person_id", 15], ["created_at", "2015-01-12 10:42:11.727318"], ["updated_at", "2015-01-12 10:42:11.727318"]] +  (0.3ms) RELEASE SAVEPOINT active_record_1 +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.5ms) INSERT INTO "items" ("person_id", "created_at", "updated_at") VALUES ($1, $2, $3) RETURNING "id" [["person_id", 15], ["created_at", "2015-01-12 10:42:11.739353"], ["updated_at", "2015-01-12 10:42:11.739353"]] +  (0.4ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.2ms) INSERT INTO "items" ("created_at", "updated_at") VALUES ($1, $2) RETURNING "id" [["created_at", "2015-01-12 10:42:11.749108"], ["updated_at", "2015-01-12 10:42:11.749108"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.2ms) INSERT INTO "items" ("created_at", "updated_at") VALUES ($1, $2) RETURNING "id" [["created_at", "2015-01-12 10:42:11.756311"], ["updated_at", "2015-01-12 10:42:11.756311"]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.2ms) INSERT INTO "items" ("created_at", "updated_at") VALUES ($1, $2) RETURNING "id" [["created_at", "2015-01-12 10:42:11.763197"], ["updated_at", "2015-01-12 10:42:11.763197"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "items_people" ("person_id", "item_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["person_id", 15], ["item_id", 18], ["created_at", "2015-01-12 10:42:11.776035"], ["updated_at", "2015-01-12 10:42:11.776035"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "items_people" ("person_id", "item_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["person_id", 15], ["item_id", 20], ["created_at", "2015-01-12 10:42:11.787878"], ["updated_at", "2015-01-12 10:42:11.787878"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) ROLLBACK +  (0.3ms) BEGIN +------------------------------------------------------ +ViewModelTest: test_cloned_has_many_association_exists +------------------------------------------------------ +  (0.8ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "places" ("created_at", "updated_at") VALUES ($1, $2) RETURNING "id" [["created_at", "2015-01-12 10:42:11.819717"], ["updated_at", "2015-01-12 10:42:11.819717"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.2ms) INSERT INTO "people" ("first_name", "address_id") VALUES ($1, $2) RETURNING "id" [["first_name", "Primus"], ["address_id", 5]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "items" ("person_id", "created_at", "updated_at") VALUES ($1, $2, $3) RETURNING "id" [["person_id", 16], ["created_at", "2015-01-12 10:42:11.843063"], ["updated_at", "2015-01-12 10:42:11.843063"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "items" ("person_id", "created_at", "updated_at") VALUES ($1, $2, $3) RETURNING "id" [["person_id", 16], ["created_at", "2015-01-12 10:42:11.856131"], ["updated_at", "2015-01-12 10:42:11.856131"]] +  (0.3ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.2ms) INSERT INTO "items" ("created_at", "updated_at") VALUES ($1, $2) RETURNING "id" [["created_at", "2015-01-12 10:42:11.867540"], ["updated_at", "2015-01-12 10:42:11.867540"]] +  (0.4ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "items" ("created_at", "updated_at") VALUES ($1, $2) RETURNING "id" [["created_at", "2015-01-12 10:42:11.875687"], ["updated_at", "2015-01-12 10:42:11.875687"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.2ms) INSERT INTO "items" ("created_at", "updated_at") VALUES ($1, $2) RETURNING "id" [["created_at", "2015-01-12 10:42:11.882716"], ["updated_at", "2015-01-12 10:42:11.882716"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "items_people" ("person_id", "item_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["person_id", 16], ["item_id", 23], ["created_at", "2015-01-12 10:42:11.897496"], ["updated_at", "2015-01-12 10:42:11.897496"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "items_people" ("person_id", "item_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["person_id", 16], ["item_id", 25], ["created_at", "2015-01-12 10:42:11.911689"], ["updated_at", "2015-01-12 10:42:11.911689"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) ROLLBACK +  (0.2ms) BEGIN +------------------------------- +ViewModelTest: test_same_person +------------------------------- +  (0.7ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "places" ("created_at", "updated_at") VALUES ($1, $2) RETURNING "id" [["created_at", "2015-01-12 10:42:11.936246"], ["updated_at", "2015-01-12 10:42:11.936246"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.2ms) INSERT INTO "people" ("first_name", "address_id") VALUES ($1, $2) RETURNING "id" [["first_name", "Primus"], ["address_id", 6]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.4ms) INSERT INTO "items" ("person_id", "created_at", "updated_at") VALUES ($1, $2, $3) RETURNING "id" [["person_id", 17], ["created_at", "2015-01-12 10:42:11.961677"], ["updated_at", "2015-01-12 10:42:11.961677"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.5ms) INSERT INTO "items" ("person_id", "created_at", "updated_at") VALUES ($1, $2, $3) RETURNING "id" [["person_id", 17], ["created_at", "2015-01-12 10:42:11.977380"], ["updated_at", "2015-01-12 10:42:11.977380"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "items" ("created_at", "updated_at") VALUES ($1, $2) RETURNING "id" [["created_at", "2015-01-12 10:42:11.986741"], ["updated_at", "2015-01-12 10:42:11.986741"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.3ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "items" ("created_at", "updated_at") VALUES ($1, $2) RETURNING "id" [["created_at", "2015-01-12 10:42:11.997982"], ["updated_at", "2015-01-12 10:42:11.997982"]] +  (0.3ms) RELEASE SAVEPOINT active_record_1 +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "items" ("created_at", "updated_at") VALUES ($1, $2) RETURNING "id" [["created_at", "2015-01-12 10:42:12.008170"], ["updated_at", "2015-01-12 10:42:12.008170"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "items_people" ("person_id", "item_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["person_id", 17], ["item_id", 28], ["created_at", "2015-01-12 10:42:12.023537"], ["updated_at", "2015-01-12 10:42:12.023537"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "items_people" ("person_id", "item_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["person_id", 17], ["item_id", 30], ["created_at", "2015-01-12 10:42:12.041524"], ["updated_at", "2015-01-12 10:42:12.041524"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) ROLLBACK + ActiveRecord::SchemaMigration Load (0.4ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.2ms) BEGIN +-------------------------------------------------------- +ViewModelTest: test_access_cloned_belongs_to_association +-------------------------------------------------------- +  (2.7ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people +  (1.9ms) SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type IN ('BASE TABLE', 'VIEW') + +  (0.3ms) SAVEPOINT active_record_1 + SQL (0.4ms) INSERT INTO "places" ("created_at", "updated_at") VALUES ($1, $2) RETURNING "id" [["created_at", "2015-01-12 10:45:11.198848"], ["updated_at", "2015-01-12 10:45:11.198848"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.3ms) SAVEPOINT active_record_1 + SQL (0.4ms) INSERT INTO "people" ("first_name", "address_id") VALUES ($1, $2) RETURNING "id" [["first_name", "Primus"], ["address_id", 7]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.3ms) SAVEPOINT active_record_1 + SQL (0.4ms) INSERT INTO "items" ("person_id", "created_at", "updated_at") VALUES ($1, $2, $3) RETURNING "id" [["person_id", 18], ["created_at", "2015-01-12 10:45:35.477950"], ["updated_at", "2015-01-12 10:45:35.477950"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "items" ("person_id", "created_at", "updated_at") VALUES ($1, $2, $3) RETURNING "id" [["person_id", 18], ["created_at", "2015-01-12 10:45:35.487816"], ["updated_at", "2015-01-12 10:45:35.487816"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.4ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "items" ("created_at", "updated_at") VALUES ($1, $2) RETURNING "id" [["created_at", "2015-01-12 10:45:38.551980"], ["updated_at", "2015-01-12 10:45:38.551980"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.4ms) INSERT INTO "items" ("created_at", "updated_at") VALUES ($1, $2) RETURNING "id" [["created_at", "2015-01-12 10:45:38.561814"], ["updated_at", "2015-01-12 10:45:38.561814"]] +  (0.3ms) RELEASE SAVEPOINT active_record_1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "items" ("created_at", "updated_at") VALUES ($1, $2) RETURNING "id" [["created_at", "2015-01-12 10:45:38.572530"], ["updated_at", "2015-01-12 10:45:38.572530"]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 +  (0.3ms) SAVEPOINT active_record_1 + SQL (0.6ms) INSERT INTO "items_people" ("person_id", "item_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["person_id", 18], ["item_id", 33], ["created_at", "2015-01-12 10:45:39.990895"], ["updated_at", "2015-01-12 10:45:39.990895"]] +  (0.3ms) RELEASE SAVEPOINT active_record_1 +  (0.4ms) SAVEPOINT active_record_1 + SQL (0.4ms) INSERT INTO "items_people" ("person_id", "item_id", "created_at", "updated_at") VALUES ($1, $2, $3, $4) RETURNING "id" [["person_id", 18], ["item_id", 35], ["created_at", "2015-01-12 10:45:42.609092"], ["updated_at", "2015-01-12 10:45:42.609092"]] +  (0.3ms) RELEASE SAVEPOINT active_record_1 + VPerson Load (0.5ms) SELECT "v_people".* FROM "v_people" + Person Load (0.4ms) SELECT "people".* FROM "people" + Person Load (0.3ms) SELECT "people".* FROM "people" WHERE "people"."id" = $1 LIMIT 1 [["id", 18]] + VPerson Load (0.4ms) SELECT "v_people".* FROM "v_people" + Person Load (0.9ms) SELECT "people".* FROM "people" ORDER BY "people"."id" ASC LIMIT 1 + Person Load (0.5ms) SELECT "people".* FROM "people" ORDER BY "people"."id" ASC LIMIT 1 +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.5ms) UPDATE "people" SET "last_name" = $1 WHERE "people"."id" = $2 [["last_name", "laurent"], ["id", 18]] +  (0.2ms) RELEASE SAVEPOINT active_record_1 + VPerson Load (0.4ms) SELECT "v_people".* FROM "v_people" + ActiveRecord::SchemaMigration Load (0.4ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.2ms) BEGIN +-------------------------------------- +RailsSqlViews4Test: test_test_the_true +-------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------ +RailsSqlViews4Test: test_truth +------------------------------ +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------ +SchemaDumperTest: test_dump_and_load +------------------------------------ +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +----------------------------------- +SchemaDumperTest: test_regex_ignore +----------------------------------- +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------ +SchemaDumperTest: test_symbol_ignore +------------------------------------ +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------- +SchemaDumperTest: test_union +---------------------------- +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (2.8ms)  SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type IN ('BASE TABLE', 'VIEW') + +  (0.2ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "people" ("first_name", "last_name", "ssn") VALUES ($1, $2, $3) RETURNING "id" [["first_name", "Joe"], ["last_name", "User"], ["ssn", "123456789"]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "people2" ("first_name", "last_name", "ssn", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id" [["first_name", "Jane"], ["last_name", "Doe"], ["ssn", "222334444"], ["created_at", "2015-01-12 10:59:00.434782"], ["updated_at", "2015-01-12 10:59:00.434782"]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------- +SchemaDumperTest: test_view +--------------------------- +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------------ +SchemaDumperTest: test_view_creation_order +------------------------------------------ +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------ +ViewOperationsTest: test_create_view +------------------------------------ +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.2ms) INSERT INTO "people" ("first_name", "last_name", "ssn") VALUES ($1, $2, $3) RETURNING "id" [["first_name", "John"], ["last_name", "Doe"], ["ssn", "123456789"]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------------- +ViewOperationsTest: test_drop_view +---------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------- +ViewOperationsTest: test_no_view_raises_error +--------------------------------------------- +  (1.2ms)  SELECT view_definition + FROM information_schema.views + WHERE table_catalog = (SELECT catalog_name FROM information_schema.information_schema_catalog_name) + AND table_schema IN ('"$user"','public') + AND table_name = 'foo' + +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +----------------------------- +AdapterTest: test_base_tables +----------------------------- +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +------------------------- +AdapterTest: test_columns +------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +---------------------------------- +AdapterTest: test_current_database +---------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_mapped_columns +-------------------------------- +  (1.9ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.4ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------ +AdapterTest: test_mapped_views +------------------------------ +  (0.8ms) CREATE VIEW v_people ("f_name", "l_name", "address_id") AS SELECT "first_name", "last_name", "address_id" FROM people +  (0.8ms) SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type = 'VIEW' + +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------- +AdapterTest: test_old_name_not_found_error_during_mapping +--------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +--------------------------------------------------------------------------------- +AdapterTest: test_only_base_table_triggers_are_dropped_for_disabled_ref_integrity +--------------------------------------------------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +-------------------------------- +AdapterTest: test_supports_views +-------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------ +AdapterTest: test_tables +------------------------ +  (0.5ms) ROLLBACK +  (0.2ms) BEGIN +--------------------------------------- +AdapterTest: test_view_select_statement +--------------------------------------- +  (0.8ms)  SELECT view_definition + FROM information_schema.views + WHERE table_catalog = (SELECT catalog_name FROM information_schema.information_schema_catalog_name) + AND table_schema IN ('"$user"','public') + AND table_name = 'v_people' + +  (0.4ms) ROLLBACK +  (0.3ms) BEGIN +----------------------- +AdapterTest: test_views +----------------------- +  (0.3ms) ROLLBACK +  (0.2ms) BEGIN +-------------------------------------------------------- +ViewModelTest: test_access_cloned_belongs_to_association +-------------------------------------------------------- +  (0.5ms) ROLLBACK +  (0.2ms) BEGIN +------------------------------------------------------ +ViewModelTest: test_access_cloned_has_many_association +------------------------------------------------------ +  (0.4ms) ROLLBACK +  (0.2ms) BEGIN +-------------------------------------------------------- +ViewModelTest: test_cloned_belongs_to_association_exists +-------------------------------------------------------- +  (0.4ms) ROLLBACK +  (0.3ms) BEGIN +--------------------------------------------------- +ViewModelTest: test_cloned_habtm_association_exists +--------------------------------------------------- +  (0.3ms) ROLLBACK +  (0.2ms) BEGIN +------------------------------------------------------ +ViewModelTest: test_cloned_has_many_association_exists +------------------------------------------------------ +  (0.2ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------- +ViewModelTest: test_same_person +------------------------------- +  (0.2ms) ROLLBACK + ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.2ms) BEGIN +------------------------------------ +ViewOperationsTest: test_create_view +------------------------------------ +  (2.0ms)  SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type IN ('BASE TABLE', 'VIEW') + +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.3ms) INSERT INTO "people" ("first_name", "last_name", "ssn") VALUES ($1, $2, $3) RETURNING "id" [["first_name", "John"], ["last_name", "Doe"], ["ssn", "123456789"]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +  (2.7ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security") AS select id, first_name, last_name, ssn from people + Person Load (0.8ms) SELECT "people".* FROM "people" ORDER BY "people"."id" ASC LIMIT 1 + Person Load (0.4ms) SELECT "people".* FROM "people" ORDER BY "people"."id" ASC LIMIT 1 + VPerson Load (0.3ms) SELECT "v_people".* FROM "v_people" LIMIT 1 + ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.2ms) BEGIN +------------------------------------ +SchemaDumperTest: test_dump_and_load +------------------------------------ +  (0.2ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (2.9ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people + ActiveRecord::SchemaMigration Load (0.4ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (2.6ms)  SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type = 'BASE TABLE' + +  (0.7ms) SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type = 'VIEW' + +  (1.4ms)  SELECT view_definition + FROM information_schema.views + WHERE table_catalog = (SELECT catalog_name FROM information_schema.information_schema_catalog_name) + AND table_schema IN ('"$user"','public') + AND table_name = 'v_people' + + SQL (0.3ms) CREATE EXTENSION IF NOT EXISTS "plpgsql" +  (0.9ms) DROP TABLE "items" CASCADE +  (2.1ms) CREATE TABLE "items" ("id" serial primary key, "person_id" integer, "created_at" timestamp, "updated_at" timestamp) +  (0.6ms) DROP TABLE "items_people" CASCADE +  (1.5ms) CREATE TABLE "items_people" ("id" serial primary key, "person_id" integer, "item_id" integer, "created_at" timestamp, "updated_at" timestamp) +  (1.0ms) DROP TABLE "people" CASCADE +  (2.4ms) CREATE TABLE "people" ("id" serial primary key, "first_name" character varying, "last_name" character varying, "ssn" character varying, "address_id" integer) +  (1.1ms) DROP TABLE "people2" CASCADE +  (2.5ms) CREATE TABLE "people2" ("id" serial primary key, "first_name" character varying, "last_name" character varying, "ssn" character varying, "created_at" timestamp, "updated_at" timestamp) +  (0.7ms) DROP TABLE "places" CASCADE +  (2.9ms) CREATE TABLE "places" ("id" serial primary key, "address" text, "city" character varying, "cstate" character varying, "country" character varying, "created_at" timestamp, "updated_at" timestamp) + ActiveRecord::SchemaMigration Load (0.6ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.2ms) BEGIN +----------------------------- +AdapterTest: test_base_tables +----------------------------- +  (3.7ms) CREATE VIEW "v_people" ("f_name", "l_name", "social_security") AS select first_name, last_name, ssn from people +  (3.8ms) SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type = 'BASE TABLE' + + ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.2ms) BEGIN +------------------------------------ +ViewOperationsTest: test_create_view +------------------------------------ +  (1.9ms)  SELECT table_name, table_type + FROM information_schema.tables + WHERE table_schema IN ('"$user"','public') + AND table_type IN ('BASE TABLE', 'VIEW') + +  (0.1ms) SAVEPOINT active_record_1 + SQL (0.4ms) INSERT INTO "people" ("first_name", "last_name", "ssn") VALUES ($1, $2, $3) RETURNING "id" [["first_name", "John"], ["last_name", "Doe"], ["ssn", "123456789"]] +  (0.1ms) RELEASE SAVEPOINT active_record_1 +  (2.5ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security") AS select id, first_name, last_name, ssn from people + ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.2ms) BEGIN +------------------------------------ +SchemaDumperTest: test_dump_and_load +------------------------------------ +  (0.2ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE +  (5707.8ms) CREATE VIEW "v_people" ("id", "f_name", "l_name", "social_security", "address_id") AS select id, first_name, last_name, ssn, address_id from people + ActiveRecord::SchemaMigration Load (0.3ms) SELECT "schema_migrations".* FROM "schema_migrations" +  (0.2ms) BEGIN +-------------------------------------- +RailsSqlViews4Test: test_test_the_true +-------------------------------------- +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------ +RailsSqlViews4Test: test_truth +------------------------------ +  (0.1ms) ROLLBACK +  (0.1ms) BEGIN +------------------------------------ +SchemaDumperTest: test_dump_and_load +------------------------------------ +  (0.1ms) drop view if exists V_PEOPLE +  (0.1ms) drop view if exists V_PROFILE