Re: CHECK vs REFERENCES

From: Vivek Khera <vivek(at)khera(dot)org>
To: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: CHECK vs REFERENCES
Date: 2005-09-21 15:35:02
Message-ID: 4CF7BD03-26BB-4883-9DCA-F7CB39100BC2@khera.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


On Sep 9, 2005, at 11:23 PM, Marc G. Fournier wrote:

> The case is where I just want to check that a value being inserted
> is one of a few possible values, with that list of values rarely
> (if ever) changing, so havng a 'flexible list' REFERENCED seems
> relatively overkill ...
>

That's what I thought until the first time that list needed to be
altered. At this point, it becomes a royal pain.

point to take: do it right the first time, or you have to do it over,
and over, and over...

Vivek Khera, Ph.D.
+1-301-869-4449 x806

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Vivek Khera 2005-09-21 15:57:42 Re: Performance considerations for very heavy INSERT traffic
Previous Message Tom Lane 2005-09-21 02:15:24 Re: Deadlock Issue with PostgreSQL