Trigger question: ROW or STATEMENT?

From: Patrick Hatcher <PHatcher(at)macys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Trigger question: ROW or STATEMENT?
Date: 2006-01-25 18:44:27
Message-ID: OFB15119D4.A1652E8E-ON88257101.006630DE-88257101.0066F25D@FDS.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Attempting to do my first trigger and I'm confused about which FOR EACH I
should use: ROW or STATEMENT. I import about 80K rows into an existing
table each day. If I do a STATEMENT, will the changes only happen on the
new 80K rows I inserted or will it be for all rows in the table - currently
about 12M.

TIA

Patrick Hatcher

Responses

Browse pgsql-general by date

  From Date Subject
Next Message MargaretGillon 2006-01-25 18:51:23 Re: Constraint that compares and limits field values
Previous Message Philippe Ferreira 2006-01-25 18:29:00 Re: My very first PL/pgSQL procedure...