pldbgapi query

Question

pldbgapi query

Nick Diaz 286

The 'pldbgapi' extension which we try to use in order to do debugging is not exist in the supported list.So, the question is:Is there any other extension which is supported and we can use it in order to do debugging ?
If not, what is alternative way to do stored procedures, functions debugging in the "Azure Database for PostgreSQL - Single Server" and "Azure Database for PostgreSQL - Flexible Server" databases.

1 answer

Your answer

Answer 1

Oury Ba-MSFT 20,911 Microsoft Employee Moderator

Hi @Nick Diaz Thank you for posting your question on Microsoft Q&A and for using Azure services.

My understanding is that you are looking for an extension in order to debug stored procedures, functions ect...
Stored procedures and UDFs: You would work with them in the managed services such as Flexible PostgreSQL and Single server PostgreSQL the same way as in any other PostgreSQL. I.e. all of the guidance that exists out there should be applicable. Find examples here
As far as I know there is no extension that does that in Azure PostgreSQL.

Regards,
Oury

Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2022-08-19T16:32:34.097+00:00

Hi @Nick Diaz Wanted to check if you have further queries. Please let me know

Regards,
Oury
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2022-08-22T22:28:52.49+00:00

Hi @Nick Diaz Did the above answer helped. If yes, please mark as accept answer otherwise let us know how we can further assist you.

Regards,
Oury
yalezag 1 Reputation point

2022-11-09T18:12:21.957+00:00

Hi @Oury Ba-MSFT

As my exprerience in PostgreSQL is still limited I might be wrong with the following...

I also would like to debug functions and stored procedures. After trying and searching a little bit I'm getting the impression that the pldbgapi extension is needed for this.
I'm trying it with Azure Database for PostgreSQL flexible server. Under Server parameters there is the azure.extensions parameter where all available extensions are listed. However the pldbgapi extension is missing:

When trying to debug a function without this extension from pgAdmin 4 (version 6.15) I get the following notification:

Is this way basically correct or is there some other possibility?
If correct, is there some timeline when inclusion of the pldbgapi extension for the flexible server could be expected?

Thanks and best regards,
Plamen
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2022-11-19T00:30:00.82+00:00

Hi @yalezag
The pldbgapi extension is not yet supported in Azure PostgreSQL flexible server. Could you please raise this a feature request at Azure Feedback.
You could use PG admin to debug Stored procedures and functions as I stated in the above answer.

Regards,
Oury

Share via

pldbgapi query

1 answer

Your answer