Re: Proposal: stand-alone composite types - Mailing list pgsql-hackers

From Joe Conway
Subject Re: Proposal: stand-alone composite types
Date
Msg-id 3D54601E.1020507@joeconway.com
Whole thread Raw
In response to Re: Proposal: stand-alone composite types  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Proposal: stand-alone composite types  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Thomas Lockhart wrote:
>>That's what I was thinking. In cases where you want to use the type for
>>several functions, use CREATE TYPE. If you only need the type for one
>>function, let the function creation process manage it for you.
> 
> It would be nice then to have some mechanism for converting the
> "automatic type" to a named type which could be used elsewhere.
> Otherwise one would need to garbage collect the separate stuff later,
> which would probably go into the "not so convenient" category of
> features...

Well I think that could be handled with the new dependency tracking 
system. Same as the SERIAL/sequence analogy -- when you drop the 
function, the type would automatically and transparently also get dropped.

Joe




pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: Proposal: stand-alone composite types
Next
From: Bruce Momjian
Date:
Subject: Re: PITR, checkpoint, and local relations