Re: Proposal: stand-alone composite types
Joe Conway <mail@joeconway.com>
From: Joe Conway <mail@joeconway.com>
To: Thomas Lockhart <lockhart@fourpalms.org>
Cc: Rod Taylor <rbt@zort.ca>, Peter Eisentraut <peter_e@gmx.net>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2002-08-10T00:36:46Z
Lists: 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