SUBDIRS = src/include src/lib src/preproc

allinstalluninstallclean::

foriin$(SUBDIRS);do (cd$$i; make$@ );done

This list is still from Linus. MM

The variables should be static.

The preprocessor interface is strange, to say the least It would be better

with a consistant unix arguments interface, perhaps builtin default

filenames so they won't have to be given all the time.

Preprocessor cannot do syntax checking on your SQL statements Whatever you

write is copied more or less exactly to the postgres95 and you will not be

able to locate your errors until run-time.

No restriction to strings only The PQ interface, and most of all the PQexec

function, that is used by the ecpg relies on that the request is built up as

a string. In some cases, like when the data contains the null character,

this will be a serious problem.

There should be different error numbers for the different errors instead of

just -1 for them all.

Missing library functions to_date et al.

Possibility to define records or structs in the declare section in a way

that the record can be filled from one row in the database. This is a

simpler way to handle an entire row at a time.

Oracle has array operations that enhances speed. When implementing it in

ecpg it is done for compatibility reasons only. For them to improve speed

would require a lot more insight in the postgres internal mechanisms than I

possess.

Oracle has indicator variables that tell if a value is null or if it is

empty. This largely simplifies array operations and provides for a way to

hack around some design flaws in the handling of VARCHAR2 (like that an

empty string isn't distinguishable from a null value). I am not sure if this

is an Oracle extension or part of the ANSI standard.

As well as complex types like records and arrays, typedefs would be a good

thing to take care of.

To set up a database you need a few scripts with table definitions and other

configuration parameters. If you have these scripts for an old database you

would like to just apply them to get a postgres database that works in the

same way. The functionality could be accomplished with some conversion

scripts. Speed will never be accomplished in this way. To do this you need a

bigger insight in the database construction and the use of the database than

could be realised in a script.

# This file is a shell script that caches the results of configure

# tests run on this system so they can be shared between configure

# scripts and configure runs. It is not useful on other systems.

# If it contains results you don't want to keep, you may remove or edit it.

#

# By default, configure uses ./config.cache as the cache file,

# creating it if it does not exist already. You can give configure

# the --cache-file=FILE option to use a different cache file; that is

# what configure does when it calls configure scripts in

# subdirectories, so they share the cache.

# Giving --cache-file=/dev/null disables caching, for debugging configure.

# config.status only pays attention to the cache file if you give it the

# --recheck option to rerun configure.

#

ac_cv_lib_fl_yywrap=${ac_cv_lib_fl_yywrap=yes}

ac_cv_prog_CC=${ac_cv_prog_CC=gcc}

ac_cv_prog_LEX=${ac_cv_prog_LEX=flex}

ac_cv_prog_YACC=${ac_cv_prog_YACC='bison -y'}

ac_cv_prog_cc_cross=${ac_cv_prog_cc_cross=no}

ac_cv_prog_cc_g=${ac_cv_prog_cc_g=yes}

ac_cv_prog_cc_works=${ac_cv_prog_cc_works=yes}

ac_cv_prog_gcc=${ac_cv_prog_gcc=yes}

This file contains any messages produced by compilers while

running configure, to aid debugging if configure makes a mistake.

configure:526: checking for gcc

configure:603: checking whether the C compiler (gcc ) works

configure:617: gcc -o conftest conftest.c 1>&5

configure:637: checking whether the C compiler (gcc ) is a cross-compiler

configure:642: checking whether we are using GNU C

configure:666: checking whether gcc accepts -g

configure:696: checking for flex

configure:729: checking for yywrap in -lfl

configure:775: checking for bison

ac_cs_usage="Usage: ./config.status [--recheck] [--version] [--help]"

for ac_option

-recheck | --recheck | --rechec | --reche | --rech | --rec | --re | --r)

exec${CONFIG_SHELL-/bin/sh} ./configure --no-create --no-recursion ;;

-version | --version | --versio | --versi | --vers | --ver | --ve | --v)

exit 0 ;;

-help | --help | --hel | --he | --h)

echo"$ac_cs_usage";exit 0 ;;

*)echo"$ac_cs_usage";exit 1 ;;

ac_given_srcdir=.

trap'rm -fr src/include/Makefile src/lib/Makefile src/preproc/Makefile src/preproc/ecpg conftest*; exit 1' 1 2 15

sed's/%@/@@/; s/@%/@@/; s/%g$/@g/; /@g$/s/[\\&%]/\\&/g;

s/@@/%@/; s/@@/@%/; s/@g$/%g/'> conftest.subs<<\CEOF

ac_max_sed_cmds=90# Maximum number of lines to put in a sed script.

ac_file=1# Number of current file.

ac_beg=1# First line for current file.

ac_end=$ac_max_sed_cmds# Line after last line for current file.

ac_more_lines=:

ac_sed_cmds=""

iftest$ac_beg -gt 1;then

sed"1,${ac_beg}d;${ac_end}q" conftest.subs> conftest.s$ac_file

sed"${ac_end}q" conftest.subs> conftest.s$ac_file

iftest! -s conftest.s$ac_file;then

ac_more_lines=false

rm -f conftest.s$ac_file

iftest -z"$ac_sed_cmds";then

ac_sed_cmds="sed -f conftest.s$ac_file"

ac_sed_cmds="$ac_sed_cmds | sed -f conftest.s$ac_file"

ac_file=`expr$ac_file + 1`

ac_beg=$ac_end

ac_end=`expr$ac_end +$ac_max_sed_cmds`

iftest -z"$ac_sed_cmds";then

ac_sed_cmds=cat

CONFIG_FILES=${CONFIG_FILES-"src/include/Makefile src/lib/Makefile src/preproc/Makefile src/preproc/ecpg"}

forac_filein ..$CONFIG_FILES;doiftest"x$ac_file"!= x..;then

*:*) ac_file_in=`echo"$ac_file"|sed's%[^:]*:%%'`

ac_file=`echo"$ac_file"|sed's%:.*%%'` ;;

*) ac_file_in="${ac_file}.in" ;;

ac_dir=`echo$ac_file|sed's%/[^/][^/]*$%%'`

iftest"$ac_dir"!="$ac_file"&&test"$ac_dir"!=.;then

test! -d"$ac_dir"&& mkdir"$ac_dir"

ac_dir_suffix="/`echo$ac_dir|sed's%^\./%%'`"

ac_dots=`echo$ac_dir_suffix|sed's%/[^/]*%../%g'`

ac_dir_suffix= ac_dots=

.) srcdir=.

iftest -z"$ac_dots";then top_srcdir=.

else top_srcdir=`echo$ac_dots|sed's%/$%%'`;fi ;;

/*) srcdir="$ac_given_srcdir$ac_dir_suffix"; top_srcdir="$ac_given_srcdir" ;;

*)# Relative path.

srcdir="$ac_dots$ac_given_srcdir$ac_dir_suffix"

top_srcdir="$ac_dots$ac_given_srcdir" ;;

echo creating"$ac_file"

rm -f"$ac_file"

configure_input="Generated automatically from`echo$ac_file_in|sed's%.*/%%'` by configure."

*Makefile*) ac_comsub="1i\\

#$configure_input" ;;

*) ac_comsub= ;;

ac_file_inputs=`echo$ac_file_in|sed -e"s%^%$ac_given_srcdir/%" -e"s%:%$ac_given_srcdir/%g"`

sed -e"$ac_comsub

"$ac_file_inputs| (eval"$ac_sed_cmds")>$ac_file

rm -f conftest.s*

exit 0