table constraint or trigger?

From: Andreas Fromm <Andreas(dot)Fromm(at)physik(dot)uni-erlangen(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: table constraint or trigger?
Date: 2003-09-03 22:20:18
Message-ID: 3F566922.2060102@physik.uni-erlangen.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2003-09-03 22:42:31 Re: setting last_value of sequence
Previous Message Ron Johnson 2003-09-03 22:18:55 Re: Index not being used ?