Re: Trigger question: ROW or STATEMENT?

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: Patrick Hatcher <PHatcher(at)macys(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Trigger question: ROW or STATEMENT?
Date: 2006-01-25 19:45:15
Message-ID: 87irs8gkhg.fsf@asmodeus.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Patrick Hatcher <PHatcher(at)macys(dot)com> writes:

> 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.

If you told us what you want the trigger to do it would probably be
helpful.

-Doug

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michelle Konzack 2006-01-25 20:40:46 Re: Alternative to knoda, kexi and rekall?
Previous Message Tom Lane 2006-01-25 19:18:19 Re: Postgresql Segfault in 8.1