Re: Schema sanity check

Поиск
Список
Период
Сортировка
Искать
От
PFC
Тема
Re: Schema sanity check
Дата
в 18:51:40
Msg-id
op.tso5r4z9cigqcu@apollo13
Ответ на
Schema sanity check (Bill Moseley)
Список
Дерево обсуждения
Schema sanity check Bill Moseley <moseley@hank.org>
Re: Schema sanity check PFC <lists@peufeu.com>

> The other option is to have a column on the mailbox table to flag that
> it is a default_mailbox -- but then I'd have to ensure there's only
> one column for each "person" flagged that way.

- is_default BOOL column in mailbox table
- conditional index :

UNIQUE INDEX ON mailboxes( owner ) WHERE is_default = 't'

> Second question.  So, after a while the obvious problem happens and
> users have too many mailboxes and they want a way to group them into

	Looks like a tree. Why not use a LTREE ?
В списке pgsql-general по дате отправления
От: Bill Moseley
Дата:
Сообщение: Schema sanity check
От: Magnus Hagander
Дата:
FAQ