Обсуждение: Referential Integrity

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

Referential Integrity

От
"Gilson Costa"
Дата:
I am a novice in PostgreSQL.
How can I impose referential integrity to my tables?



Re: [SQL] Referential Integrity

От
Steven Bradley
Дата:
PostgreSQL does not implement declarative referential integrity.  It lets
you specify foreign key constraints in table definitions, but does nothing
with them. As such, you have to resort to writing triggers to implement the
traditional RI concerns (e.g.: mandatory parent, cascade delete, etc...).






At 03:41 PM 7/8/99 -0300, you wrote:
>I am a novice in PostgreSQL.
>How can I impose referential integrity to my tables?
>
>
>
>


Steven Bradley
Lawrence Livermore National Laboratory
PO Box 808
Livermore, California 94550
(925) 423-2101       sbradley@llnl.gov