When is a constraint too big? - Mailing list pgsql-admin

From lbottorff@harveycounty.com
Subject When is a constraint too big?
Date
Msg-id 862569E4.007D8671.00@mail.harveycounty.com
Whole thread Raw
List 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



pgsql-admin by date:

Previous
From: Milind Patil
Date:
Subject: Re: pg_hba.conf question
Next
From: "Michael Miyabara-McCaskey"
Date:
Subject: Queries against multi-million record tables.