Обсуждение: pgsql-server/src backend/commands/tablecmds.c ...

Поиск
Список
Период
Сортировка

pgsql-server/src backend/commands/tablecmds.c ...

От
momjian@postgresql.org (Bruce Momjian - CVS)
Дата:
CVSROOT:    /cvsroot
Module name:    pgsql-server
Changes by:    momjian@postgresql.org    02/08/22 00:51:06

Modified files:
    src/backend/commands: tablecmds.c
    src/test/regress: parallel_schedule serial_schedule
Added files:
    src/test/regress/expected: truncate.out
    src/test/regress/sql: truncate.sql

Log message:
    # Disallow TRUNCATE on tables that are involved in referential
    constraints

    The issue with finding and removing foreign key constraints is no longer
    an issue, so please apply the attached.

    It does NOT check for rules or on delete triggers (old style foreign
    keys) as those are difficult to deal with (remove, truncate, re-add).

    Rod Taylor