node -PG
await db.query(
`DO $$
DECLARE
pbid INT;
BEGIN
INSERT INTO public.bp(process_id) SELECT ${ID} RETURNING id INTO pbid;
COMMIT;
REFRESH MATERIALIZED VIEW public.vm WITH DATA;
UPDATE public.bp SET under_process = FALSE, ended_at = now() WHERE id = pbid;
END;$$;`
);
This script executes fine but ended_at is always the same time as start time.
The refresh takes around 2 min.
附言:我有一台时速new.ended_at := now();英里的扳机101
至少告诉我为什么会发生这种事.