Re: BUG #5982: recursive type crashes postgres - Mailing list pgsql-bugs

Rikard Pavelic <rikard.pavelic@zg.htnet.hr> wrote:
> On 15.4.2011 21:06, Tom Lane wrote:
>> The former.
>>
>> regression=# CREATE TYPE turtle AS
>> (
>> name varchar
>> );
>> CREATE TYPE
>> regression=# ALTER TYPE turtle ADD ATTRIBUTE offspring turtle;
>> ERROR:  composite type turtle cannot be made a member of itself
>> regression=#

> Todo item?

I haven't seen anything which seems like a reasonable use case yet,
myself.  If you were *actually* tracking turtles and their
offspring, that would be a completely worthless data structure.  Is
there really a case where a reference to the ID of an object of like
type isn't a better solution?

-Kevin