Re: ecpg rejects input parameters

Поиск
Список
Период
Сортировка
От Andrew Pennebaker
Тема Re: ecpg rejects input parameters
Дата
Msg-id CAHXt_SWu2PVfE3u16DzqgR-nnxWHsebi_MppS4HyWwmsybL1cg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ecpg rejects input parameters  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: ecpg rejects input parameters  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: ecpg rejects input parameters  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Could you be more specific?

I can't find a relevant section to address my specific problem: ecpg complaining when I try to check the syntax of my .sql files that use input parameters.

On Wed, Apr 8, 2015 at 9:34 AM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 04/08/2015 07:22 AM, Andrew Pennebaker wrote:
PostgreSQL uses a :colon syntax for parameterizing SQL commands with
command line variables.

create-database.sql:

CREATE DATABASE :db;

Usage:

$ psql -f create-database.sql -v db=test

However, pgsanity/ecpg rejects these.

$ pgsanity create-database.sql
line 1: ERROR: syntax error at or near ":db"

Is there a flag I can give to ecpg to ignore input parameters?

Is there a patch we could make to ecpg to accept input parameters?

Is there another way to write my input parameters to work around this error?

If I am following correctly:

http://www.postgresql.org/docs/9.4/interactive/ecpg-variables.html


--
Cheers,

Andrew Pennebaker
www.yellosoft.us <http://www.yellosoft.us>


--
Adrian Klaver
adrian.klaver@aklaver.com



--
Cheers,

Andrew Pennebaker

В списке pgsql-general по дате отправления:

Предыдущее
От: Dennis
Дата:
Сообщение: Re: bdr.bdr_part_by_node_names does not remove node from bdr.bdr_nodes table
Следующее
От: Tom Lane
Дата:
Сообщение: Re: ecpg rejects input parameters