Re: [GENERAL] structure of query does not match error during RETURN QUERY.

2009-05-08 Thread Michal Szymanski
We have tried to call it from PHP and from pgadmin the result is always the same. This is result from psql crm_test=# select * from cerber.cerber_account_select (1); WARNING: :ERROR:CERBER:cerber_account_select: Blad typu other w trakcie probu pobra

Re: [GENERAL] structure of query does not match error during RETURN QUERY.

2009-05-08 Thread Gevik Babakhani
I see that now... I guess this is bug. please see: http://archives.postgresql.org//pgsql-bugs/2008-11/msg00172.php If it is possible for you, dump and restore the database. I hope this helps. Michal Szymanski wrote: We have tried to call it from PHP and from pgadmin the result is always the s

Re: [GENERAL] structure of query does not match error during RETURN QUERY.

2009-05-08 Thread Gevik Babakhani
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 procedu

Re: [GENERAL] structure of query does not match error during RETURN QUERY.

2009-05-08 Thread Michal Szymanski
We use Postgres 8.3.7 on Linux -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] structure of query does not match error during 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