Inheritance problem when restoring db

Поиск
Список
Период
Сортировка
От Sebastjan Trepca
Тема Inheritance problem when restoring db
Дата
Msg-id cd329af80710010900p2854a69dvb12721a921bbf1c8@mail.gmail.com
обсуждение исходный текст
Ответы Re: Inheritance problem when restoring db
Список pgsql-general
Hi,

I noticed a small bug/problem when restoring a database that uses inheritance.

Lets say you have a table B that inherits from table A.

Current state:

Table B has a primary key with sequence b_seq. Table A also has a
primary key with sequence a_seq.

Now we create a backup and restore the database.

New state:

Table B has a primary key with sequence a_seq. Table A is the same as before.

Is this wrong or normal functionality? Do I have to set some extra
flags when doing the backup?

Thanks, Sebastjan

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

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: Normalized Tables & SELECT [was: Find "smallest common year"]
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Inheritance problem when restoring db