Problem compiling tablefunc module in contributions

[Kuldeep Tanna]

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 inthis 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 inthis 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.

[Alvaro Herrera]

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)

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly