search

EnterpriseDB / pldebugger

Procedural Language Debugger Plugin for PostgreSQL and EDB Postgres Advanced Server
70 stars 19 forks source link

Failed to execute select pldbg_step_into(1) #12

Open iamcarlxu opened 1 year ago

iamcarlxu commented 1 year ago

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

jasonchenTJ commented 7 months ago

Seems it's dbeaver issue instead of the plugin. you can have a try with pgadmin or datagrip.