Re: [GENERAL] more docs on extending postgres in C

2010-01-23 Thread Dimitri Fontaine
Ivan Sergio Borgonovo m...@webthatworks.it writes: - installing postgresql-server-dev-[version] - apt-get source postgresql-server-dev-[version] - copy from there a contrib dir in my ~ (or wherever you prefer) - export USE_PGXS=1; make Don't forget apt-get build-dep postgresql-[version] I

Re: [GENERAL] more docs on extending postgres in C

2010-01-22 Thread Ivan Sergio Borgonovo
On Wed, 20 Jan 2010 17:43:27 +0100 Adrian von Bidder avbid...@fortytwo.ch wrote: On Wednesday 20 January 2010 15.42:14 Ivan Sergio Borgonovo wrote: I'd also appreciate some suggestion about dev environment and best practices on Debian, something that could help me to compile, install, test

Re: [GENERAL] more docs on extending postgres in C

2010-01-22 Thread Tom Lane
Ivan Sergio Borgonovo m...@webthatworks.it writes: If I had to build stuff in the pg source tree I'd just clone a contrib directory and change the makefile [1]. What am I supposed to do if I'd like to create a contrib elsewhere (eg. ~/Documents/nfs/projects/ts_extensions)? Use PGXS:

Re: [GENERAL] more docs on extending postgres in C

2010-01-22 Thread Ivan Sergio Borgonovo
On Fri, 22 Jan 2010 11:02:46 -0500 Tom Lane t...@sss.pgh.pa.us wrote: Ivan Sergio Borgonovo m...@webthatworks.it writes: If I had to build stuff in the pg source tree I'd just clone a contrib directory and change the makefile [1]. What am I supposed to do if I'd like to create a contrib

[GENERAL] more docs on extending postgres in C

2010-01-20 Thread Ivan Sergio Borgonovo
I haven't been able to find anything better than the online manual and pg source code to learn how to write extensions. I couldn't find a reference of all the function/macros I could use and some more examples on how to use them. I'd also appreciate some suggestion about dev environment and best

Re: [GENERAL] more docs on extending postgres in C

2010-01-20 Thread Vincenzo Romano
2010/1/20 Ivan Sergio Borgonovo m...@webthatworks.it: I haven't been able to find anything better than the online manual and pg source code to learn how to write extensions. I couldn't find a reference of all the function/macros I could use and some more examples on how to use them. I'd

Re: [GENERAL] more docs on extending postgres in C

2010-01-20 Thread Pavel Stehule
Hello I wrote one article some years ago http://www.postgres.cz/index.php/Project_of_UDF_and_its_realization_at_C_for_PostgreSQL The core is correct, but there are some issues, it is for 8.0. regards Pavel Stehule 2010/1/20 Ivan Sergio Borgonovo m...@webthatworks.it: I haven't been able to

Re: [GENERAL] more docs on extending postgres in C

2010-01-20 Thread Pavel Stehule
2010/1/20 Ivan Sergio Borgonovo m...@webthatworks.it: I haven't been able to find anything better than the online manual and pg source code to learn how to write extensions. I couldn't find a reference of all the function/macros I could use and some more examples on how to use them. look on

Re: [GENERAL] more docs on extending postgres in C

2010-01-20 Thread Dimitri Fontaine
Ivan Sergio Borgonovo m...@webthatworks.it writes: I haven't been able to find anything better than the online manual and pg source code to learn how to write extensions. Maybe this will help: http://wiki.postgresql.org/wiki/Image:Prato_2008_prefix.pdf http://github.com/dimitri/prefix

Re: [GENERAL] more docs on extending postgres in C

2010-01-20 Thread Ivan Sergio Borgonovo
On Wed, 20 Jan 2010 16:56:04 +0100 Dimitri Fontaine dfonta...@hi-media.com wrote: Ivan Sergio Borgonovo m...@webthatworks.it writes: I haven't been able to find anything better than the online manual and pg source code to learn how to write extensions. Maybe this will help:

Re: [GENERAL] more docs on extending postgres in C

2010-01-20 Thread Pavel Stehule
2010/1/20 Ivan Sergio Borgonovo m...@webthatworks.it: On Wed, 20 Jan 2010 16:56:04 +0100 Dimitri Fontaine dfonta...@hi-media.com wrote: Ivan Sergio Borgonovo m...@webthatworks.it writes: I haven't been able to find anything better than the online manual and pg source code to learn how to

Re: [GENERAL] more docs on extending postgres in C

2010-01-20 Thread Ivan Sergio Borgonovo
On Wed, 20 Jan 2010 17:38:17 +0100 Pavel Stehule pavel.steh...@gmail.com wrote: Is there a reference of all macro and functions? no, only source code It would be nice to at least a list of functions that could be used in extension development to avoid reading all the source. Since I'm a new

Re: [GENERAL] more docs on extending postgres in C

2010-01-20 Thread Greg Smith
Ivan Sergio Borgonovo wrote: It would be nice to at least a list of functions that could be used in extension development to avoid reading all the source. psql -E \df * This will dump out a list of all the built-in functions in the server. It will also show you the query that did so, I

Re: [GENERAL] more docs on extending postgres in C

2010-01-20 Thread Adrian von Bidder
On Wednesday 20 January 2010 15.42:14 Ivan Sergio Borgonovo wrote: I'd also appreciate some suggestion about dev environment and best practices on Debian, something that could help me to compile, install, test easily on Debian. (Disclaimer: Haven't done any postgres related programming so far,