Postgres Pro
Downloads
Home   >   mailing lists

Trigger question: ROW or STATEMENT? - Mailing list pgsql-general

From Patrick Hatcher
Subject Trigger question: ROW or STATEMENT?
Date
Msg-id OFB15119D4.A1652E8E-ON88257101.006630DE-88257101.0066F25D@FDS.com
Whole thread Raw
Responses Re: Trigger question: ROW or STATEMENT?
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: MargaretGillon@chromalloy.com
Date:
Subject: Re: Constraint that compares and limits field values
Next
From: MargaretGillon@chromalloy.com
Date:
Subject: Re: Constraint that compares and limits field values