how to process?
От | sdeel |
---|---|
Тема | how to process? |
Дата | |
Msg-id | 004401c25ba9$0a515c20$9400a8c0@om.om.cox.com обсуждение исходный текст |
Список | 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 по дате отправления: