Обсуждение: Problem compiling tablefunc module in contributions
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)
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.
On Wed, Aug 27, 2003 at 04:57:04PM -0700, Kuldeep Tanna wrote: > 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' [...] Huh... are you using the CVS version of contrib/tablefunc and trying to compile against an older Postgres release? That won't work... they need to be from the same source tree. -- Alvaro Herrera (<alvherre[a]dcc.uchile.cl>) Licensee shall have no right to use the Licensed Software for productive or commercial use. (Licencia de StarOffice 6.0 beta)