Postgres Pro
Downloads
Home   >   mailing lists

Re: DECLARE STATEMENT setting up a connection in ECPG - Mailing list pgsql-hackers

From Michael Meskes
Subject Re: DECLARE STATEMENT setting up a connection in ECPG
Date
Msg-id 20161117194501.svz7pc4ouoyeuxnn@feivel
Whole thread Raw
In response to DECLARE STATEMENT setting up a connection in ECPG  ("Ideriha, Takeshi" <ideriha.takeshi@jp.fujitsu.com>)
Responses Re: DECLARE STATEMENT setting up a connection in ECPG  ("Ideriha, Takeshi" <ideriha.takeshi@jp.fujitsu.com>)
List pgsql-hackers
Tree view 
> [System Design Plan]
> To support above functionality, ecpg precompiler should support:
>  - To understand the DECLARE STATEMENT syntax 

Already does, albeit as a noop.

>  - Translate the DECLARE STATEMENT into a new function with parameters. 
>    These parameters carry the information like connection_name and statement_name. 
>  - The function is a new function defined in the ECPG library.

Why's that? I haven't checked if the standard says anything about this and my
memory might be wrong, but isn't "DECLARE STATEMENT" supposed to be purely
declarative, i.e. not executed at run time?  

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! Go SF 49ers! Use Debian GNU/Linux, PostgreSQL

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Fun fact about autovacuum and orphan temp tables
Next
From: Peter Geoghegan
Date:
Subject: Re: amcheck (B-Tree integrity checking tool)