Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Already on GitHub? Sign in to your account

Reworked Change `revert` Scripts Skipped #67

Closed
theory opened this Issue Jan 4, 2013 · 0 comments

Comments

Projects
None yet
1 participant
Owner

theory commented Jan 4, 2013

Example from sqitch-tutorial:

> sqitch revert -y
Reverting all changes from flipr_test
  - change_pass ................ ok
  - insert_user ................ ok
  - pgcrypto ................... ok
  - delete_flip @@v1.0.0-dev2 .. ok
  - insert_flip ................ ok
  - flips ...................... ok
  - delete_list ................ ok
  - insert_list ................ ok
  - lists ...................... ok
  - change_pass @@v1.0.0-dev1 .. ok
  - insert_user ................ ok
  - users ...................... ok
  - appschema .................. psql:revert/appschema.sql:5: ERROR:  cannot drop schema flipr because other objects depend on it
DETAIL:  function flipr.change_pass(text,text,text) depends on schema flipr
function flipr.insert_user(text,text) depends on schema flipr
HINT:  Use DROP ... CASCADE to drop the dependent objects too.
not ok
"/usr/local/pgsql/bin/psql" unexpectedly returned exit value 3

> psql -d flipr_test -c '\df flipr.*'
                                    List of functions
 Schema |    Name     | Result data type |          Argument data types          |  Type  
--------+-------------+------------------+---------------------------------------+--------
 flipr  | change_pass | boolean          | nick text, oldpass text, newpass text | normal
 flipr  | insert_user | void             | nickname text, password text          | normal
(2 rows)

@theory theory was assigned Jan 4, 2013

@theory theory closed this in 45996d2 Jan 4, 2013

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment