summaryrefslogtreecommitdiff
path: root/src/test/regress/sql/triggers.sql
Commit message (Expand)AuthorAgeFilesLines
* Avoid failure when altering state of partitioned foreign-key triggers.Tom Lane2023-03-041-0/+15
* Fix tupdesc lifespan bug with AfterTriggersTableData.storeslot.Tom Lane2022-09-251-6/+39
* regress: fix test instabilityAlvaro Herrera2022-08-051-3/+3
* Fix ENABLE/DISABLE TRIGGER to handle recursion correctlyAlvaro Herrera2022-08-051-1/+10
* Add support for MERGE SQL commandAlvaro Herrera2022-03-281-0/+47
* Rearrange core regression tests to reduce cross-script dependencies.Tom Lane2022-02-081-0/+33
* Fix psql \d's query for identifying parent triggers.Tom Lane2022-01-171-0/+5
* Make new test immune to collationAlvaro Herrera2021-07-231-2/+2
* Make ALTER TRIGGER RENAME consistent for partitioned tablesAlvaro Herrera2021-07-221-0/+47
* Fix pg_dump for disabled triggers on partitioned tablesAlvaro Herrera2021-07-161-0/+5
* Preserve firing-on state when cloning row triggers to partitionsAlvaro Herrera2021-07-161-0/+32
* Fix use-after-free bug with AfterTriggersTableData.storeslotAlvaro Herrera2021-02-271-0/+65
* Remove bogus restriction from BEFORE UPDATE triggersAlvaro Herrera2021-01-281-1/+27
* Fix a few comments that referred to copy.c.Heikki Linnakangas2020-11-231-1/+1
* Provide the OR REPLACE option for CREATE TRIGGER.Tom Lane2020-11-141-0/+87
* In INSERT/UPDATE, use the table's real tuple descriptor as target.Tom Lane2020-11-081-2/+11
* Use the non-deprecated TG_TABLE_MAME in test triggerMagnus Hagander2020-11-031-2/+2
* Fix corner case for a BEFORE ROW UPDATE trigger returning OLD.Tom Lane2020-10-251-0/+18
* Fix ALTER TABLE .. ENABLE/DISABLE TRIGGER recursionAlvaro Herrera2020-10-201-0/+35
* Fix detaching partitions with cloned row triggersAlvaro Herrera2020-04-211-0/+21
* Enable BEFORE row-level triggers for partitioned tablesAlvaro Herrera2020-03-181-2/+53
* Record parents of triggersAlvaro Herrera2020-02-271-0/+10
* Fix cloning of row triggers to sub-partitionsAlvaro Herrera2020-01-021-0/+4
* Prevent possible double-free when update trigger returns old tuple.Tom Lane2019-08-151-0/+35
* Propagate trigger arguments to partitionsAlvaro Herrera2019-07-091-0/+23
* Fix plan created for inherited UPDATE/DELETE with all tables excluded.Tom Lane2019-02-221-0/+27
* Fix ALTER TRIGGER ... RENAME, broken in WITH OIDS removal.Andres Freund2019-01-211-1/+7
* Remove WITH OIDS support, change oid catalog column visibility.Andres Freund2018-11-201-23/+2
* Change PROCEDURE to FUNCTION in CREATE TRIGGER syntaxPeter Eisentraut2018-08-221-2/+2
* Add test case for EEOP_INNER_SYSVAR/EEOP_OUTER_SYSVAR executor opcodes.Heikki Linnakangas2018-07-101-0/+10
* Revert MERGE patchSimon Riggs2018-04-121-47/+0
* Don't clone internal triggers to partitionsAlvaro Herrera2018-04-031-0/+15
* MERGE SQL Command following SQL:2016Simon Riggs2018-04-031-0/+47
* Revert "Modified files for MERGE"Simon Riggs2018-04-021-47/+0
* Modified files for MERGESimon Riggs2018-04-021-0/+47
* Fix test impredictabilityAlvaro Herrera2018-03-261-0/+1
* Handle INSERT .. ON CONFLICT with partitioned tablesAlvaro Herrera2018-03-261-0/+33
* Allow FOR EACH ROW triggers on partitioned tablesAlvaro Herrera2018-03-231-12/+222
* Prevent dangling-pointer access when update trigger returns old tuple.Tom Lane2018-02-271-0/+16
* Remove unused functions in regress.c.Tom Lane2018-02-271-35/+0
* Mention trigger name in trigger testAlvaro Herrera2018-02-171-1/+1
* Make new triggers tests more robustPeter Eisentraut2018-02-071-3/+9
* Add more information_schema columnsPeter Eisentraut2018-02-071-0/+14
* Add tests for session_replication_rolePeter Eisentraut2018-01-181-0/+5
* C comment: fix "the the" mentions in C commentsBruce Momjian2018-01-111-1/+1
* Ensure that BEFORE STATEMENT triggers fire the right number of times.Tom Lane2017-09-171-0/+6
* Fix SQL-spec incompatibilities in new transition table feature.Tom Lane2017-09-161-0/+42
* Quick-hack fix for foreign key cascade vs triggers with transition tables.Tom Lane2017-09-101-0/+41
* Fix COPY's handling of transition tables with indexes.Andrew Gierth2017-07-101-0/+7
* Fix transition tables for ON CONFLICT.Andrew Gierth2017-06-281-0/+39
View Lorry Controller Status