thnx.
i try to sound the idea to ensure myself that you are right.
> begin transaction;
> lock t1 in access exclusive mode;
>
> Turn off triggers and do your updates.
> (Note, "truncate t1" is faster than "delete from t1" followed by a
> "vacuum full" and you might consider running "reindex table
> often, I am turning triggers off and on to perform a mass operation
> on a table, and i am interested how should i care of another user
> operations.
>
> the scene is:
> table t1 with user defined triggers
> and many tables reference t1, (so FK triggers defined on t1)
>
> the operation i want to
Good day.
often, I am turning triggers off and on to perform a mass operation on a
table, and i am interested how should i care of another user operations.
the scene is:
table t1 with user defined triggers
and many tables reference t1, (so FK triggers defined on t1)
the operation i want to per
