| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Jim Mercer <jim(at)reptiles(dot)org> |
| Cc: | Charles Martin <martin_pgsql(at)yahoo(dot)com>, pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: [GENERAL] please help me recover from duplicate key in unique index |
| Date: | 2000-01-05 00:22:40 |
| Message-ID: | 200001050022.TAA01087@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> On Tue, Jan 04, 2000 at 06:47:39PM -0500, Bruce Momjian wrote:
> > Try:
> >
> > SELECT oid, *
> > FROM table
> > GROUP BY oid
> > HAVING count(*) > 1
> >
> > that should show your duplicates, and you can remove them using
> > table.oid = _bad_number_.
>
> ah, i thought each row had a unique oid, and thus, that query wouldn't show the
> duplicate content.
>
Oh, I thought they were using oid's for keys. I see now. Yes, you are
correct.
--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ed Loehr | 2000-01-05 01:21:24 | Re: [GENERAL] please help me recover from duplicate key in unique index |
| Previous Message | Jim Mercer | 2000-01-05 00:21:28 | Re: [GENERAL] please help me recover from duplicate key in unique index |