Re: [Aubit4gl-developers] problem inserting null date

[Mike A. <mik...@au...>]

They should be in postgres' sqltypes.h.

I'd try compiling with the paths attached to the --with- too for the postgres 
stuff - mine is :

./configure  --with-unixodbc=/usr/local/unixODBC/lib 
--with-pgsqleng=/usr/local/pgsql --with-pgsql=/usr/local/pgsql 
--with-ecpg=/usr/local/pgsql --without-sapdb  
--prefix=/home/aubit4gl/aubit4gl  --with-gtk=/opt/gnome 
--with-pgodbc=/usr/local



add a liberal sprinkling of '\' to that..

As for why we need quite so many settings for a postgres config - you'll need 
to ask andrej :-)


Finally - the date stuff is being worked on atm - Bernard Moreton has reported 
a few issues into mantis (www.aubit.com/mantis) which need fixing (of which I 
fixed one major problem last week :-)
If you can provide a nice test case (along with your A4GL_SQLTYPE setting) - I 
can ensure that its included in out regression tests 


On Tuesday 08 March 2005 14:00, Marko Kreen wrote:
> On Tue, Mar 08, 2005 at 12:32:27PM +0000, Mike Aubury wrote:
> > I'll take a look at this - dates with odbc is a kmown issue - ODBC
> > doesn't do dates very well :-(
> >
> > If you're going to be using postgres - I would really recommend using the
> > EC code generation - with ecpg (and if you are porting from an existing
> > informix application - using the patched postgres if you can..)
>
> Well, it does not compile:
>
> $ ./configure \
>         --prefix=/opt/apps/aubit \
>         --with-all=no \
>         --with-curses \
>         --with-ecpg \
>         --with-pgsql \
>         --with-unixodbc
> [ ... ]
> $ make
> [ ... ]
> make[2]: Entering directory `/home/marko/src/4gl/aubit4glsrc/lib/libesql'
> /usr/bin/ecpg -C INFORMIX -t helper_funcs.ec
> gcc  -Wall -Wredundant-decls -Wmissing-declarations -Wmissing-prototypes
> -Wstrict-prototypes -g -O2 -DSRC_TREE -DDEBUG -DHAVE_CONFIG_H 
> -I/home/marko/src/4gl/aubit4glsrc/incl  -DDIALECT_POSTGRES -g -c -o
> helper_funcs_postgresql.o helper_funcs.c -I/usr/include -I/usr/include
> -I/usr/include -I/usr/include/postgresql -I../../incl helper_funcs.ec: In
> function `ESQLAPI_A4GL_copy_decimal':
> helper_funcs.ec:162: error: `CDECIMALTYPE' undeclared (first use in this
> function) helper_funcs.ec:162: error: (Each undeclared identifier is
> reported only once helper_funcs.ec:162: error: for each function it appears
> in.)
> helper_funcs.ec: In function `ESQLAPI_A4GL_copy_money':
> helper_funcs.ec:229: error: `CDECIMALTYPE' undeclared (first use in this
> function) helper_funcs.ec: In function `ESQLAPI_A4GL_copy_datetime':
> helper_funcs.ec:310: error: `CDTIMETYPE' undeclared (first use in this
> function) helper_funcs.ec: In function `ESQLAPI_A4GL_copy_char':
> helper_funcs.ec:482: error: `CCHARTYPE' undeclared (first use in this
> function) helper_funcs.ec: In function `ESQLAPI_A4GL_copy_date':
> helper_funcs.ec:523: error: `CDATETYPE' undeclared (first use in this
> function) helper_funcs.ec: In function `ESQLAPI_A4GL_copy_smint':
> helper_funcs.ec:561: error: `CSHORTTYPE' undeclared (first use in this
> function) helper_funcs.ec: In function `ESQLAPI_A4GL_copy_int':
> helper_funcs.ec:589: error: `CLONGTYPE' undeclared (first use in this
> function) helper_funcs.ec: In function `ESQLAPI_A4GL_copy_float':
> helper_funcs.ec:613: error: `CFLOATTYPE' undeclared (first use in this
> function) helper_funcs.ec: In function `ESQLAPI_A4GL_copy_double':
> helper_funcs.ec:637: error: `CDOUBLETYPE' undeclared (first use in this
> function) make[2]: *** [helper_funcs_postgresql.o] Error 1
> make[2]: Leaving directory `/home/marko/src/4gl/aubit4glsrc/lib/libesql'
> make[1]: *** [libESQL_POSTGRES.so] Error 2
> make[1]: Leaving directory `/home/marko/src/4gl/aubit4glsrc/lib'
> make: *** [corecompile] Error 2
>
>
> --------------------------------
>
> Debian's PostgreSQL 7.4.7
>
> $ grep -rl CDECIMALTYPE /usr/include/postgresql/
> /usr/include/postgresql/informix/esql/sqltypes.h
>
> Currenct PostgreSQL CVS:
>
> $ grep -rl CDECIMALTYPE /opt/pgsql8/include
> /opt/pgsql8/include/informix/esql/sqltypes.h
>
> ecpg seems to add it into it's own include path when
> -C INFORMIX, but this does not happen for gcc.  And
> where should it be included from?