After restoring a database using pg_restore , cannot insert or update records in tables with primary keys

From: vikas(dot)dogra(at)tabs(dot)toshiba(dot)com (Vikas)
To: pgsql-admin(at)postgresql(dot)org
Subject: After restoring a database using pg_restore , cannot insert or update records in tables with primary keys
Date: 2003-04-23 18:15:36
Message-ID: 295585d4.0304231015.49a83e95@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

We are using Postgres Version 7.3.2
We backup and restore Postgres databases using pg_dump and pg_restore.
Though pg_restore process does not throw any exception but After using
it for restoring we are not able to insert or update records in the
tables having Primary Keys. The message we get is "The primary key is
not a btree."
When we run postgres in Debug mode then this problem does not come.

The same code of backup restore was working for postgres version 7.2.

Any ideas?

Thanks
Vikas

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Shankar K 2003-04-23 18:21:58 DB block size Vs filesystem buffer size
Previous Message Bruce Momjian 2003-04-23 18:04:42 Re: GRANT on all tables?