Home > mailing lists

table constraint or trigger? - Mailing list pgsql-general

From	Andreas Fromm
Subject	table constraint or trigger?
Date	September 3, 2003 22:59:06
Msg-id	3F566922.2060102@physik.uni-erlangen.de Whole thread Raw
List	pgsql-general

Tree view

Hi,

I have a situation where I could impose a constraint by a rather
complicatet CHECK table constraint, or I could define an ON INSERT OR
UPDATE trigger that would abort the transaction if the validation
doesn't succeed. Is there any advise in favor of one of the solutions?

Regards

Andreas

pgsql-general by date:

From: Greg Stark
Date: 03 September 2003, 22:58:40
Subject: Re: Optimizer picks an ineffient plan

From: Ron Johnson
Date: 03 September 2003, 23:02:45
Subject: Re: Query

table constraint or trigger? - Mailing list pgsql-general

Previous

Next