problem with cursur within a scriptfile
От | Cornelia Boenigk |
---|---|
Тема | problem with cursur within a scriptfile |
Дата | |
Msg-id | 00f201c3f964$2d68baf0$0201a8c0@zwerg2000 обсуждение исходный текст |
Ответ на | DBD::Pg 1.32 ready for testing (greg@turnstep.com) |
Ответы |
Re: problem with cursur within a scriptfile
|
Список | pgsql-general |
Hi everybody I defined a function returning refcursor. CREATE FUNCTION cursorname (refcursor, character varying, character varying) RETURNS refcursor ... which does a select with username and serachphrase. If I call BEGIN; SELECT cursorname(`test`,`username`,`searchphrase`); MOVE 10 in test; FETCH 25 from test; COMMIT; inside psql everything works well. If I put this code into a scriptfile and call it, I get the following errormessage: cannot handle multiple result groups Why? What does this mean? I use a webserver which has 'one' persistent connection to the database. Executing the script the connection breaks. Trying to do a rollback the database returns that there is no transaction in progress. Any help is welcome Regards Conni
В списке pgsql-general по дате отправления: