Sergey Burladyan <eshkinkot@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general