parameters and/or marcos not work in postgresql do command

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
mschroeer
Posts: 1
Joined: Fri 17 Mar 2017 12:51

parameters and/or marcos not work in postgresql do command

Post by mschroeer » Fri 17 Mar 2017 13:22

Why can't I insert parameters and/or marcos
in a postgresql "do" command?

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: parameters and/or marcos not work in postgresql do command

Post by azyk » Tue 04 Apr 2017 10:28

Thank you for the information. We reproduced the specified problem with parameters/macros for anonymous block and are investigating it now. We will inform you about the obtained results.

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: parameters and/or marcos not work in postgresql do command

Post by azyk » Wed 10 May 2017 11:19

PostgreSQL does not support parameters inside an anonymous block. You can find the topic about parameters implementation in an anonymous DO block at UserVoice of PostgreSQL developers ( https://postgresql.uservoice.com/forums ... -like-in-o ). To solve the specified problem you can leave a post at UserVoice using the above link or contact PostgreSQL technical support.

Post Reply