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

Поиск
Список
Период
Сортировка
От vikas.dogra@tabs.toshiba.com (Vikas)
Тема After restoring a database using pg_restore , cannot insert or update records in tables with primary keys
Дата
Msg-id 295585d4.0304231015.49a83e95@posting.google.com
обсуждение исходный текст
Ответы Re: After restoring a database using pg_restore , cannot insert or update records in tables with primary keys  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: "sooraj"
Дата:
Сообщение: psql not invoking ...
Следующее
От: sivasankaran
Дата:
Сообщение: create procedure