Le lundi 06 décembre 2010 à 18:27 -0600, Sairam Krishnamurthy a écrit :
You should start a new thread for this
> Is there a way to call a rule when I use "COPY FROM" instead of
> "INSERT INTO"
>
from the doc :
COPY FROM will invoke any triggers and check constraints on the
destination table.
>From the 8.3 docs...
"Be aware that COPY ignores rules. ... COPY does fire triggers, so you can
use it normally if you use the trigger approach."
HTH,
Brent Wood
All,
I have a rule written on a temp table which will copy the valuesinserted into
it to another table applying a fu
All,
I have a rule written on a temp table which will copy the values
inserted into it to another table applying a function. The temp table
will be discarded then. The rules I have written works when I use
"Insert into" the temp table. But when I use bulk copy "COPY FROM", the
rule doesn't ge