Scott Marlowe wrote:

<snip>

>make distclean
>./configure --with-pgpkglibdir=/usr/lib/postgresql/8.3/lib/
>--with-pgconfigdir=/usr/bin/pg_config
>make
>
>output was:
>
>make[1]: Entering directory `/home/dgish/slony1-1.2.21/src'
>make[2]: Entering directory `/home/dgish/slony1-1.2.21/src/xxid'
>gcc -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fpic
>-I../.. -I/usr/include/postgresql/
>-I/usr/include/postgresql/8.4/server/  -c -o xxid.o xxid.c>> Scott Marlowe wrote:


So is this 8.4 or 8.3 your compiling against? (note the 8.4 in the -I 
above).

Ubuntu allows both 8.4 and 8.3 to be installed at once (in theory). 
However when run /usr/lib/postgresql/8.3/bin/pg_config and 
/usr/lib/postgresql/8.4/bin/pg_config I see them both listing 
/usr/include/postgresql.   I'm not 100% sure which version 
/usr/include/postgresql/postgres.h is from

I'm thinking that the pg_config with ubuntu on multi-version 
installations is broken.  It seems to put the 8.4 files in 
include/postgresql but the 8.3 files (minus the libpq headers) in 
include/postgresql/8.3








>>> On Wed, Jul 21, 2010 at 12:04 PM, Steve Singer <ssinger at ca.afilias.info>
>>> wrote:
>>>> Scott Marlowe wrote:
>>>>> Note that this is with Ubuntu 10.04 with the karmic repo enabled to
>>>>> get pgsql 8.3 from there.
>>>> Do you have the postgresql-server-dev-8.3 package installed?
>>>> The ubuntu 9.x system I have access to puts the headers in that second
>>>> -server-dev package.  10.04 is probably the same.
>>> Yep.  Have that.  It won't get through ./configure without it.
>> Do they include pg_config? if so try passing
>> --with-pgconfigdir=/path/to/pg_config on the configure command line.
>>
>> It can't find xact.h which should be at include/server/access/xact.h
> 
> Getting the same error with that.  Here's what I tried:
> 
> make distclean
> ./configure --with-pgpkglibdir=/usr/lib/postgresql/8.3/lib/
> --with-pgconfigdir=/usr/bin/pg_config
> make
> 
> output was:
> 
> make[1]: Entering directory `/home/dgish/slony1-1.2.21/src'
> make[2]: Entering directory `/home/dgish/slony1-1.2.21/src/xxid'
> gcc -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -fpic
> -I../.. -I/usr/include/postgresql/
> -I/usr/include/postgresql/8.4/server/  -c -o xxid.o xxid.c
> xxid.c:18:25: error: access/xact.h: No such file or directory
> xxid.c:19:28: error: access/transam.h: No such file or directory
> xxid.c:20:26: error: executor/spi.h: No such file or directory
> xxid.c:52: warning: data definition has no type or storage class
> xxid.c:52: warning: type defaults to 'int' in declaration of
> 'PG_FUNCTION_INFO_V1'
> xxid.c:52: warning: parameter names (without types) in function declaration
> xxid.c:53: warning: data definition has no type or storage class
> xxid.c:53: warning: type defaults to 'int' in declaration of
> 'PG_FUNCTION_INFO_V1'
> xxid.c:53: warning: parameter names (without types) in function declaration
> xxid.c:54: warning: data definition has no type or storage class
> xxid.c:54: warning: type defaults to 'int' in declaration of
> 'PG_FUNCTION_INFO_V1'
> xxid.c:54: warning: parameter names (without types) in function declaration
> xxid.c:55: warning: data definition has no type or storage class
> xxid.c:55: warning: type defaults to 'int' in declaration of
> 'PG_FUNCTION_INFO_V1'
> xxid.c:55: warning: parameter names (without types) in function declaration
> xxid.c:56: warning: data definition has no type or storage class
> xxid.c:56: warning: type defaults to 'int' in declaration of
> 'PG_FUNCTION_INFO_V1'
> xxid.c:56: warning: parameter names (without types) in function declaration
> xxid.c:57: warning: data definition has no type or storage class
> xxid.c:57: warning: type defaults to 'int' in declaration of
> 'PG_FUNCTION_INFO_V1'
> xxid.c:57: warning: parameter names (without types) in function declaration
> xxid.c:58: warning: data definition has no type or storage class
> xxid.c:58: warning: type defaults to 'int' in declaration of
> 'PG_FUNCTION_INFO_V1'
> xxid.c:58: warning: parameter names (without types) in function declaration
> xxid.c:59: warning: data definition has no type or storage class
> xxid.c:59: warning: type defaults to 'int' in declaration of
> 'PG_FUNCTION_INFO_V1'
> xxid.c:59: warning: parameter names (without types) in function declaration
> xxid.c:60: warning: data definition has no type or storage class
> xxid.c:60: warning: type defaults to 'int' in declaration of
> 'PG_FUNCTION_INFO_V1'
> xxid.c:60: warning: parameter names (without types) in function declaration
> xxid.c:61: warning: data definition has no type or storage class
> xxid.c:61: warning: type defaults to 'int' in declaration of
> 'PG_FUNCTION_INFO_V1'
> xxid.c:61: warning: parameter names (without types) in function declaration
> xxid.c:62: warning: data definition has no type or storage class
> xxid.c:62: warning: type defaults to 'int' in declaration of
> 'PG_FUNCTION_INFO_V1'
> xxid.c:62: warning: parameter names (without types) in function declaration
> xxid.c:63: warning: data definition has no type or storage class
> xxid.c:63: warning: type defaults to 'int' in declaration of
> 'PG_FUNCTION_INFO_V1'
> xxid.c:63: warning: parameter names (without types) in function declaration
> xxid.c:64: warning: parameter names (without types) in function declaration
> xxid.c:65: warning: parameter names (without types) in function declaration
> xxid.c:66: warning: parameter names (without types) in function declaration
> xxid.c:67: warning: parameter names (without types) in function declaration
> xxid.c:68: warning: parameter names (without types) in function declaration
> xxid.c:69: warning: parameter names (without types) in function declaration
> xxid.c:70: warning: parameter names (without types) in function declaration
> xxid.c:71: warning: parameter names (without types) in function declaration
> xxid.c:72: warning: parameter names (without types) in function declaration
> xxid.c:73: warning: parameter names (without types) in function declaration
> xxid.c:74: warning: parameter names (without types) in function declaration
> xxid.c:75: warning: parameter names (without types) in function declaration
> xxid.c:77: warning: data definition has no type or storage class
> xxid.c:77: warning: type defaults to 'int' in declaration of
> 'PG_FUNCTION_INFO_V1'
> xxid.c:77: warning: parameter names (without types) in function declaration
> xxid.c:78: warning: data definition has no type or storage class
> xxid.c:78: warning: type defaults to 'int' in declaration of
> 'PG_FUNCTION_INFO_V1'
> xxid.c:78: warning: parameter names (without types) in function declaration
> xxid.c:79: warning: data definition has no type or storage class
> xxid.c:79: warning: type defaults to 'int' in declaration of
> 'PG_FUNCTION_INFO_V1'
> xxid.c:79: warning: parameter names (without types) in function declaration
> xxid.c:80: warning: data definition has no type or storage class
> xxid.c:80: warning: type defaults to 'int' in declaration of
> 'PG_FUNCTION_INFO_V1'
> xxid.c:80: warning: parameter names (without types) in function declaration
> xxid.c:81: warning: parameter names (without types) in function declaration
> xxid.c:82: warning: parameter names (without types) in function declaration
> xxid.c:83: warning: parameter names (without types) in function declaration
> xxid.c:84: warning: parameter names (without types) in function declaration
> xxid.c:92: warning: no previous prototype for '_Slony_I_xxidin'
> xxid.c: In function '_Slony_I_xxidin':
> xxid.c:94: warning: implicit declaration of function 'PG_GETARG_CSTRING'
> xxid.c:94: warning: initialization makes pointer from integer without a cast
> xxid.c: At top level:
> xxid.c:104: warning: no previous prototype for '_Slony_I_xxidout'
> xxid.c: In function '_Slony_I_xxidout':
> xxid.c:106: warning: implicit declaration of function 'PG_GETARG_DATUM'
> xxid.c:111: warning: implicit declaration of function 'PG_RETURN_CSTRING'
> xxid.c: At top level:
> xxid.c:119: warning: no previous prototype for '_Slony_I_xxideq'
> xxid.c: In function '_Slony_I_xxideq':
> xxid.c:124: warning: implicit declaration of function 'PG_RETURN_BOOL'
> xxid.c:124: warning: implicit declaration of function 'TransactionIdEquals'
> xxid.c: At top level:
> xxid.c:132: warning: no previous prototype for '_Slony_I_xxidne'
> xxid.c:145: warning: no previous prototype for '_Slony_I_xxidlt'
> xxid.c: In function '_Slony_I_xxidlt':
> xxid.c:153: warning: implicit declaration of function 'TransactionIdPrecedes'
> xxid.c: At top level:
> xxid.c:161: warning: no previous prototype for '_Slony_I_xxidle'
> xxid.c: In function '_Slony_I_xxidle':
> xxid.c:169: warning: implicit declaration of function
> 'TransactionIdPrecedesOrEquals'
> xxid.c: At top level:
> xxid.c:177: warning: no previous prototype for '_Slony_I_xxidgt'
> xxid.c: In function '_Slony_I_xxidgt':
> xxid.c:185: warning: implicit declaration of function 'TransactionIdFollows'
> xxid.c: At top level:
> xxid.c:193: warning: no previous prototype for '_Slony_I_xxidge'
> xxid.c: In function '_Slony_I_xxidge':
> xxid.c:201: warning: implicit declaration of function
> 'TransactionIdFollowsOrEquals'
> xxid.c: At top level:
> xxid.c:209: warning: no previous prototype for '_Slony_I_btxxidcmp'
> xxid.c: In function '_Slony_I_btxxidcmp':
> xxid.c:215: warning: implicit declaration of function 'PG_RETURN_INT32'
> xxid.c: At top level:
> xxid.c:227: warning: no previous prototype for '_Slony_I_getCurrentXid'
> xxid.c: In function '_Slony_I_getCurrentXid':
> xxid.c:229: warning: implicit declaration of function 'GetCurrentTransactionId'
> xxid.c: At top level:
> xxid.c:237: warning: no previous prototype for '_Slony_I_getMinXid'
> xxid.c: In function '_Slony_I_getMinXid':
> xxid.c:243: error: 'SerializableSnapshot' undeclared (first use in
> this function)
> xxid.c:243: error: (Each undeclared identifier is reported only once
> xxid.c:243: error: for each function it appears in.)
> xxid.c: At top level:
> xxid.c:254: warning: no previous prototype for '_Slony_I_getMaxXid'
> xxid.c: In function '_Slony_I_getMaxXid':
> xxid.c:259: error: 'SerializableSnapshot' undeclared (first use in
> this function)
> xxid.c: At top level:
> xxid.c:270: warning: no previous prototype for '_Slony_I_xxid_snapshot_in'
> xxid.c: In function '_Slony_I_xxid_snapshot_in':
> xxid.c:282: warning: initialization makes pointer from integer without a cast
> xxid.c:345: warning: implicit declaration of function 'PG_RETURN_POINTER'
> xxid.c: At top level:
> xxid.c:353: warning: no previous prototype for '_Slony_I_xxid_snapshot_out'
> xxid.c: In function '_Slony_I_xxid_snapshot_out':
> xxid.c:355: warning: implicit declaration of function 'PG_DETOAST_DATUM'
> xxid.c:355: warning: cast to pointer from integer of different size
> xxid.c: At top level:
> xxid.c:380: warning: no previous prototype for '_Slony_I_xxid_lt_snapshot'
> xxid.c: In function '_Slony_I_xxid_lt_snapshot':
> xxid.c:383: warning: cast to pointer from integer of different size
> xxid.c: At top level:
> xxid.c:406: warning: no previous prototype for '_Slony_I_xxid_ge_snapshot'
> xxid.c: In function '_Slony_I_xxid_ge_snapshot':
> xxid.c:409: warning: cast to pointer from integer of different size
> make[2]: *** [xxid.o] Error 1
> make[2]: Leaving directory `/home/dgish/slony1-1.2.21/src/xxid'
> make[1]: *** [all] Error 2
> make[1]: Leaving directory `/home/dgish/slony1-1.2.21/src'
> make: *** [all] Error 2
> 
> 
> I was under the impression that xxid didn't exist after pg 8.3 or so.


-- 
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142