Ignore values on INSERT

From: Michael Klatt <mdklatt(at)ou(dot)edu>
To: pgsql-novice(at)postgresql(dot)org
Subject: Ignore values on INSERT
Date: 2002-02-11 23:18:14
Message-ID: NCBBLFLGLEIDHCJLONHNEEGKFHAA.mdklatt@ou.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

How do you instruct the database to ignore an attempted INSERT instead of
generating an error? For example, if I try to insert a missing observation
into a rainfall database it is desirable to just ignore that observation and
continue without an error.

___________________________________
Michael Klatt

University of Oklahoma
Environmental Verification and Analysis Center
710 Asp Avenue, Suite 8
Norman, OK 73069

405.447.8412
405.447.8455 FAX
http://www.evac.ou.edu/

"I'm a great motivator. Everyone says they have to work twice as hard when
I'm around."

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2002-02-11 23:55:31 Re: Convert from Mysql to Postgresql
Previous Message Josh Berkus 2002-02-11 23:13:11 Re: Convert from Mysql to Postgresql