Hello you have to do vacuum full cerber.cerber_account
regards Pavel Stehule 2009/5/8 Michal Szymanski <[email protected]>: > 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) > RETURNS SETOF cerber.cerber_account AS > $BODY$ > DECLARE > v_result cerber.cerber_account%ROWTYPE; > BEGIN > RETURN QUERY SELECT * FROM cerber.cerber_account WHERE > cerber_account_id=i_cerber_account_id; > RETURN; > END; > $BODY$ > LANGUAGE 'plpgsql' VOLATILE > COST 100 > ROWS 1000; > > > -- > Sent via pgsql-bugs mailing list ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-bugs > -- Sent via pgsql-bugs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
