Re: [HACKERS] pg_restore failed for foreign key constraint

2017-07-17 Thread Tom Lane
Neha Sharma writes: > I am getting the below error while restoring data having foreign key > constraint. > [edb@localhost bin]$ ./createdb test1 > [edb@localhost bin]$ ./pg_restore -d test1 -c -e a.dump > pg_restore: [archiver (db)] Error while PROCESSING TOC: > pg_restore: [archiver (db)] Error

[HACKERS] pg_restore failed for foreign key constraint

2017-07-17 Thread Neha Sharma
Hi, I am getting the below error while restoring data having foreign key constraint. ./psql postgres psql (10beta2) Type "help" for help. postgres=# create user test; CREATE ROLE postgres=# create schema test; CREATE SCHEMA postgres=# grant all on SCHEMA test to test; GRANT postgres=# set search