Re: SQL statement PREPARE does not work in ECPG - Mailing list pgsql-hackers

From Michael Meskes
Subject Re: SQL statement PREPARE does not work in ECPG
Date
Msg-id 68e1dd6c44149c05a71b26dbe2f3d0d2d4582028.camel@postgresql.org
Whole thread Raw
In response to RE: SQL statement PREPARE does not work in ECPG  ("Matsumura, Ryo" <matsumura.ryo@jp.fujitsu.com>)
Responses RE: SQL statement PREPARE does not work in ECPG
List pgsql-hackers
Hi Matsumura-san,

> I defined the following specifications. Please review it.
> 
> * ECPG can accept any valid PREPARE AS statement.
> * A char-type host variable can be used as the statement name of
> PREPARE AS,
>   but its value is constrained by the specification of PREPARE AS.
>   (e.g. the name cannot include double quotation.)
> * The above also allows the following. It's a bit strange but there
> is no reason
>   for forbidding.
>     prepare :st(type_list) as select $1
> * ECPG can accept EXECUTE statement with expression list that is
> allocated
>   by both PREPARE FROM and PREPARE AS under the following
> constraints:
>   - It must not include a using-clause.
>   - The statement name must follow to the specification of PREPARE
> AS.

This look very reasonable to me. I'm completely fine with this
restriction being placed on PREPARE FROM.

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




pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: reindexdb & clusterdb broken against pre-7.3 servers
Next
From: Stephen Frost
Date:
Subject: Re: reindexdb & clusterdb broken against pre-7.3 servers