Thread: Referential Integrity

Referential Integrity

From
"Gilson Costa"
Date:
I am a novice in PostgreSQL.
How can I impose referential integrity to my tables?



Re: [SQL] Referential Integrity

From
Steven Bradley
Date:
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