[HACKERS] Any tutorial or FAQ on building an extension?

2009-08-11 Thread Matt Culbreth
Hello Group, I'd like to build an extension to PostgreSQL. It will intercept queries and perform some transformations on the query and on the data returned, given some business rules that the users have specified. What's the best way to do this? It seems like if I model the pgpool- II

Re: [HACKERS] Any tutorial or FAQ on building an extension?

2009-08-11 Thread Josh Berkus
Is there an easier way of going about this other than replacing the postmaster / postgres components? I'd start with creating my own extended version to psql (the client library), I suppose. But since I don't really know what kind of transformations you have in mind, any advice is going to be

Re: [HACKERS] Any tutorial or FAQ on building an extension?

2009-08-11 Thread Matt Culbreth
On Aug 11, 1:11 pm, j...@agliodbs.com (Josh Berkus) wrote: Is there an easier way of going about this other than replacing the postmaster / postgres components? I'd start with creating my own extended version to psql (the client library), I suppose.  But since I don't really know what kind

Re: [HACKERS] Any tutorial or FAQ on building an extension?

2009-08-11 Thread Kevin Grittner
Matt Culbreth mattculbr...@gmail.com wrote: My new component intercepts this, and decides if it wants to do something If it does, it passes the request over to my new server (via sockets), does its work, and pass back the results That's still too vague to allow people to give very

Re: [HACKERS] Any tutorial or FAQ on building an extension?

2009-08-11 Thread Robert Haas
On Tue, Aug 11, 2009 at 4:00 PM, Kevin Grittnerkevin.gritt...@wicourts.gov wrote: Matt Culbreth mattculbr...@gmail.com wrote: My new component intercepts this, and decides if it wants to do something If it does, it passes the request over to my new server (via sockets), does its work, and