Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- shell% ./bin/reset_db
- +++ dirname ./bin/reset_db
- ++ cd ./bin
- ++ cd ..
- ++ pwd
- + PARENT_DIR=/home/uni/Project/school_life/db
- + DUMPFILE=
- + psql -h 127.0.0.1 --username=postgres -c 'drop database school_life_development'
- DROP DATABASE
- + psql -h 127.0.0.1 --username=postgres -c 'create database school_life_development'
- CREATE DATABASE
- + gzip -cd
- + psql -h 127.0.0.1 --username=postgres school_life_development
- gzip: compressed data not read from a terminal. Use -f to force decompression.
- For help, type: gzip -h
- + bin/flyway migrate
- Flyway 4.2.0 by Boxfuse
- Database: jdbc:postgresql://127.0.0.1:5432/school_life_development (PostgreSQL 9.6)
- Successfully validated 102 migrations (execution time 00:00.039s)
- Creating Metadata table: "public"."schema_version"
- Current version of schema "public": << Empty Schema >>
- Migrating schema "public" to version 20171026192738 - create id generator function
- Migrating schema "public" to version 20171026192739 - create bitemporal op function
- Migrating schema "public" to version 20171026193836 - create user table
- ERROR: Migration of schema "public" to version 20171026193836 - create user table failed! Changes successfully rolled back.
- ERROR:
- Migration V20171026193836__create_user_table.sql failed
- -------------------------------------------------------
- SQL State : 3F000
- Error Code : 0
- Message : ERROR: スキーマ"bitemporal_internal"は存在しません
- Position: 8
- Location : /home/uni/Project/school_life/db/lib/flyway-4.2.0/sql/V20171026193836__create_user_table.sql (/home/uni/Project/school_life/db/lib/flyway-4.2.0/sql/V20171026193836__create_user_table.sql)
- Line : 16
- Statement : SELECT bitemporal_internal.ll_create_bitemporal_table(
- 'public',
- '_user',
- 'id BIGINT NOT NULL DEFAULT id_generator(),
- _user_id BIGINT NOT NULL DEFAULT 0,
- _source JSONB,
- name VARCHAR(256) NOT NULL',
- 'id'
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement