how to process? - Mailing list pgsql-novice

From sdeel
Subject how to process?
Date
Msg-id 004401c25ba9$0a515c20$9400a8c0@om.om.cox.com
Whole thread Raw
List pgsql-novice
Hi,

I am new to sql processing.  I have a java connection to my database and
will be inserting to a table with a primary key, which will provide
uniquness to the rows in my table.  In java, I will be handling exceptions
and I am assuming postgresql would throw an SQLException if a user tried to
add a record with a key that already exists.

First, I want to know if that is a good assmption.  Second, and my real
question, should I gard against this by doing a select on the key and seeing
if it already exists?  Or should I just handle this as one of the exceptions
that might occur?

Please point me to reading if this is an area of discussion that I should
research further.

Thanks in advance.

Sam Deel
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Everybody's got to believe in something, I believe I'll have another beer...
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-



pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Reserved words and workarounds...
Next
From: J Matt Clark
Date:
Subject: ODBC type "PG_TYPE_LO_NAME"