[GENERAL] Tracking down cause of duplicated oid in table.

2005-02-23 Thread Jared Carr
ique constraint "visitor_referal_code_unique_btree_idx" So now I am back to wondering if this problem originated when I think that it did (between 2005/02/22 00:00:00 and 2005/02/22 01:00:00) or if this could have been hiding under the surface for longer than that. I am suspecting a hardware

Re: [GENERAL] Getting rid of duplicate tables.

2004-01-20 Thread Jared Carr
Tom Lane wrote: Jared Carr <[EMAIL PROTECTED]> writes: Item 2 -- Length: 148 Offset: 6860 (0x1acc) Flags: USED XID: min (46034931) CMIN|XMAX: 2 CMAX|XVAC: 0 Block Id: 27 linp Index: 2 Attributes: 23 Size: 28 infomask: 0x2910 (HASOID|XMIN_COMMITTED|XMAX_INVALID|U

[GENERAL] Getting rid of duplicate tables.

2004-01-19 Thread Jared Carr
First I wish I knew how this was caused but here is our problem. Sometime in the recent past we got a duplicate table. Here is the result of a pg_dump with a pg_restore for just that table. -- -- TOC entry 59 (OID 11462032) -- Name: order_to_do; Type: TABLE; Schema: public; Owner: www -- Data Pos