From: "William ZHANG" <uniware@zedware.org>
Subject: Re: BUG #1815: ECPGdebug causes crash on Windows XP
Date: Wed, 10 Aug 2005 14:15:43 +0800
Organization: zedware
Lines: 55
Message-ID: <ddcdrc$1705$1@news.hub.org>
References: <20050809194027.A1C76F0B08@svr2.postgresql.org>
To: pgsql-bugs@postgresql.org

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@yahoo.com> wrote
news:20050809194027.A1C76F0B08@svr2.postgresql.org...
>
> The following bug has been logged online:
>
> Bug reference:      1815
> Logged by:          joshua masiko
> Email address:      joshua_masiko@yahoo.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
>