Re: setting up foreign keys

Поиск
Список
Период
Сортировка
От Sue Fitt
Тема Re: setting up foreign keys
Дата
Msg-id 44DAFA6D.4070606@inf.ed.ac.uk
обсуждение исходный текст
Ответ на Re: setting up foreign keys  (Chris <dmagick@gmail.com>)
Ответы Re: setting up foreign keys
Список pgsql-performance
Well they don't necessarily have the same value!

It's a dictionary with cross-referenced words, e.g. 'bring' and
'brought' are both headwords in the dictionary, but 'brought' is
cross-referenced to 'bring'. So, the table stores the information (using
integer id's rather than words) that
    bring: bring
    brought: see bring
    sing: sing
    sang: see sing
etc.

Sue

Chris wrote:
> Sue Fitt wrote:
>> Thanks Chris and Chris, you've solved it.
>>
>> I had a gui open that connects to the database. It was doing nothing
>> (and not preventing me adding to or altering headwords_core via
>> psql), but having closed it the table is instantly created. Weird.
>>
>> BTW, referencing the same column twice is deliberate, it's a
>> cross-reference.
>
> The same column and the same table?
>
> Same column different table I could understand but not the same column
> & table ;)
>
> I'm sure there's a reason for it though :)
>

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

Предыдущее
От: Chris
Дата:
Сообщение: Re: setting up foreign keys
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Beginner optimization questions, esp. regarding Tsearch2