Re: managing primary key conflicts while restoring data to table withexisting data

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: managing primary key conflicts while restoring data to table withexisting data
Дата
Msg-id CAHOFxGqze037=anQVyWpN=08BtciuNnvN9eWUTyHp2CXfATdnw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: managing primary key conflicts while restoring data to table with existing data  (Rob Sargent <robjsargent@gmail.com>)
Список pgsql-general
If the data is held in common tables(bills, vouchers, etc)then the only thing I see happening is changing the PK values to an unused value. That could turn into a nightmare though. Not only that you lose the connection to the original data source. If the data can be broken out into separate tables then I could see placing them in their own schema. 

Why not have separate databases for each "restore"? They can run together on one machine still. What is the user doing with this copy of the data?

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Upgrading old server
Следующее
От: Paul Jungwirth
Дата:
Сообщение: Re: Pg_auto_failover