Results 1 to 2 of 2
  1. #1
    Join Date
    May 2010
    Posts
    1

    Unanswered: No primary keys on tables after restoring

    Hi all,

    I had a dump (I don't know the method used to create it).
    I used pg_restore, and after restoring, no table has primary key (the original tables certainly have primary keys).
    What might be the problem: the usage of pg_restore or the dump itself?

    Thank you.

  2. #2
    Join Date
    Nov 2006
    Posts
    82
    If there was used -t option while getting pg_dump the primary keys may be not backuped. See here
    pg_restore -t table : can silently omit constraints

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •