On Sat, Nov 18, 2006 at 01:07:15PM -0800, J. Greg Davidson wrote:
> Hello, 
> 
> My user-defined types are crashing the PostgreSQL server and I don't
> understand why.  I've been trying to figure it out on my own for overr
> a week.  I've cooked what I'm doing down to the essentials and I'm
> asking for help.  Help: What am I doing wrong?

This may be a long shot but:

> CREATE TYPE pair (
>   INTERNALLENGTH = 4,         -- 32-bits
>   INPUT = pair_in,
>   OUTPUT = pair_out
> );

You're not specifying PASSEDBYVALUE, so I think postgres is assuming
you're returning a *pointer* to 4 bytes, so it's dying trying to copy
it.

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

Attachment: signature.asc
Description: Digital signature

Reply via email to