Postgres Partition Table Trigger inserting duplicate records
You can (pick one)


Create a view and build on it the trigger  with INSTEAD OF. Then you mae insert on the view, not on the table (you can have a trigger on the table raising an error if you want to be sure).
Do not make direct insert. Call a stored procedure and move logic there


More on trigger and where they can be applied here: http://www.postgresql.org/docs/9.3/static/sql-createtrigger.html