Zrobilem taki testowy triger
CREATE OR REPLACE FUNCTION trg_test_ins_bef()
RETURNS trigger AS
$func$
BEGIN
UPDATE table1 SET date1 = true WHERE date1 = false;
RETURN NEW;
END
$func$ LANGUAGE plpgsql;
CREATE TRIGGER ins_up_bef
BEFORE INSERT OR UPDATE ON table1
FOR EACH ROW
EXECUTE PROCEDURE trg_test_ins_bef();
jak wstawiam cos do bazy dostaje
CONTEXT: SQL statement "UPDATE table1 SET date1 = true WHERE date1 = false"
PL/pgSQL function "trg_test_ins_bef" line 3 at SQL statement
Może ktoś wie o co tu chodzi ?
dodanie znacznika <code> - furious programming