(my $lintags_inssql = <<~'SQLSTR') =~s/(?:^\t*|\n)/ /gmx;
	INSERT INTO linktags (filesrc, metadir, tagname, tagvalue, symlink, filesref, dirtype,status) 
	SELECT  a.filesrc, a.metadir, tagname, tagvalue,
## This is line 4486 ##		metadir||'/'||tagname||$1||tagvalue||$1||filenameparts[1]||'_'||array_to_string(linka[linkano-2:linkano-1]
## line 4486 ##
	,'_')||filenameparts[2] symlink
		,filesref,dirtype,'new'
	FROM
		(SELECT DISTINCT  l.filesrc, c.metadir||'/0_meta' metadir, tagname, tagvalue
			,string_to_array(filesrc,$1)linka,
		 
			cardinality(string_to_array(filesrc,$1)) linkano,
			regexp_matches(filesrc,'.*/(.*)(\..*)') filenameparts,
			filesref, dirtype
			FROM public.linktags l
			JOIN chkmeta c ON l.filesrc  LIKE c.metadir||'%' WHERE (status='new')
		) a

	 ON CONFLICT(symlink) DO UPDATE SET dirtype=EXCLUDED.dirtype
	SQLSTR