#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2012
    Posts
    2
    Rep Power
    0

    Pg_restore error while adding constraint


    Hi,

    I tried to do pg_restore on my DB and during this operation, all the tables are created but while adding constraints to the table, I get an error and the operation stops.
    Please let me know what is the work around for this issue.

    Thanks
    Kalai.
  2. #2
  3. --
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Jul 2012
    Posts
    3,959
    Rep Power
    1014
    Hi,

    What are we supposed to make out of that description?

    I'm afraid there is no magical solution for "an error". You'll have to tell us what exactly the error message says.
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2012
    Posts
    2
    Rep Power
    0
    Hi,

    I tried to execute pg_restore command in batch file.
    While Restoring it creates all the tables but while adding constraint[IMG].bmp[/IMG] it stops further execution. it does not exit from batch file. It still inside batch file execution but not exit.
    It is happening not all the times.
    some time restoring perfectly and some time not.
    please help me.

IMN logo majestic logo threadwatch logo seochat tools logo