Hi fellows,<br /><br /> I'm getting problems compiling a trigger written in C (exactly the one from the documentation),
whencompiling it I get the errore shwoned here.<br /><br /> I think the problem might be the linker, but I don't know
howto fix it.<br /><br /> The command that I run was:<br /><br /> gcc -I /usr/include/postgresql/server prueba1.c<br
/><br/> And here is the error:<br /><br /> /usr/lib/gcc-lib/i486-linux/3.3.5/../../../crt1.o(.text+0x18): En la función
`_start':<br/> ../sysdeps/i386/elf/start.S:115: undefined reference to `main'<br /> /tmp/cc4DCNL5.o(.text+0x56): En la
función`trigf':<br /> : undefined reference to `errstart'<br /> /tmp/cc4DCNL5.o(.text+0x6a): En la función `trigf':<br
/>: undefined reference to `elog_finish'<br /> /tmp/cc4DCNL5.o(.text+0xd9): En la función `trigf':<br /> : undefined
referenceto `SPI_connect'<br /> /tmp/cc4DCNL5.o(.text+0x106): En la función `trigf':<br /> : undefined reference to
`errstart'<br/> /tmp/cc4DCNL5.o(.text+0x128): En la función `trigf':<br /> : undefined reference to `elog_finish'<br />
/tmp/cc4DCNL5.o(.text+0x13c):En la función `trigf':<br /> : undefined reference to `SPI_exec'<br />
/tmp/cc4DCNL5.o(.text+0x169):En la función `trigf':<br /> : undefined reference to `errstart'<br />
/tmp/cc4DCNL5.o(.text+0x18b):En la función `trigf':<br /> : undefined reference to `elog_finish'<br />
/tmp/cc4DCNL5.o(.text+0x19f):En la función `trigf':<br /> : undefined reference to `SPI_tuptable'<br />
/tmp/cc4DCNL5.o(.text+0x1ab):En la función `trigf':<br /> : undefined reference to `SPI_tuptable'<br />
/tmp/cc4DCNL5.o(.text+0x1b8):En la función `trigf':<br /> : undefined reference to `SPI_getbinval'<br />
/tmp/cc4DCNL5.o(.text+0x1e1):En la función `trigf':<br /> : undefined reference to `errstart'<br />
/tmp/cc4DCNL5.o(.text+0x203):En la función `trigf':<br /> : undefined reference to `elog_finish'<br />
/tmp/cc4DCNL5.o(.text+0x208):En la función `trigf':<br /> : undefined reference to `SPI_finish'<br />
/tmp/cc4DCNL5.o(.text+0x22f):En la función `trigf':<br /> : undefined reference to `SPI_getbinval'<br /> collect2: ld
devolvióel estado de salida 1<br /><br /> I'm running Debian-Sarge and I have postgresql, postgresql-dev,
postgresq-contribpackakes with gcc3.3, gcc3.3-base and libc6 installed on my machine.<br /><br /> Any help that you can
bringto me should be very helpfuly. Thanks in advance,<br /><br /> Rodolfo.<br />