121 reputation
17
bio website libregis.org
location Spain
age 34
visits member for 2 years, 4 months
seen Jun 2 '13 at 1:31

I'm a software developer, focused on GIS. PostGIS and GDAL committer. I'd love to add 'where' to people's lives.


Feb
25
awarded  Notable Question
Apr
4
awarded  Scholar
Apr
4
accepted MySQL: Loop over cursor results ends ahead of schedule
Apr
4
awarded  Popular Question
Mar
15
awarded  Autobiographer
Aug
29
comment memc_delete called from a MySQL trigger loop fails randomly
Mmmm, I don't think so. This trigger is raised after update on one table. I execute 'UPDATE' over this table and then the trigger is executed. That's all. Any the MySQL log doesn't show more activity.
Aug
29
asked memc_delete called from a MySQL trigger loop fails randomly
Aug
23
awarded  Student
Aug
23
awarded  Teacher
Aug
23
answered MySQL: Loop over cursor results ends ahead of schedule
Aug
23
comment MySQL: Loop over cursor results ends ahead of schedule
Oh, sorry. The 'after delete' trigger is executed over one table different from the table in which I execute the 'update'/'delete' operations. Already edited that.
Aug
23
awarded  Supporter
Aug
23
revised MySQL: Loop over cursor results ends ahead of schedule
Minor bug in psc fixed.
Aug
22
awarded  Editor
Aug
22
comment MySQL: Loop over cursor results ends ahead of schedule
I've included it, cutting the irrelevant parts.
Aug
22
revised MySQL: Loop over cursor results ends ahead of schedule
Added some SQL code to clarify the question.
Aug
22
comment MySQL: Loop over cursor results ends ahead of schedule
Thanks for your response. It didnt' work, but I think I've found the problem: inside the "Do stuff" part there's some 'select' sentences. If one of these sentences returns an empty result, the declared handler is executed and the loop is interrupted. Trying to figure out how to avoid that...
Aug
22
asked MySQL: Loop over cursor results ends ahead of schedule