Re: subselect in CHECK constraint? - Mailing list pgsql-general

From Ian Turner
Subject Re: subselect in CHECK constraint?
Date
Msg-id Pine.LNX.4.21.0009041030350.1204-100000@crafter.house
Whole thread Raw
In response to Re: subselect in CHECK constraint?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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-----


pgsql-general by date:

Previous
From: "Rafa Couto"
Date:
Subject: RE: Postgres 7.0.2 and ODBC
Next
From: Michaël Fiey
Date:
Subject: NULL value withe cursor