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

2010-01-23 Thread Dimitri Fontaine
Ivan Sergio Borgonovo 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 didn't have postg

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 wrote: > Ivan Sergio Borgonovo 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

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

2010-01-22 Thread Tom Lane
Ivan Sergio Borgonovo 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: http://www.postgresql.org/

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 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 easily on Deb

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 fa

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 get

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 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 entry in pg C coding

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

2010-01-20 Thread Pavel Stehule
2010/1/20 Ivan Sergio Borgonovo : > On Wed, 20 Jan 2010 16:56:04 +0100 > Dimitri Fontaine wrote: > >> Ivan Sergio Borgonovo 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: >>   ht

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 wrote: > Ivan Sergio Borgonovo 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_20

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

2010-01-20 Thread Dimitri Fontaine
Ivan Sergio Borgonovo 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 Regards, -- dim -- S

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

2010-01-20 Thread Pavel Stehule
2010/1/20 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. look on contrib director

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 : > I haven't been able to find anything better

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

2010-01-20 Thread Vincenzo Romano
2010/1/20 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 s