Re: [GENERAL] Shared Constants in PLPGSQL - Mailing list pgsql-general

From Merlin Moncure
Subject Re: [GENERAL] Shared Constants in PLPGSQL
Date
Msg-id CAHyXU0ydY8AoPLMGbyFYrjMRtC84-VvCg3eVqUY4_FP0ZqvUQQ@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Shared Constants in PLPGSQL  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
On Tue, Aug 1, 2017 at 8:04 AM, Merlin Moncure <mmoncure@gmail.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


pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: [GENERAL] Shared Constants in PLPGSQL
Next
From: Scott Marlowe
Date:
Subject: Re: [GENERAL] Question about loading up a table