Jan Wieck schrieb:
> You can use RAISE NOTICE to have *debugging* without rolling
> back the transaction.
Nice, thnx |-)
> Maybe it'd help to add more RAISE's to
> see the values of NEW.sport and NEW.dport as well?
I tried and it works, I removed it and it still works. I really don't
know, where the difference compared to the first tries is, but anyway:
create function nac_viceversa() returns opaque as'
begin
NEW.minport := nacmin(NEW.sport,NEW.dport);
NEW.maxport := nacmax(NEW.sport,NEW.dport);
return NEW;
end;
'language 'plpgsql';
create trigger nac_update before insert or update on traf
for each row execute procedure nac_viceversa();
Bye,
Knut