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

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Dorian Hoxha <dorian(dot)hoxha(at)gmail(dot)com>
Cc: Rob Sargentg <robjsargent(at)gmail(dot)com>, Fede Martinez <federicoemartinez(at)gmail(dot)com>, PostgreSql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Altering array(composite-types) without breaking code when inserting them and similar questions
Date: 2014-04-30 13:51:18
Message-ID: CAHyXU0y0ABYbve7q=PwE0uTsfN_fYA7y_cyU-brbrrKy_4QvJA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Apr 29, 2014 at 2:40 PM, Dorian Hoxha <dorian(dot)hoxha(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andy Colson 2014-04-30 14:14:13 Re: Ingres to Postgres migration
Previous Message Jeff Johnston 2014-04-30 13:34:45 Re: Ingres to Postgres migration