Date: Wed, 10 May 2000 19:53:28 +0900
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
In-Reply-To: <20000510094222.A2799@fam-meskes.de>
References: <3918FE241C2.6546SAKAIDA@smtp.psn.ne.jp>
	<20000510094222.A2799@fam-meskes.de>
Message-Id: <39193FA830C.6548SAKAIDA@smtp.psn.ne.jp>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit


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