Test triggers that has not been unit tested

[loicmathieu]

Issue description

Some triggers has not been unit tested because we don't have local dev server:

• PostgreSQL (due to SSL issue, see Split PostgreSQL unit tests into those that require SSL and those that don't #106)
• Redshift
• Rockset
• Snowflake
• Vectorwise