Re: Altering array(composite-types) without breaking code when inserting them and similar questions - Mailing list pgsql-general

On Tue, Apr 29, 2014 at 2:40 PM, Dorian Hoxha <dorian.hoxha@gmail.com> wrote:
> So :
>
> drop function
> alter type: add column
> create again function with new default argument in a transaction ?

Yeah -- something like that.  Try it out (carefully).  AIUI, In most
cases the function execution will be inlined so the performance hit
should be minimal vs raw insert.

merlin