Search Postgresql Archives

Re: Any way to insert rows with ID used in another column

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 04/06/2014 05:30 AM, Francisco Olarte wrote:
Hi Adrian:


On Sun, Apr 6, 2014 at 2:30 AM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
Still think this is something for a BEFORE INSERT TRIGGER:

I think a trigger is overkill for just a simple data-combining
procedure. JMO, but I prefere to reserve triggers for htings which
need them.

Well the flip side to that argument is that a trigger is a single point of reference for the data changing. You can hit the table from wherever and whatever and have the same thing happen. No wrestling with ORMs to get database specific code to run. No tracking down where the query is that is munging the data. Not saying one approach is inherently better than the other, just that there are options.



Regards.
    Francisco Olarte.



--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux