summaryrefslogtreecommitdiff
path: root/src/test/regress/sql/triggers.sql
AgeCommit message (Expand)Author
2015-12-10Fix ON CONFLICT UPDATE bug breaking AFTER UPDATE triggers.Andres Freund
2015-05-08Add support for INSERT ... ON CONFLICT DO NOTHING/UPDATE.Andres Freund
2012-12-08Support automatically-updatable views.Tom Lane
2012-10-26Throw error if expiring tuple is again updated or deleted.Kevin Grittner
2012-01-25Add pg_trigger_depth() functionAlvaro Herrera
2011-08-21Fix trigger WHEN conditions when both BEFORE and AFTER triggers exist.Tom Lane
2010-11-23Remove useless whitespace at end of linesPeter Eisentraut
2010-10-10Support triggers on views.Tom Lane
2010-08-19Remove extra newlines at end and beginning of files, add missing newlinesPeter Eisentraut
2010-01-21Adjust psql to use pg_get_triggerdef(pretty=true) to remove extra ()'sItagaki Takahiro
2009-11-20Add a WHEN clause to CREATE TRIGGER, allowing a boolean expression to beTom Lane
2009-10-14Support SQL-compliant triggers on columns, ie fire only if certain columnsTom Lane
2009-10-07Fix snapshot management, take two.Alvaro Herrera
2008-11-05fix suppress_redundant_updates_trigger() where relation has Oids, per gripe f...Andrew Dunstan
2008-11-03suppress_redundant_updates_trigger function.Andrew Dunstan
2006-06-26Change the row constructor syntax (ROW(...)) so that list elements foo.*Tom Lane
2006-05-28 fix typoAndrew Dunstan
2006-05-28TG_table_name and TG_table_schema for plpgsql, plus docs and regression.Andrew Dunstan
2006-02-27Clean up CREATE FUNCTION syntax usage in contrib and elsewhere, inPeter Eisentraut
2005-08-30Add regression tests for disabling constraints.Bruce Momjian
2003-11-21COMMENT ON casts, conversions, languages, operator classes, andTom Lane
2002-11-23Update regression for new patches. Bump up catversion.Bruce Momjian
2002-11-23This patch implements FOR EACH STATEMENT triggers, per my email toBruce Momjian
2000-01-05Update format to add uniform headers on files.Thomas G. Lockhart
1999-09-29This is part #1 for of the DEFERRED CONSTRAINT TRIGGER support.Jan Wieck
1997-10-17Changes due to fixed DEFAULT behaviour.Vadim B. Mikheev
1997-09-24Timetravel tests.Vadim B. Mikheev
1997-09-11Tests for spi/triggersVadim B. Mikheev