| From: | Howie <caffeine(at)toodarkpark(dot)org> |
|---|---|
| To: | Ramanika <ramanika(at)flashmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgreSQL(dot)org>, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgreSQL(dot)org> |
| Subject: | Re: [SQL] referential integrity |
| Date: | 1999-08-04 11:08:30 |
| Message-ID: | Pine.LNX.3.96.990804110659.19176N-100000@rabies.toodarkpark.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
On Wed, 4 Aug 1999, Ramanika wrote:
> I did not see this in the documentation anywhere. Does postgresql
> support referential integrity? like when creating a table REFERENCES
> table(column_id)?
not directly, no. at least not yet :) 6.6 is rumoured to have full
support.
for now you can use refint ( $PGSQL_SRC_ROOT/contrib/spi/refint.* ), which
handles referential integrity. check_primary_key() and
check_foreign_key() are the two functions involved. youd also need two
triggers, one per table.
i could've sworn this got added to the FAQ...
---
Howie <caffeine(at)toodarkpark(dot)org> URL: http://www.toodarkpark.org
"The distance between insanity and genius is measured only by success."
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Howie | 1999-08-04 11:39:58 | Re: [GENERAL] Query buffer problem. |
| Previous Message | Herouth Maoz | 1999-08-04 10:03:22 | Re: [GENERAL] Data type recommendation |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | astromonk | 1999-08-04 18:22:42 | sequences not reliable? |
| Previous Message | Herouth Maoz | 1999-08-04 09:22:53 | Re: [SQL] datetime sample code? |