Re: [GENERAL] #include "executor/spi.h" throwing errors

2006-08-30 Thread Harpreet Dhaliwal
Problem was that i was using -L as in LEAMON, not I as in Indigo.Its working now. Martijn, thanks alot for your patience. I realy don't know why was I doing -L, actually i was thinkin of linking something. HUH. Had to include. Thanks alot once again~HarpreetOn 8/30/06, Martijn van Oosterhout

Re: [GENERAL] #include "executor/spi.h" throwing errors

2006-08-30 Thread Martijn van Oosterhout
On Wed, Aug 30, 2006 at 04:14:20AM -0400, Harpreet Dhaliwal wrote: > Did not understand about capital L and small L. > What should i be using, capital or small. Please use a font that distinguishes between I and l. It's capital I like in INDIGO. Not an L at all... > I also tried > gcc -I `pg_conf

Re: [GENERAL] #include "executor/spi.h" throwing errors

2006-08-30 Thread Harpreet Dhaliwal
Did not understand about capital L and small L. What should i be using, capital or small.I also tried gcc -I `pg_config --includedir-server` a.cand it still says executor/spi.h doesn't exist. On 8/30/06, Martijn van Oosterhout wrote: On Wed, Aug 30, 2006 at 03:53:13AM -0400, Har

Re: [GENERAL] #include "executor/spi.h" throwing errors

2006-08-30 Thread Martijn van Oosterhout
On Wed, Aug 30, 2006 at 03:53:13AM -0400, Harpreet Dhaliwal wrote: > Also, > Can you please email me ur directory structure, as in, absolute path > of a.cand absolute path of > spi.h. The absolute path of a.c is the irrelevent, it's in the current directory. executor/spi.h is in /usr/include/postg

Re: [GENERAL] #include "executor/spi.h" throwing errors

2006-08-30 Thread Harpreet Dhaliwal
Also, Can you please email me ur directory structure, as in, absolute path of a.c and absolute path of spi.h.Thanks,~HarpreetOn 8/30/06, Harpreet Dhaliwal <[EMAIL PROTECTED]> wrote: Also,a.c is at/usr/local/pgsql/hpsand sp.h is at/usr/include/pgsql/server/executorDoes that make a difference?Regard

Re: [GENERAL] #include "executor/spi.h" throwing errors

2006-08-30 Thread Harpreet Dhaliwal
Also,a.c is at/usr/local/pgsql/hpsand sp.h is at/usr/include/pgsql/server/executorDoes that make a difference?Regards,~harpreetOn 8/30/06, Harpreet Dhaliwal <[EMAIL PROTECTED]> wrote: Also, Where should the directoriresexecutor, nodes, utils, access, catalog be? Over here, its searching it in /usr

Re: [GENERAL] #include "executor/spi.h" throwing errors

2006-08-30 Thread Harpreet Dhaliwal
Also, Where should the directoriresexecutor, nodes, utils, access, catalog be? Over here, its searching it in /usr/includeHowever, these files are located at /usr/include/pgsql/server/When i copy these directories to /usr/include, it throws the error that I posted in the form of a file a minute ag

Re: [GENERAL] #include "executor/spi.h" throwing errors

2006-08-30 Thread Martijn van Oosterhout
On Wed, Aug 30, 2006 at 02:59:45AM -0400, Harpreet Dhaliwal wrote: > Can you please email me your spi.h. > Need to see the path of other header files that spi.h includes and compare > it with what i have. Perhaps you should post some of the actual errors you're getting? http://developer.postgresq

Re: [GENERAL] #include "executor/spi.h" throwing errors

2006-08-30 Thread Harpreet Dhaliwal
Can you please email me your spi.h. Need to see the path of other header files that spi.h includes and compare it with what i have.~HarpreetOn 8/30/06, Harpreet Dhaliwal <[EMAIL PROTECTED]> wrote: Now i did something like this$ cat a.c#include $ gcc -I /usr/include/pgsql/server -c a.c$still gettin

Re: [GENERAL] #include "executor/spi.h" throwing errors

2006-08-29 Thread Harpreet Dhaliwal
Now i did something like this$ cat a.c#include $ gcc -I /usr/include/pgsql/server -c a.c$still getting the same errors.The only difference between your and my code being /usr/include/postgresql/server and /usr/include/pgsql/server On 8/30/06, Martijn van Oosterhout wrote: On Wed

Re: [GENERAL] #include "executor/spi.h" throwing errors

2006-08-29 Thread Martijn van Oosterhout
On Wed, Aug 30, 2006 at 02:16:36AM -0400, Harpreet Dhaliwal wrote: > Hi, > I'm trying to use SPI for database connectivity at the server side. > This throws hell lot of errors (hundreds of them), even if i don't have any > SPI code in my C file as of now. > > Can anyone please tell me whats goi

[GENERAL] #include "executor/spi.h" throwing errors

2006-08-29 Thread Harpreet Dhaliwal
Hi,I'm trying to use SPI for database connectivity at the server side.My database is intialized at /usr/local/pgsql/hpsspi.h is at the follwoing location/usr/include/pgsql/server/executor. I have a C file that has the SPI code and is located at /usr/local/pgsql/hpsI thin file i do #include "executo