Re: CHECK vs REFERENCES

Поиск
Список
Период
Сортировка
От Vivek Khera
Тема Re: CHECK vs REFERENCES
Дата
Msg-id 4CF7BD03-26BB-4883-9DCA-F7CB39100BC2@khera.org
обсуждение исходный текст
Ответ на CHECK vs REFERENCES  ("Marc G. Fournier" <scrappy@postgresql.org>)
Список 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



В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Deadlock Issue with PostgreSQL
Следующее
От: Vivek Khera
Дата:
Сообщение: Re: Performance considerations for very heavy INSERT traffic