Inheritance problem when restoring db

From: "Sebastjan Trepca" <trepca(at)gmail(dot)com>
To: "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: Inheritance problem when restoring db
Date: 2007-10-01 16:00:24
Message-ID: cd329af80710010900p2854a69dvb12721a921bbf1c8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-10-01 16:14:37 Re: Inheritance problem when restoring db
Previous Message Alban Hertroys 2007-10-01 15:31:21 Re: Normalized Tables & SELECT [was: Find "smallest common year"]