Re: enhance SPI to support EXECUTE commands

2020-02-01 Thread Tomas Vondra
I've marked this patch as returned with feedback. It's been sitting in the CF without any response from the author since September, and it's not quite clear we actually want/need this feature. If needed, the patch can be resubmitted for 2020-03. regards -- Tomas Vondra http://ww

Re: enhance SPI to support EXECUTE commands

2020-01-04 Thread Tomas Vondra
Hi, On Wed, Sep 18, 2019 at 05:29:52PM +0500, Ahsan Hadi wrote: I don't see much use for this because the documentation says that "server's execute command cannot be used directly within pl/pgsql function (and it is not needed). Within pl/pgsql you can execute update/delete commands using pl/pgs

Re: enhance SPI to support EXECUTE commands

2019-09-18 Thread Ahsan Hadi
I don't see much use for this because the documentation says that "server's execute command cannot be used directly within pl/pgsql function (and it is not needed). Within pl/pgsql you can execute update/delete commands using pl/pgsql EXECUTE command and get results like row_count using "get diagno

Re: enhance SPI to support EXECUTE commands

2019-09-05 Thread Pavel Stehule
pá 6. 9. 2019 v 3:36 odesílatel Quan Zongliang < zongliang.q...@postgresdata.com> napsal: > On 2019/9/5 17:33, Pavel Stehule wrote: > > > > > > čt 5. 9. 2019 v 10:57 odesílatel Quan Zongliang > > > > napsal: > > > > On 2019/9/5 16:31, Pavel Stehule wrot

Re: enhance SPI to support EXECUTE commands

2019-09-05 Thread Quan Zongliang
On 2019/9/5 17:33, Pavel Stehule wrote: čt 5. 9. 2019 v 10:57 odesílatel Quan Zongliang > napsal: On 2019/9/5 16:31, Pavel Stehule wrote: > > > čt 5. 9. 2019 v 10:25 odesílatel Quan Zongliang > mailto:zongliang.q...@postgresdata

Re: enhance SPI to support EXECUTE commands

2019-09-05 Thread Pavel Stehule
čt 5. 9. 2019 v 10:25 odesílatel Quan Zongliang < zongliang.q...@postgresdata.com> napsal: > On 2019/9/5 15:09, Pavel Stehule wrote: > > > > > > čt 5. 9. 2019 v 8:39 odesílatel Quan Zongliang > > > > napsal: > > > > Dear hackers, > > > > I found tha

Re: enhance SPI to support EXECUTE commands

2019-09-05 Thread Pavel Stehule
čt 5. 9. 2019 v 10:57 odesílatel Quan Zongliang < zongliang.q...@postgresdata.com> napsal: > On 2019/9/5 16:31, Pavel Stehule wrote: > > > > > > čt 5. 9. 2019 v 10:25 odesílatel Quan Zongliang > > > > napsal: > > > > On 2019/9/5 15:09, Pavel Stehule wro

Re: enhance SPI to support EXECUTE commands

2019-09-05 Thread Quan Zongliang
On 2019/9/5 16:31, Pavel Stehule wrote: čt 5. 9. 2019 v 10:25 odesílatel Quan Zongliang > napsal: On 2019/9/5 15:09, Pavel Stehule wrote: > > > čt 5. 9. 2019 v 8:39 odesílatel Quan Zongliang > mailto:zongliang.q...@postgresdata.

Re: enhance SPI to support EXECUTE commands

2019-09-05 Thread Quan Zongliang
On 2019/9/5 15:09, Pavel Stehule wrote: čt 5. 9. 2019 v 8:39 odesílatel Quan Zongliang > napsal: Dear hackers, I found that such a statement would get 0 in PL/pgSQL. PREPARE smt_del(int) AS DELETE FROM t1; EXECUTE 'EXECUTE smt_del(100

Re: enhance SPI to support EXECUTE commands

2019-09-05 Thread Pavel Stehule
čt 5. 9. 2019 v 8:39 odesílatel Quan Zongliang < zongliang.q...@postgresdata.com> napsal: > Dear hackers, > > I found that such a statement would get 0 in PL/pgSQL. > > PREPARE smt_del(int) AS DELETE FROM t1; > EXECUTE 'EXECUTE smt_del(100)'; > GET DIAGNOSTICS j = ROW_COUNT; > > In fact, this is a