Re: BUG #6461: "-t" deletes primary key - Mailing list pgsql-bugs

From Boszormenyi Zoltan
Subject Re: BUG #6461: "-t" deletes primary key
Date
Msg-id 4F40DC12.5050300@cybertec.at
Whole thread Raw
In response to Re: BUG #6461: "-t" deletes primary key  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-bugs
2012-02-19 09:30 keltez=C3=A9ssel, Peter Eisentraut =C3=ADrta:
> On fre, 2012-02-17 at 12:01 -0500, Tom Lane wrote:
>> lenka.piyush@gmail.com writes:
>>> when i restore a particular table using pg_restore (using option "-t") =
it
>>> doesn't restore my primary key...=20
>> This is not a bug.  -t selects the table only, not associated indexes.

The associated sequence !=3D indexes on the same table, but yes, it's a lit=
tle annoying
sometimes.

> But from a user's perspective, that behavior seems kind of useless.
>
>


--=20
----------------------------------
Zolt=C3=A1n B=C3=B6sz=C3=B6rm=C3=A9nyi
Cybertec Sch=C3=B6nig & Sch=C3=B6nig GmbH
Gr=C3=B6hrm=C3=BChlgasse 26
A-2700 Wiener Neustadt, Austria
Web: http://www.postgresql-support.de
     http://www.postgresql.at/

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: BUG #6461: "-t" deletes primary key
Next
From: Tom Lane
Date:
Subject: Re: BUG #6461: "-t" deletes primary key