3 INSERT INTO config.upgrade_log (version) VALUES ('0475'); -- dbwells
5 CREATE OR REPLACE FUNCTION asset.autogenerate_placeholder_barcode ( ) RETURNS TRIGGER AS $f$
7 IF NEW.barcode LIKE '@@%' THEN
8 NEW.barcode := '@@' || NEW.id;
14 CREATE TRIGGER autogenerate_placeholder_barcode
15 BEFORE INSERT OR UPDATE ON asset.copy
16 FOR EACH ROW EXECUTE PROCEDURE asset.autogenerate_placeholder_barcode();