RE: SQL statement PREPARE does not work in ECPG

[Matsumura, Ryo]

Hi Meskes-san

I must use a midrule action like the following that works as expected.
I wonder how to write the replacement to ecpg.addons.
I think it's impossible, right? Please give me some advice.

 PrepareStmt:
PREPARE prepared_name prep_type_clause AS
        {
                prepared_name = $2;
                prepare_type_clause = $3;
                is_in_preparable_stmt = true;
        }
        PreparableStmt
        {
                $$.name = prepared_name;
                $$.type = prepare_type_clause;
                $$.stmt = $6;
                is_in_preparable_stmt = false;
        }
        | PREPARE prepared_name FROM execstring

Regards
Ryo Matsumura

> -----Original Message-----
> From: Michael Meskes [mailto:mes...@postgresql.org]
> Sent: Friday, March 1, 2019 8:42 PM
> To: Matsumura, Ryo/松村 量 <matsumura....@jp.fujitsu.com>; Takahashi,
> Ryohei/高橋 良平 <r.takahash...@jp.fujitsu.com>;
> 'pgsql-hack...@postgresql.org' <pgsql-hack...@postgresql.org>
> Subject: Re: SQL statement PREPARE does not work in ECPG
> 
> Hi Matsumura-san,
> 
> > I will read README.parser, ecpg.addons, and *.pl to understand.
> 
> Feel free to ask, when anything comes up.
> 
> Michael
> --
> Michael Meskes
> Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
> Meskes at (Debian|Postgresql) dot Org
> Jabber: michael at xmpp dot meskes dot org
> VfL Borussia! Força Barça! SF 49ers! Use Debian GNU/Linux, PostgreSQL
>