Thanks man; Iappreciate the data.
Stephan Szabo wrote:
>
> On Thu, 9 Jan 2003, Jack Flak wrote:
>
>> Stephan,
>>
>> That's very interesting! I didn't even know about these other "hidden"
>> fields. How many others are there?
>
> Let's see, I think the set is
> ctid, oid, xmin, cmin, xmax, cm
On Thu, 9 Jan 2003, Jack Flak wrote:
> Stephan,
>
> That's very interesting! I didn't even know about these other "hidden"
> fields. How many others are there?
Let's see, I think the set is
ctid, oid, xmin, cmin, xmax, cmax, tableoid
IIRC,
ctid is basically like a physical pointer to where t
Steve,
Thanks for the excellent suggestion!
Yes, that would have worked. I guess I did it the hard way. I wrote a
nice little perl script to locate the dups by OID and then pull the data,
re-insert it, and then delete the original dup by OID. It was smart, I
could run it as many times as ne
Stephan,
That's very interesting! I didn't even know about these other "hidden"
fields. How many others are there?
You're right about the xmin value. It's the same for all the dups. That
could have saved me a lot of work. I built a perl script to locate the
dups, pull the data, re-insert
Would this work for you (if you can muck with the comm table temporarily
without causing problems)?
--Create a table with unique values
create temporary table communique as select distinct * from comm;
--Empty the table
delete from comm;
(or truncate comm if recent enough version or drop and rec
Jack Flak <[EMAIL PROTECTED]> writes:
> So, once again, here's my question: how do I go about deleting the
> duplicate entries WITHOUT also deleting the originals?
Perhaps something like
CREATE TABLE foo AS SELECT DISTINCT * FROM original;
then delete all from original, then INSERT INT
On Sun, 5 Jan 2003, Jack Flak wrote:
> Greetings Group,
>
> I'm running 7.1.
>
> Basically, my question is this: how do I delete an exact dup without
> deleting the original?
You can use one of the other hidden fields. ctid will be unique for the
various rows, but I'm not sure of a good way to
On Sun, 5 Jan 2003, Jack Flak wrote:
> So, once again, here's my question: how do I go about deleting the
> duplicate entries WITHOUT also deleting the originals?
Maybe a dump with some awk/perl magic followed by a restore might be
the easiest way. :-(
"pg_dump -a -D" might give output that is
Greetings Group,
I'm running 7.1.
Basically, my question is this: how do I delete an exact dup without
deleting the original?
Let me explain...
I just accidentally ran a restore on my perfectly running database. When I
originally made the dump file, I had OIDs turned on. I figured they were
