Thiemo Kellner <thiemo@xxxxxxxxxxxxxxxxxxxx> writes: > However, I want to create a (trigger) function to impose data > consistency. For that purpose, I try to copy the data type of a PL/pgSQL > variable from the base object, a view in that case. Trying so, I get the > following error on installation of the function. > V⠒NODE_TYPE⠒NAME NODE⠒V.NODE_TYPE⠒NAME%type := null; > Syntax error at "%" … invalid type name. If I use the actual type of the > column, all is fine. FWIW, I couldn't reproduce this with the fragmentary scripts you provided. I suspect the problem is not about the special characters in the names, rather about search_path not including the NODE⠒V view. Consider schema-qualifying the view name, or attaching a "SET search_path" clause to the function. regards, tom lane
