From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | stan <stanb(at)panix(dot)com> |
Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Detecting which columns a query will modify in a function called by a trigger |
Date: | 2020-03-02 20:44:52 |
Message-ID: | CAKFQuwaYuvQert-Szy7khu4tB6avCah0wqavsQzPDxX+-vjj_g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs pgsql-general |
On Mon, Mar 2, 2020 at 1:28 PM stan <stanb(at)panix(dot)com> wrote:
> Envision a table with a good many columns. This table represents the "life
> history" of a part on a project. Some of the columns need to be
> created/modified by the engineer. Some need to be created/modified by the
> purchasing agent, some of the columns need to be created by the receiving
> department, some of the columns need to be created/modified by the accounts
> payable department.
>
> Make sense?
>
On a theory level this design is insufficiently normalized. The fact that
you are having issues and challenges working with it suggests you should
seriously consider a different design, one that exhibits better
normalization properties.
Alternatively you might consider just removing direct access to the table
and provide views and/or functions that can use normal permission grants.
Add some check constraints to the table to describe and enforce the
inter-field relationships that are present.
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Cross | 2020-03-02 20:50:33 | Re: Detecting which columns a query will modify in a function called by a trigger |
Previous Message | stan | 2020-03-02 20:28:29 | Re: Detecting which columns a query will modify in a function called by a trigger |
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Cross | 2020-03-02 20:50:33 | Re: Detecting which columns a query will modify in a function called by a trigger |
Previous Message | stan | 2020-03-02 20:28:29 | Re: Detecting which columns a query will modify in a function called by a trigger |