When is a constraint too big?

From: lbottorff(at)harveycounty(dot)com
To: pgsql-admin(at)postgresql(dot)org
Subject: When is a constraint too big?
Date: 2001-01-30 22:51:03
Message-ID: 862569E4.007D8671.00@mail.harveycounty.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I'm building a rather large table with certain fields that have a set range of
possible values. Some have a possible range of 100 or more values. Should I
continue to list out the boolean gospel right there in a CONSTRAINT
statement, or is this a job for a trigger, i.e., put the possible values in a
mini lookup table and use a trigger?

L

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Miyabara-McCaskey 2001-01-31 04:16:39 Queries against multi-million record tables.
Previous Message Milind Patil 2001-01-30 06:35:31 Re: pg_hba.conf question