From: SAKAIDA Masaaki <sakaida@psn.co.jp>
To: Michael Meskes <meskes@postgresql.org>
Cc: PostgreSQL Interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: ECPG failed and Postmaster getting bigger in using perl Pg
Date: Wed, 10 May 2000 19:53:28 +0900
Message-ID: <39193FA830C.6548SAKAIDA@smtp.psn.ne.jp> (raw)
In-Reply-To: <20000510094222.A2799@fam-meskes.de>
References: <3918FE241C2.6546SAKAIDA@smtp.psn.ne.jp>
<20000510094222.A2799@fam-meskes.de>
Michael Meskes <meskes@postgresql.org> wrote:
> > This is a bug of pre-processor in PostgreSQL-7.0RC5.
>
> ARGH!
>
> > The solutions of the bug:
> >
> > 1. Don't use a struct host variable.
>
> Not really a solution.
This solution would be effective only when ecpg is not fixed ;-).
> > 2. Apply the next 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";
> > + }
> > +
>
> This has been in before. I have no idea where it got lost.
Probably, when you were editting it, you have made a mistake,
I think :-).
BTW If ecpg is fixed, we can use a struct indicator, too. (ex.
select * into :temp :ind_temp from foo_1 ..) It is wonderful that
such a struct host variable can be used. Ecpg is very good tool.
--
Regards,
SAKAIDA Masaaki -- Osaka, Japan
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, meskes@postgresql.org
Subject: Re: ECPG failed and Postmaster getting bigger in using perl Pg
In-Reply-To: <39193FA830C.6548SAKAIDA@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