By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ERROR: type "geometry" does not exist
LINE 1: CREATE TABLE t (gid int, geom geometry(multipolygon,4326));
^
ERROR: relation "t" does not exist
LINE 1: ...ST_Union(geom)) FROM (SELECT gid,(ST_Dump(geom)).* FROM t) j
^