Re: 42804: structure of query does not match error where using RETURN QUERY

Hello

you have to do vacuum full  cerber.cerber_account

regards
Pavel Stehule

2009/5/8 Michal Szymanski <mich20061@gmail.com>:
> Hi,
> We call DB procedure that select rows with given ID it works as simple
> SELECT but for future changes we implement as DB procedure (look below
> for DB listing). Recently we modified columns in table
> cerber.cerber_accoun and after this modification procedure does not
> work anymore and it returns
> 42804: structure of query does not match
> It is very strange because we return row of cerber_account in variable
> defined as row of cerber_account.
> We have tried to restart database but it does not help. Probably
> information about old table structure is somewhere cached.
>
> CREATE OR REPLACE FUNCTION cerber.cerber_account_select
> (i_cerber_account_id bigint)
> =C2=A0RETURNS SETOF cerber.cerber_account AS
> $BODY$
> DECLARE
> =C2=A0 =C2=A0 =C2=A0 =C2=A0v_result cerber.cerber_account%ROWTYPE;
> BEGIN
> =C2=A0 =C2=A0 =C2=A0 =C2=A0RETURN QUERY SELECT * FROM cerber.cerber_accou=
nt WHERE
> cerber_account_id=3Di_cerber_account_id;
> =C2=A0 =C2=A0 =C2=A0 =C2=A0RETURN;
> END;
> $BODY$
> =C2=A0LANGUAGE 'plpgsql' VOLATILE
> =C2=A0COST 100
> =C2=A0ROWS 1000;
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>