| From: | Ian Turner <vectro(at)pipeline(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: subselect in CHECK constraint? |
| Date: | 2000-09-04 17:31:27 |
| Message-ID: | Pine.LNX.4.21.0009041030350.1204-100000@crafter.house |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
> Also, as several other people already pointed out, a constraint
> involving a select could be violated in many ways including alteration
> or removal of tuples in other tables. We only evaluate check
> constraints when we insert/update tuples in the table they are attached
> to...
OK.
Is this something that could be accomplished with triggers? :o
Also, is it possible to have a foreign key constraint across multiple
columns? :o
Ian
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.1 (GNU/Linux)
Comment: For info see http://www.gnupg.org
iD8DBQE5s9xxfn9ub9ZE1xoRAo9WAJ0blihjzEQFo+3clEGRsySjkUzrqgCdEIhe
8VumU6bICMN6jUHCdq0WSYM=
=niuY
-----END PGP SIGNATURE-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Lockhart | 2000-09-04 17:47:13 | Re: Viability of VARLENA_FIXED_SIZE() |
| Previous Message | Rafa Couto | 2000-09-04 17:12:22 | RE: Postgres 7.0.2 and ODBC |