On 06/11/2014 11:35 AM, Tom Lane wrote:
Steve Crawford <scrawford@xxxxxxxxxxxxxxxxxxxx> writes:
I am getting the error following errors trying to install pg_repack via
pgxn on Ubuntu server 12.04.4 with all PostgreSQL packages from pgdg:
/usr/include/postgresql/libpq-fe.h:547:1: error: unknown type name
‘pg_int64’
That type name ought to be defined in postgres_ext.h, if it's of a similar
vintage to libpq-fe.h. I suspect you have a mishmash of Postgres
installations of different releases and the compiler is managing to find
the wrong version of postgres_ext.h to go with the libpq-fe.h it's
finding.
On that thread someone requested the output of "dpkg -l | grep postgres"
so I'll preemptively post it here:
[ lots of postgres 9.1 packages ]
Well, 9.1 didn't have pg_int64, but its libpq-fe.h didn't use that type
either. Whatever /usr/include/postgresql/libpq-fe.h is from, it's not
one of the packages you show here...
You were correct. I have:
/usr/include/postgresql/postgres_ext.h
/usr/include/postgresql/9.1/server/postgres_ext.h
Seems to be a packaging/dependency issue. I installed
postgresql-server-dev-9.1 (9.1.13-1.pgdg12.4+1) this morning which
installed, as a dependency, libpq-dev (9.3.4-1.pgdg12.4+1) which uses a
different directory convention for where to place postgres_ext.h. I
guess a forced downgrade of libpq/libpq-dev is in order.
Cheers,
Steve
