Hi,
I tried make in the tablefunc directory under contrib directory in the Posgresql source directory.
I am getting compilation errors. Below are the error messages.
Can you tell me how to solve this problem. I want to use the crosstab function.
tablefunc.c: In function `crosstab':
tablefunc.c:413: warning: implicit declaration of function `ereport'
tablefunc.c:414: warning: implicit declaration of function `errcode'
tablefunc.c:414: `ERRCODE_INVALID_PARAMETER_VALUE' undeclared (first use in this function)
tablefunc.c:414: (Each undeclared identifier is reported only once
tablefunc.c:414: for each function it appears in.)
tablefunc.c:415: warning: implicit declaration of function `errmsg'
tablefunc.c:416: warning: implicit declaration of function `errdetail'
tablefunc.c:444: `ERRCODE_SYNTAX_ERROR' undeclared (first use in this function)
tablefunc.c: In function `crosstab_hash':
tablefunc.c:719: `ERRCODE_SYNTAX_ERROR' undeclared (first use in this function)
tablefunc.c: In function `load_categories_hash':
tablefunc.c:811: `ERRCODE_SYNTAX_ERROR' undeclared (first use in this function)
tablefunc.c:834: `ERRCODE_OUT_OF_MEMORY' undeclared (first use in this function)
tablefunc.c:834: `ERRCODE_DUPLICATE_OBJECT' undeclared (first use in this function)
tablefunc.c: In function `get_crosstab_tuplestore':
tablefunc.c:874: too many arguments to function `tuplestore_begin_heap'
tablefunc.c:914: `ERRCODE_INVALID_PARAMETER_VALUE' undeclared (first use in this function)
tablefunc.c:924: `ERRCODE_SYNTAX_ERROR' undeclared (first use in this function)
tablefunc.c: In function `connectby_text':
tablefunc.c:1086: `ERRCODE_SYNTAX_ERROR' undeclared (first use in this function)
tablefunc.c: In function `connectby':
tablefunc.c:1255: too many arguments to function `tuplestore_begin_heap'
tablefunc.c: In function `build_tuplestore_recursively':
tablefunc.c:1378: `ERRCODE_SYNTAX_ERROR' undeclared (first use in this function)
tablefunc.c: In function `validateConnectbyTupleDesc':
tablefunc.c:1527: `ERRCODE_SYNTAX_ERROR' undeclared (first use in this function)
tablefunc.c: In function `compatConnectbyTupleDescs':
tablefunc.c:1592: `ERRCODE_SYNTAX_ERROR' undeclared (first use in this function)
tablefunc.c: In function `compatCrosstabTupleDescs':
tablefunc.c:1628: `ERRCODE_SYNTAX_ERROR' undeclared (first use in this function)
thanks,
Kuldeep.
