aboutsummaryrefslogtreecommitdiff
path: root/src/test/regress/sql/foreign_key.sql
Commit message (Expand)AuthorAge
* Reject system columns as elements of foreign keys.Tom Lane2023-03-31
* Fix self-referencing foreign keys with partitioned tablesAlvaro Herrera2022-10-07
* Fix typos.Amit Kapila2022-09-19
* Enforce foreign key correctly during cross-partition updatesAlvaro Herrera2022-03-20
* Allow specifying column list for foreign key ON DELETE SET actionsPeter Eisentraut2021-12-08
* Have ALTER CONSTRAINT recurse on partitioned tablesAlvaro Herrera2021-05-05
* Avoid creating duplicate cached plans for inherited FK constraints.Tom Lane2021-03-10
* Simplify FK-to-partitioned regression test queryAlvaro Herrera2020-02-20
* Fix failure to create FKs correctly in partitionsAlvaro Herrera2020-02-07
* Fix SET CONSTRAINTS .. DEFERRED on partitioned tablesAlvaro Herrera2019-11-07
* Check that partitions are not in use when dropping constraintsAlvaro Herrera2019-07-23
* Fix partitioned index attachmentAlvaro Herrera2019-04-25
* Fix failures in validateForeignKeyConstraint's slow path.Tom Lane2019-04-06
* Support foreign keys that reference partitioned tablesAlvaro Herrera2019-04-03
* Improve psql's \d display of foreign key constraintsAlvaro Herrera2019-03-26
* Un-hide most cascaded-drop details in regression test results.Tom Lane2019-03-24
* Fix optimization of foreign-key on update actionsPeter Eisentraut2019-03-18
* Include all columns in default names for foreign key constraintsPeter Eisentraut2019-03-13
* Fix droppability of constraints upon partition detachAlvaro Herrera2019-01-24
* Create action triggers when partitions are detachedAlvaro Herrera2019-01-21
* Fix creation of duplicate foreign keys on partitionsAlvaro Herrera2019-01-18
* Remove obsolete commentPeter Eisentraut2019-01-18
* Increase test coverage in RI_Initial_Check()Peter Eisentraut2019-01-16
* Increase test coverage in RI_FKey_fk_upd_check_required()Peter Eisentraut2019-01-16
* Increase test coverage in RI_FKey_pk_upd_check_required()Peter Eisentraut2019-01-16
* Add test case for ON DELETE NO ACTION/RESTRICTPeter Eisentraut2019-01-16
* Fix spelling errors and typos in commentsMagnus Hagander2018-11-02
* Correct attach/detach logic for FKs in partitionsAlvaro Herrera2018-10-12
* Improve two error messages related to foreign keys on partitioned tablesMichael Paquier2018-10-08
* Fix ALTER/TYPE on columns referenced by FKs in partitioned tablesAlvaro Herrera2018-09-14
* Foreign keys on partitioned tablesAlvaro Herrera2018-04-04
* Pass correct TupDesc to ri_NullCheck() in AssertAlvaro Herrera2018-04-03
* Check for pending trigger events on far end when dropping an FK constraint.Tom Lane2016-11-25
* Avoid testing tuple visibility without buffer lock in RI_FKey_check().Tom Lane2016-10-23
* Fix match_foreign_keys_to_quals for FKs linking to unused rtable entries.Tom Lane2016-06-29
* Fix overlooked relcache invalidation in ALTER TABLE ... ALTER CONSTRAINT.Tom Lane2015-05-03
* ALTER TABLE ... ALTER CONSTRAINT for FKsSimon Riggs2013-06-29
* Reverting previous commit, pending investigationSimon Riggs2013-06-24
* ALTER TABLE ... ALTER CONSTRAINT for FKsSimon Riggs2013-06-24
* Share RI trigger code between NO ACTION and RESTRICT cases.Tom Lane2012-06-19
* Allow ON UPDATE/DELETE SET DEFAULT plans to be cached.Tom Lane2012-06-18
* Change ON UPDATE SET NULL/SET DEFAULT referential actions to meet SQL spec.Tom Lane2012-06-18
* Refer to the default foreign key match style as MATCH SIMPLE internally.Tom Lane2012-06-17
* Lots of doc corrections.Robert Haas2012-04-23
* Change FK trigger creation order to better support self-referential FKs.Tom Lane2011-10-26
* Remove useless whitespace at end of linesPeter Eisentraut2010-11-23
* Refactor the handling of the various DropStmt variants so that when multipleTom Lane2008-06-14
* Repair problems occurring when multiple RI updates have to be done to the sameTom Lane2007-08-15
* Fix incorrect optimization of foreign-key checks. When an UPDATE on theTom Lane2007-07-17
* Downgrade implicit casts to text to be assignment-only, except for the onesTom Lane2007-06-05
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-09 03:19:52 +0000