I want to "create or replace" a trigger for a postgres table. However, there is not such sql expression.
I see that I can do a "DROP TRIGGER IF EXISTS" first (http://www.postgresql.org/docs/9.5/static/sql-droptrigger.html).
My question are:
Postres has transaction DDL so
BEGIN > DROP > CREATE > COMMIT is the equivalent ofCREATE OR REPLACE`
https://wiki.postgresql.org/wiki/Transactional_DDL_in_PostgreSQL:_A_Competitive_Analysis is a nice writeup of how postgre's transactional DDL compares to other systems (such as oracle)
Current postgres planned features regarding triggers (https://wiki.postgresql.org/wiki/Todo#Triggers) do not include adding the