Thiemo Kellner <thiemo@gelassene-pferde.biz> 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