Re: ECPG failed and Postmaster getting bigger in using perl Pg

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