Re: Shared Constants in PLPGSQL

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Tim Uckun <timuckun(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Shared Constants in PLPGSQL
Date: 2017-08-01 13:10:33
Message-ID: CAHyXU0ydY8AoPLMGbyFYrjMRtC84-VvCg3eVqUY4_FP0ZqvUQQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Aug 1, 2017 at 8:04 AM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
> re-evaluate. The main advantage over your approach is that you don't
> have to modify multiple things every time you add a new config values;
> just add a column and replace the function.

This can be automated too, via event triggers:
https://www.postgresql.org/docs/9.3/static/sql-createeventtrigger.html

merlin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2017-08-01 13:24:22 Re: Question about loading up a table
Previous Message Merlin Moncure 2017-08-01 13:04:08 Re: Shared Constants in PLPGSQL