On Mon, 2011-06-27 at 15:36 +0300, Sim Zacks wrote: > Is there a way to tell a table to discard an insert if it violates a > constraint (unique in my case) instead of giving an error? I don't want > the overhead of a trigger on each row inserted. > Without a trigger, you can't. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general