Re: [personal] Re: Filtering duplicated row with a trigger - Mailing list pgsql-novice

From papapep
Subject Re: [personal] Re: Filtering duplicated row with a trigger
Date
Msg-id 3F81A8C4.7020008@gmx.net
Whole thread Raw
In response to Re: [personal] Re: Filtering duplicated row with a trigger  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-novice
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Bruno Wolff III wrote:
| And what do want to happen when you run accross a duplicate row?
| Do you just want to discard tuples with a duplicate primary key?

Initially I wanted to do so. But after I thought to "register" them in a
dups table.

| If you are discarding duplicates, do you care which of the duplicates
| is discarded?

That's why I said that perhaps it should be a good thing to keep them in
a duplicated-rows table, for reviewing them.

| If you want to combine data from the duplicates, do you have a precise
| description of what you want to happen?

No, I do not need to combine data from the duplicated. The entire row is
accepted or not.


Josep Sànchez
[papapep]
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE/gajE2vx52x0kyz4RAq17AJ9DNYKwJEvTHy/rc9I1hJ8AuIvDjACdEXde
4nvgabqLCdERKWIAo4v6WUI=
=7zFZ
-----END PGP SIGNATURE-----




pgsql-novice by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: [personal] Re: Filtering duplicated row with a trigger
Next
From: Josh Berkus
Date:
Subject: Re: [personal] Re: Filtering duplicated row with a trigger