How do you call this function from your code? Does it work when you call it from PGAdmin? select * from cerber.cerber_account_select (1); Michal Szymanski wrote:
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; Michal Szymankis http://blog.szymanskich.net
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
