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

2009-05-08 Thread Tom Lane
Michal Szymanski writes: > 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

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

2009-05-08 Thread Pavel Stehule
Hello you have to do vacuum full cerber.cerber_account regards Pavel Stehule 2009/5/8 Michal Szymanski : > 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 modifie

[BUGS] 42804: structure of query does not match error where using RETURN QUERY

2009-05-08 Thread Michal Szymanski
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 42