From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Thomas Hallgren <thomas(at)tada(dot)se> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: User Defined Types in Java |
Date: | 2006-02-12 19:03:01 |
Message-ID: | 20060212190301.GD6816@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Sun, Feb 12, 2006 at 07:33:30PM +0100, Thomas Hallgren wrote:
> >Very little, as it makes unjustifiable assumptions about all the
> >datatype's support functions being predictably propertied. (There's
> >more than one possible signature, let alone any secondary properties
> >such as volatility or other stuff we might think of in future.)
> >I think it'd be unworkable from pg_dump's point of view, as well.
> I wasn't aware that there was more then one possible signature. What
> other signatures are possible (I have a working draft in PL/Java now and
> I don't want to miss anything)?
The docs are your friend, see[1] in particular the input_function and
the receive_function.
[1] http://www.postgresql.org/docs/8.1/interactive/sql-createtype.html
> I guess the pg_dump problem that you're thinking of is that there's no
> way to associate the functions with the type that they would belong to.
> Perhaps this could be done by adding a 'protype oid' column to the
> pg_proc table? Introducing that would probably help introducing SQL 2003
> semantics further on (I'm thinking of methods that belongs to types. Not
> very different from a function taking the type as it's first argument).
I think the pg_dump is the fact that pg_dump needs to produce output
that can be parsed to recreate the type and your suggestion only covers
a very small set of possible type definitions (all in same lib,
external func name = postgres func name, etc).
> In any case; at present I use a dummy function to circumvent the Java
> function shell type problem. What was the outcome of the shell type
> discussion? Will a 'CREATE TYPE xxx AS SHELL' or similar be considered
> for 8.2?
Hopefully something will be considered, but the first person who
produces a patch will probably get priority :)
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2006-02-12 19:19:45 | Re: streamlined standby procedure |
Previous Message | Thomas Hallgren | 2006-02-12 18:33:30 | Re: User Defined Types in Java |