Re: text search vs schemas

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: text search vs schemas
Дата
Msg-id 20070817145945.GF20103@svana.org
обсуждение исходный текст
Ответ на Re: text search vs schemas  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: text search vs schemas
Список pgsql-hackers
On Fri, Aug 17, 2007 at 10:42:09AM -0400, Tom Lane wrote:
> Martijn van Oosterhout <kleptog@svana.org> writes:
> > I'm unsure how it works now, but it seems reasonable that when a
> > regclass/regtype/regetc is passed to a trigger, pass it in OID form.
>
> If you insist on a solution that involves attaching type information
> to trigger arguments, then we can forget about getting tsearch into 8.3.
> That's a nontrivial amount of new design and code that hasn't even been
> on the radar screen before.

Hmm, maybe I didn't explain clearly enough. I meant that if the
argument is a regclass for example, to pass it in the TG_ARGV list as
the OID in *string form*.

That way trigger arguments stay a list of strings, yet the whole thing
is schema safe because when trigger body casts the string back to a
regclass, it gets exactly what was passed.

Hope this makes more sense,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

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

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