DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=from:to:subject:date:user-agent:cc:references:in-reply-to
	:mime-version:content-type:content-transfer-encoding:message-id;
	b=aa2xK5b0zCq4bFrnisEB/Dh8M/erXuvxcSyuW8Qb0iNpuK+/Z+U/tA4zaLidLx/ihH
	19F3X9pAppbXT9DBlpp3CLA4h4No1NYVIJPp4mWUkRBJ5+FcWtUgm00l1wMumHzJg/F3
	RSQEHAaW4vTc1ymHhV6i1oz7A9Os1y1NJl+0I=
From: Adrian Klaver <adrian.klaver@gmail.com>
To: f vf <fvalentef@gmail.com>
Subject: Re: Get id of a tuple using exception
Date: Thu, 14 Apr 2011 07:32:08 -0700
User-Agent: KMail/1.13.5 (Linux/2.6.32-30-generic; KDE/4.4.5; i686; ; )
Cc: pgsql-sql@postgresql.org
References: <BANLkTik0fUKBcdYEnFeLczA0e6Gmt-3D=g@mail.gmail.com>
	<201104140623.55068.adrian.klaver@gmail.com>
	<BANLkTimrMfAqD6o3s3=3pToj-TWS3vu6_w@mail.gmail.com>
In-Reply-To: <BANLkTimrMfAqD6o3s3=3pToj-TWS3vu6_w@mail.gmail.com>
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="iso-8859-15"
Content-Transfer-Encoding: 7bit
Message-Id: <201104140732.09311.adrian.klaver@gmail.com>

On Thursday, April 14, 2011 6:50:57 am f vf wrote:
> No, the id is nextval( 'triples_seq'), if I do nothing, so its something
> like:
>   BEGIN
>         INSERT INTO "Triples"(id, subject, predicate, "object")
>                      VALUES (nextval( 'triples_seq'), sub_i, pred_i,
> obj_i); EXCEPTION WHEN unique_violation THEN
>               --do something.
> 
>  The unique constraint is applyied to the subject, predicate and "object"
> fields. So, if I try to insert anything that has these 3 fields equal to
> any tuple that already exists in the table I want to get the id of the
> original tuple.
> 

To your original question I am not aware of a way of returning the id of the 
offending tuple,  other than through a SELECT.
-- 
Adrian Klaver
adrian.klaver@gmail.com