Archive

Monthly Archives: December 2013

For me, pltoolbox is a great extension by Pavel Stehule. I have downloaded and built it on PostgreSQL 9.3.0 and come out with warnings:

warning: implicit declaration of function ‘HeapTupleHeaderGetTypeId’
warning: implicit declaration of function ‘HeapTupleHeaderGetTypMod’
warning: implicit declaration of function ‘HeapTupleHeaderGetDatumLength’

If I just simply ignore those warnings then SQL installation failed:

psql -f pltoolbox.sql -U postgres -h localhost -p 5432 -d targetdb
ERROR: could not load library “/opt/pgsql/9.3.0/lib/pltoolbox.so”: /opt/pgsql/9.3.0/lib/pltoolbox.so: undefined symbol: HeapTupleHeaderGetTypeId

The fix is just simply put include statement in “record.c”:

#include “access/htup_details.h”

After then, the package building and installation went smoothly.