Andreas and Terry,
thanks for answering and pointing me in the direction. Unfortunately i
found out, that even without the trigger the updates take too much time
for interactive applications. So i go for a batch-update.
Kindly regards, Frank
--
Sent via pgsql-general mailing list (pgsql-gen
On Thursday 02 October 2008 06:26, Frank Durstewitz wrote:
> Hi list.
>
> A fairly complex problem:
>
> - Table A has a before insert/update trigger, which look up table B and
> use field C from table B.
> - Table B has a after insert/update trigger, which update table A with
> field C.
>
> The upd
am Thu, dem 02.10.2008, um 12:26:20 +0200 mailte Frank Durstewitz folgendes:
> My idea is to have it like
> ...
> IF NEW.published = TRUE THEN
>ALTER TABLE a DISABLE TRIGGER mytrigger USER;
>(do update here)
>ALTER TABLE a ENABLE TRIGGER mytrigger USER;
> ...
>
> Will a construct like
