Re: Attribute of type record has wrong type error with MERGE ... WHEN NOT MATCHED BY SOURCE THEN DELETE

Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> writes:
> However, that's not quite the end of it -- preprocess_function_rtes()
> / inline_set_returning_function() can turn a function RTE into a
> subquery RTE, leading to a similar problem:

> create table foo (a int, b int);
> insert into foo values (1,2);
> create or replace function f() returns setof foo as
> $$ select * from foo offset 0 $$ language sql stable;
> update foo set b = f.b from f() as f(a,b) where f.a = foo.a returning f;

> ERROR: attribute 3 of type record has wrong type
> DETAIL: Table has type record, but query expects foo.

Double ugh. I guess we could get preprocess_function_rtes to
insert the appropriate relid ...

regards, tom lane