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 по дате отправления: