Sha256: 47898b2d6a8141e6cf72c09d5e4468e3a6a32ba5dca71e119a14d350dfb00cd9
Contents?: true
Size: 745 Bytes
Versions: 8
Compression:
Stored size: 745 Bytes
Contents
CREATE OR REPLACE FUNCTION "%{table}_insert" ()
RETURNS TRIGGER
AS $$
BEGIN
-- "obsoleted_dt" is set when a history row is created by
-- UPDATE. Leave it alone.
IF NEW.obsoleted_dt <> 'infinity' THEN
RETURN NEW;
END IF;
NEW.obsoleted_dt = 'infinity';
NEW.group_id = NEW.id;
-- FIXME: Handle cases where created_dt is sent in on creation. This
-- is only useful for debugging. Consider removing the surronding
-- IF for production version.
IF NEW.created_dt IS NULL THEN
NEW.created_dt = now();
END IF;
RETURN NEW;
END;
$$ LANGUAGE plpgsql;
DROP TRIGGER IF EXISTS %{table}_insert ON %{table};
CREATE TRIGGER "%{table}_insert" BEFORE INSERT ON "%{table}" FOR EACH ROW
EXECUTE PROCEDURE "%{table}_insert"();
Version data entries
8 entries across 8 versions & 1 rubygems