From: | Steven Bradley <sbradley(at)llnl(dot)gov> |
---|---|
To: | "Gilson Costa" <gpcosta(at)ruralsp(dot)com(dot)br> |
Cc: | pgsql-sql(at)postgreSQL(dot)org |
Subject: | Re: [SQL] Referential Integrity |
Date: | 1999-07-08 20:38:26 |
Message-ID: | 3.0.5.32.19990708133826.0092d6e0@poptop.llnl.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)llnl(dot)gov
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 1999-07-08 21:52:39 | Re: [SQL] offtopic: odbc C frontend for linux? |
Previous Message | Engard Ferenc | 1999-07-08 20:36:31 | offtopic: odbc C frontend for linux? |