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

From Kevin Grittner
Subject Re: BUG #5982: recursive type crashes postgres
Date
Msg-id 4DA8720F020000250003C8D5@gw.wicourts.gov
Whole thread Raw
In response to Re: BUG #5982: recursive type crashes postgres  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: BUG #5982: recursive type crashes postgres  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-bugs
Merlin Moncure <mmoncure@gmail.com> wrote:

> There are lots of use cases for this.  I use composite types to
> marshal data to the client all the time, and recursive structures
> are fairly common in many classic problems.  Recursive composites
> fit the bill perfectly.

I'm trying to get my head around why SQL composite types are a good
way to marshal complex object graphs with recursion.  I can see
where it could be done, I'm still not convinced that it's better
than SQL passing out data in tabular form with relationship
established by matching values.  In other words, when is it a good
idea to do the relation to object mapping in the database engine?

-Kevin

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re[2]: BUG #5977: Crash on delete
Next
From: Merlin Moncure
Date:
Subject: Re: BUG #5982: recursive type crashes postgres