Page 1 of 1

parameters and/or marcos not work in postgresql do command

Posted: Fri 17 Mar 2017 13:22
by mschroeer
Why can't I insert parameters and/or marcos
in a postgresql "do" command?

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

Posted: Tue 04 Apr 2017 10:28
by azyk
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.

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

Posted: Wed 10 May 2017 11:19
by azyk
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.