-- create a rule that will ignore dupe inserts
-- this is done on a table-by-table basis
CREATE OR REPLACE RULE db_table_ignore_duplicate_inserts AS
    ON INSERT TO schema.table
    WHERE EXISTS ( 
        SELECT 1
        FROM schema.table
        WHERE id = NEW.id
    ) 
    DO INSTEAD NOTHING;