Re: text search vs schemas - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: text search vs schemas
Date
Msg-id 20070817145945.GF20103@svana.org
Whole thread Raw
In response to Re: text search vs schemas  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: text search vs schemas  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: tsearch2 in PostgreSQL 8.3?
Next
From: Tom Lane
Date:
Subject: Re: tsearch2 in PostgreSQL 8.3?