pldebugger
pldebugger copied to clipboard
Failed to execute select pldbg_step_into(1)
First debugger for pgsql can't identify variables of record type, like this:
declare rec record; declare jsonData varchar; declare msgStatus varchar; declare msgId int; declare msgCreateTime timestamp; begin if catName = 'temp' then for rec in select t0.id from zmsg t0 where t0.cat_name = catName and (t0.msg_create_time + t0.report_time_val::interval <= now() or t0.report_time_point::timestamp <= now()) loop ..... when launched the debugger, there is no rec showed in variables list .
second when excution steps into circulation like "for" ,it occurs an error :
Failed to execute select pldbg_step_into(1) ERROR: debugger connection terminated ERROR: debugger connection terminated
DBeaver 22.2.4 PgSQL 10.0
Seems it's dbeaver issue instead of the plugin. you can have a try with pgadmin or datagrip.