Re: [SQL] Referential Integrity - Mailing list pgsql-sql

From Steven Bradley
Subject Re: [SQL] Referential Integrity
Date
Msg-id 3.0.5.32.19990708133826.0092d6e0@poptop.llnl.gov
Whole thread Raw
In response to Referential Integrity  ("Gilson Costa" <gpcosta@ruralsp.com.br>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Engard Ferenc
Date:
Subject: offtopic: odbc C frontend for linux?
Next
From: "Stephen Boyle"
Date:
Subject: Re: [SQL] offtopic: odbc C frontend for linux?