Ken K <kenmail@telocity.com> writes:
> I am trying to create a user defined type with 2 fields
> in it, a text* and an Oid. I am not sure what size to
> use in the create type command. When I try variable
> the back end core dumps. Are there any examples for
> doing this sort of thing? Is it even doable?
You can't use any kind of pointer in a datatype --- what is it going to
point to? There's nothing it could point at that might live as long as
the datavalue on disk will.
You could embed a TEXT value into a larger varlena value, say
<total length word>
Oid
<text value here, beginning with its own length word>
regards, tom lane