From: Kaloyan Iliev <news1@faith.digsys.bg>
To: TJ O'Donnell <tjo@acm.org>
To: pgsql-sql@postgresql.org
Subject: Re: unique rows
Date: Thu, 21 Sep 2006 10:33:57 +0300
Message-ID: <45124065.2030406@faith.digsys.bg> (raw)
In-Reply-To: <4512208C.9050607@acm.org>
References: <4512208C.9050607@acm.org>
HI,
1. You can try to create a trigger before insert to check if the new row
exists in the table and if it does to cancel the insert.
2. Or create a UNIQUE INDEX on all the columns which will throw error if
you try to insert duplicate rows in the table.
Then in the apllication software just catch the error and move on with
the next insert.
I hope I helped.
Regards,
Kaloyan Iliev
TJ O'Donnell wrote:
> I want to make a table that has unique rows - no problem.
> Create Table x (smarts Varchar Unique);
>
> I have input data that has many duplicates and until now
> I was creating a temp table allowing duplicates, and then
> Insert into x (smarts) select distinct smarts from tmpx;
> This is now failing when I have hundreds of millions of
> rows, running out of temp space (while trying to sort to
> accomplish the distinct?)
>
> So, is there a way (a constraint, a check?) that will simply
> REJECT a duplicate when I insert the raw data directly into x
> rather than FAILING on an error as it does
> with the unique constraint above?
>
> Thanks,
> TJ O'Donnell
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: news1@faith.digsys.bg, tjo@acm.org
Subject: Re: unique rows
In-Reply-To: <45124065.2030406@faith.digsys.bg>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox