pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive help / color / mirror / Atom feed From: SAKAIDA Masaaki <sakaida@psn.co.jp>
To: S.F. Lee <sflee_tw@yahoo.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: ECPG failed and Postmaster getting bigger in using perl Pg
Date: Wed, 10 May 2000 15:13:56 +0900
Message-ID: <3918FE241C2.6546SAKAIDA@smtp.psn.ne.jp> (raw )
In-Reply-To: <20000510022157.4467.qmail@web213.mail.yahoo.com >
References: <20000510022157.4467.qmail@web213.mail.yahoo.com >
"S.F. Lee" <sflee_tw@yahoo.com> wrote:
> After executing program(Test), I got different result
> in each version of PostgreSQL,
> such as:
>
> In PostgreSQL 6.5.3 + ecpg 2.7 : a1 = 10 b1 =
> 11.100000
>
> In PostgreSQL 7.0RC5 + ecpg 2.7 : sql_select--foo_1
> : Too few arguments in line 33.
This is a bug of pre-processor in PostgreSQL-7.0RC5.
The solutions of the bug:
1. Don't use a struct host variable.
old) exec sql select * into :temp ...
new) exec sql select a1,b1 into :temp.a1, :temp.b1 ...
2. Apply the next patch.
inline patch 1: postgresql-7.0RC5/src/interfaces/ecpg/preproc/type.c (+6/-0 lines) download inline-1.patch *** postgresql-7.0RC5/src/interfaces/ecpg/preproc/type.c.orig Wed May 10 14:45:55 2000
--- postgresql-7.0RC5/src/interfaces/ecpg/preproc/type.c Wed May 10 14:46:43 2000
***************
*** 198,203 ****
--- 198,209 ----
void
ECPGdump_a_type(FILE *o, const char *name, struct ECPGtype * typ, const char *ind_name, struct ECPGtype * ind_typ, const char *prefix, const char *ind_prefix)
{
+ if (ind_typ == NULL)
+ {
+ ind_typ = &ecpg_no_indicator;
+ ind_name = "no_indicator";
+ }
+
switch (typ->typ)
{
case ECPGt_array:
view thread (8+ messages) latest in thread
Message-ID: <3918FE241C2.6546SAKAIDA@smtp.psn.ne.jp>
Permalink: ../3918FE241C2.6546SAKAIDA@smtp.psn.ne.jp/
Also on: postgresql.org/message-id/3918FE241C2.6546SAKAIDA@smtp.psn.ne.jp
copy link · copy postgr.es · copy git am
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: sakaida@psn.co.jp, sflee_tw@yahoo.com
Subject: Re: ECPG failed and Postmaster getting bigger in using perl Pg
In-Reply-To: <3918FE241C2.6546SAKAIDA@smtp.psn.ne.jp>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox