Re: [GENERAL] include all the postgres libraries (C)

I think PGXS is, what I've been looking for.   My Makefile looks like this:  PROGRAM = test DATA = "">  PG_CONFIG = pg_config PGXS := $(shell $(PG_CONFIG) --pgxs) include $(PGXS)   The file test.c only includes the postgres.h, but I get this error, when compiling: /usr/bin/ld: cannot find

Re: [GENERAL] include all the postgres libraries (C)

Janek Sendrowski wrote: > Hi, >   > I like to try some things with C and I need certain postgres libraries for it. > This time, I'm including postgres.h for example, but postgres.h doesn't > include it's files. > How do I include the whole tree, or is there a certain directory I can use. > I just

Re: [GENERAL] include all the postgres libraries (C)

Janek Sendrowski wrote: > I like to try some things with C and I need certain postgres libraries for it. > This time, I'm including postgres.h for example, but postgres.h doesn't > include it's files. > How do I include the whole tree, or is there a certain directory I can use. > I just want to c

[GENERAL] include all the postgres libraries (C)

Hi,   I like to try some things with C and I need certain postgres libraries for it. This time, I'm including postgres.h for example, but postgres.h doesn't include it's files. How do I include the whole tree, or is there a certain directory I can use. I just want to compile and run the files for

Re: [GENERAL] include directives in postgresql.conf

On 2 July 2011 10:42, AI Rumman wrote: > Can anyone please tell me that how to use 'include directives' in > Postgresql.conf? > http://www.postgresql.org/docs/8.4/interactive/config-setting.html Well it's quite clear from the documentation. It's just: include 'filename' So if you have a config

[GENERAL] include directives in postgresql.conf

Can anyone please tell me that how to use 'include directives' in Postgresql.conf? http://www.postgresql.org/docs/8.4/interactive/config-setting.html -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsq

[GENERAL] include source file from another language into function body?

Hi, Is there an accepted way to load code in another language into a PostgreSQL function body? This would be really nice in several ways, for example: to run a code checker outside of postgresql, and to make things easier for source code colorizers. I have in mind something like ==

Re: [GENERAL] #include

Heres an interesting hack I just thought of that works: extern "C" { #include #include #define using _using #define typeid _typeid #define typename _typename #include #undef using #undef typeid #undef typename #ifd

Re: [GENERAL] #include

On 12/26/2010 02:14 PM, Elliot Chance wrote: In file included from /usr/include/pgsql/server/access/heapam.h:21, from /usr/include/pgsql/server/nodes/execnodes.h:18, from /usr/include/pgsql/server/executor/execdesc.h:18, from /usr/include/pgs

[GENERAL] #include

Hi everyone, >From what i've read in the documentation you need funcapi.h to return SETOF >from a C function, the problem is when I include the header file the compile >throws heaps of errors; offending code 1. extern "C" { 2. #include 3. #include 4. #include 5. 6. #ifdef

Re: [GENERAL] Include script within a script

Bill Todd wrote: > Is there any mechanism to include (call) one SQL script file from another? You can use \i Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would rec

[GENERAL] Include script within a script

Is there any mechanism to include (call) one SQL script file from another? Bill -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] include PostgreSQL utilities into 3rd party program package

Michael Raven wrote: Hello everybody. I've got some kind of PostgreSQL copyright related question. Our company is developing an commercial product for PostgreSQL administration. We want to include some utilities (i.e. pg_dump.exe, pg_restore.exe etc) from PostgreSQL for Windows installation pac

[GENERAL] include PostgreSQL utilities into 3rd party program package

Hello everybody. I've got some kind of PostgreSQL copyright related question. Our company is developing an commercial product for PostgreSQL administration. We want to include some utilities (i.e. pg_dump.exe, pg_restore.exe etc) from PostgreSQL for Windows installation package to installation pa

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

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

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

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

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

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

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

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

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

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

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

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

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