Re: text search vs schemas

Поиск
Список
Период
Сортировка
От Trevor Talbot
Тема Re: text search vs schemas
Дата
Msg-id 90bce5730708181213tff95452mfa68ac4a5c977b3e@mail.gmail.com
обсуждение исходный текст
Ответ на Re: text search vs schemas  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On 8/18/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> As my copy of the patch currently stands, there are two built-in trigger
> functions, tsvector_update_trigger and tsvector_update_trigger_column.
> The first expects trigger arguments
>     name of tsvector col, name of tsconfig to use, name(s) of text col(s)
> and the second
>     name of tsvector col, name of tsconfig col, name(s) of text col(s)
> that is, the tsconfig name is stored in a text column.  We could fix
> the second form by changing it to expect the tsconfig column to be of
> type regconfig.  The first form is a bit more problematic.  I can see
> two approaches: either specify both the schema and the tsconfig name,
> as two separate arguments, or keep it one argument but insist that
> the content of the argument be an explicitly-qualified name.  The
> second way seems a bit klugier when considered in isolation, but I think
> I like it better, because there would be a natural migration path to
> treating the argument as being of type regconfig when and if we get
> around to having real types for trigger arguments.  (Which I think is
> a good idea, btw, just not for 8.3.)

I like the second approach too.  It may be slightly awkward for now,
but IMHO it does the right thing.


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

Предыдущее
От: "Trevor Talbot"
Дата:
Сообщение: Re: tsearch2 in PostgreSQL 8.3?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: tsearch2 in PostgreSQL 8.3?