Sergey Burladyan <eshkinkot@gmail.com> writes:
> I install postgresql-server-dev-9.2 from
> 'deb http://apt.postgresql.org/pub/repos/apt/ squeeze-pgdg main'
> and try to build contrib module from 9.2 but it fault with error:
> ====
> $ make USE_PGXS=1 PG_CONFIG=/usr/lib/postgresql/9.2/bin/pg_config
> gcc -g -O2 -I/usr/include/mit-krb5 -fPIC -pie -DLINUX_OOM_ADJ=0
> -fno-omit-frame-pointer -I/usr/include/mit-krb5 -fPIC -pie
> -DLINUX_OOM_ADJ=0 -fno-omit-frame-pointer -Wall -Wmissing-prototypes
> -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels
> -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing
> -fwrapv -g -pthread -D_REENTRANT -D_THREAD_SAFE
> -D_POSIX_PTHREAD_SEMANTICS -I/usr/include/postgresql -I. -I./
> -I/usr/include/postgresql/9.2/server
> -I/usr/include/postgresql/internal -D_GNU_SOURCE
> -I/usr/include/libxml2 -I/usr/include/tcl8.5 -c -o pgbench.o
> pgbench.c
> In file included from pgbench.c:37:
> /usr/include/postgresql/libpq-fe.h:547: error: expected '=', ',', ';',
> 'asm' or '__attribute__' before 'lo_lseek64'
> /usr/include/postgresql/libpq-fe.h:551: error: expected '=', ',', ';',
> 'asm' or '__attribute__' before 'lo_tell64'
> /usr/include/postgresql/libpq-fe.h:553: error: expected declaration
> specifiers or '...' before 'pg_int64'
> make: *** [pgbench.o] Error 1
> ====
'lo_lseek64' didn't appear until 9.3, so you have a version skew here.
The problem is evidently the -I/usr/include/postgresql which is causing
it to pull in some installed copy of libpq-fe.h instead of the one that's
in your 9.2 tree.
regards, tom lane