Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Insert with possible constraint violations?



Hello.
What is the proper way of inserting stuff into a table with two fields
(A and B) with a  constraint unique(A,B) and you suspect you will get
some unique constraint violations?
Should I just do INSERT etc...  and just ignore the answer?
Or do a select first and see if it returned any record?
Or is there a way of way to write a function that do the INSERT but
catches the error and do not write anything to the log about the
violation? In that case, what would such a function look like?
To me it seems that writing error messages  to log files  is not very
efficient.
So what would you suggest me doing?



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group