Re: BUG #6461: "-t" deletes primary key

From: Boszormenyi Zoltan <zb(at)cybertec(dot)at>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, lenka(dot)piyush(at)gmail(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6461: "-t" deletes primary key
Date: 2012-02-19 11:25:06
Message-ID: 4F40DC12.5050300@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

2012-02-19 09:30 keltezéssel, Peter Eisentraut írta:
> On fre, 2012-02-17 at 12:01 -0500, Tom Lane wrote:
>> lenka(dot)piyush(at)gmail(dot)com writes:
>>> when i restore a particular table using pg_restore (using option "-t") it
>>> doesn't restore my primary key...
>> This is not a bug. -t selects the table only, not associated indexes.

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

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

--
----------------------------------
Zoltán Böszörményi
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26
A-2700 Wiener Neustadt, Austria
Web: http://www.postgresql-support.de
http://www.postgresql.at/

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2012-02-19 16:50:15 Re: BUG #6461: "-t" deletes primary key
Previous Message Peter Eisentraut 2012-02-19 08:30:32 Re: BUG #6461: "-t" deletes primary key