BUG #1815: ECPGdebug causes crash on Windows XP

The following bug has been logged online:

Bug reference: 1815
Logged by: joshua masiko
Email address: joshua_masiko(at)yahoo(dot)com
PostgreSQL version: 8.0.3
Operating system: Windows XP SP2
Description: ECPGdebug causes crash on Windows XP
Details:

/* Processed by ecpg (4.0.1) */
/* These include files are added by the preprocessor */
#include <ecpgtype.h>
#include <ecpglib.h>
#include <ecpgerrno.h>
#include <sqlca.h>
/* End of automatic include section */
#line 1 "main.pgc"
#include <stdio.h>

int main(int argc,char **argv)
{
ECPGdebug(1,stderr);
return 0;
}

Running the above program results in a reproducible crash on Windows XP

Environment
Windows XP SP2
Visual Studio SP5
Postgresql 8.0.3

Any ideas??

Make sure the lib directory is in the PATH.
I tested it in MinGW.

$ ecpg main.pgc
$ gcc main.c -I../include -L../lib -lecpg
$ export PATH=$PATH:"/c/Program Files/PostgreSQL/8.0/lib"
$ ./a.exe
[1772]: ECPGdebug: set to 1

""joshua masiko"" <joshua_masiko(at)yahoo(dot)com> wrote
news:20050809194027(dot)A1C76F0B08(at)svr2(dot)postgresql(dot)org(dot)(dot)(dot)
>
> The following bug has been logged online:
>
> Bug reference: 1815
> Logged by: joshua masiko
> Email address: joshua_masiko(at)yahoo(dot)com
> PostgreSQL version: 8.0.3
> Operating system: Windows XP SP2
> Description: ECPGdebug causes crash on Windows XP
> Details:
>
> /* Processed by ecpg (4.0.1) */
> /* These include files are added by the preprocessor */
> #include <ecpgtype.h>
> #include <ecpglib.h>
> #include <ecpgerrno.h>
> #include <sqlca.h>
> /* End of automatic include section */
> #line 1 "main.pgc"
> #include <stdio.h>
>
> int main(int argc,char **argv)
> {
> ECPGdebug(1,stderr);
> return 0;
> }
>
> Running the above program results in a reproducible crash on Windows XP
>
> Environment
> Windows XP SP2
> Visual Studio SP5
> Postgresql 8.0.3
>
> Any ideas??
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>

Can someone on the interfaces list comment on this? Thanks.

---------------------------------------------------------------------------

joshua masiko wrote:
>
> The following bug has been logged online:
>
> Bug reference: 1815
> Logged by: joshua masiko
> Email address: joshua_masiko(at)yahoo(dot)com
> PostgreSQL version: 8.0.3
> Operating system: Windows XP SP2
> Description: ECPGdebug causes crash on Windows XP
> Details:
>
> /* Processed by ecpg (4.0.1) */
> /* These include files are added by the preprocessor */
> #include <ecpgtype.h>
> #include <ecpglib.h>
> #include <ecpgerrno.h>
> #include <sqlca.h>
> /* End of automatic include section */
> #line 1 "main.pgc"
> #include <stdio.h>
>
> int main(int argc,char **argv)
> {
> ECPGdebug(1,stderr);
> return 0;
> }
>
> Running the above program results in a reproducible crash on Windows XP
>
> Environment
> Windows XP SP2
> Visual Studio SP5
> Postgresql 8.0.3
>
> Any ideas??
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

William ZHANG wrote:
> Make sure the lib directory is in the PATH.
> I tested it in MinGW.
>
> $ ecpg main.pgc
> $ gcc main.c -I../include -L../lib -lecpg
> $ export PATH=$PATH:"/c/Program Files/PostgreSQL/8.0/lib"
> $ ./a.exe
> [1772]: ECPGdebug: set to 1

Ah, interesting. Why would it crash if the lib directory is not in the
path? Because it can't load the library?

---------------------------------------------------------------------------

>
>
> ""joshua masiko"" <joshua_masiko(at)yahoo(dot)com> wrote
> news:20050809194027(dot)A1C76F0B08(at)svr2(dot)postgresql(dot)org(dot)(dot)(dot)
> >
> > The following bug has been logged online:
> >
> > Bug reference: 1815
> > Logged by: joshua masiko
> > Email address: joshua_masiko(at)yahoo(dot)com
> > PostgreSQL version: 8.0.3
> > Operating system: Windows XP SP2
> > Description: ECPGdebug causes crash on Windows XP
> > Details:
> >
> > /* Processed by ecpg (4.0.1) */
> > /* These include files are added by the preprocessor */
> > #include <ecpgtype.h>
> > #include <ecpglib.h>
> > #include <ecpgerrno.h>
> > #include <sqlca.h>
> > /* End of automatic include section */
> > #line 1 "main.pgc"
> > #include <stdio.h>
> >
> > int main(int argc,char **argv)
> > {
> > ECPGdebug(1,stderr);
> > return 0;
> > }
> >
> > Running the above program results in a reproducible crash on Windows XP
> >
> > Environment
> > Windows XP SP2
> > Visual Studio SP5
> > Postgresql 8.0.3
> >
> > Any ideas??
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 9: In versions below 8.0, the planner will ignore your desire to
> > choose an index scan if your joining column's datatypes do not
> > match
> >
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

"Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>
wrote:200508130244(dot)j7D2iJE03191(at)candle(dot)pha(dot)pa(dot)us(dot)(dot)(dot)
> William ZHANG wrote:
> > Make sure the lib directory is in the PATH.
> > I tested it in MinGW.
> >
> > $ ecpg main.pgc
> > $ gcc main.c -I../include -L../lib -lecpg
> > $ export PATH=$PATH:"/c/Program Files/PostgreSQL/8.0/lib"
> > $ ./a.exe
> > [1772]: ECPGdebug: set to 1
>
>
> Ah, interesting. Why would it crash if the lib directory is not in the
> path? Because it can't load the library?

Maybe I misunderstood the word 'crash'. If I forgot to put the lib
directory,
it will make Windows popup a GUI warning window.

joshua masiko: Can you give more information?