Re: [BUGS] BUG #6461: "-t" deletes primary key

2012-02-19 Thread Tom Lane
Peter Eisentraut writes: > On fre, 2012-02-17 at 12:01 -0500, Tom Lane wrote: >> lenka.piy...@gmail.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 ind

Re: [BUGS] BUG #6461: "-t" deletes primary key

2012-02-19 Thread Boszormenyi Zoltan
2012-02-19 09:30 keltezéssel, Peter Eisentraut írta: > On fre, 2012-02-17 at 12:01 -0500, Tom Lane wrote: >> lenka.piy...@gmail.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 tabl

Re: [BUGS] BUG #6461: "-t" deletes primary key

2012-02-19 Thread Peter Eisentraut
On fre, 2012-02-17 at 12:01 -0500, Tom Lane wrote: > lenka.piy...@gmail.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. But from a user's per

Re: [BUGS] BUG #6461: "-t" deletes primary key

2012-02-17 Thread Tom Lane
lenka.piy...@gmail.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. regards, tom lane -- Sent via pgsql-bugs mailing list (p

[BUGS] BUG #6461: "-t" deletes primary key

2012-02-17 Thread lenka . piyush
The following bug has been logged on the website: Bug reference: 6461 Logged by: Piyush Email address: lenka.piy...@gmail.com PostgreSQL version: 9.1.2 Operating system: Windows XP Description: when i restore a particular table using pg_restore (using option "-t") it