kardasz

CREATE OR REPLACE FUNCTION check_circular_reference() RETURNS TRIGGER AS $$
DECLARE
    circular_found int;
BEGIN
    IF NEW.parent_id IS NOT NULL
    THEN
        IF NEW.parent_id = NEW.id
        THEN
            RAISE EXCEPTION 'circular reference detected';
        END IF;