Re: Any tutorial or FAQ on building an extension? - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Any tutorial or FAQ on building an extension?
Date
Msg-id 603c8f070908111432n79abc332kdd496f6e85d5a341@mail.gmail.com
Whole thread Raw
In response to Re: Any tutorial or FAQ on building an extension?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
On Tue, Aug 11, 2009 at 4:00 PM, Kevin
Grittner<Kevin.Grittner@wicourts.gov> wrote:
> Matt Culbreth <mattculbreth@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 specific advice.
> For example, I don't have a clue yet whether the query rewrite rules
> might satisfy your needs:
>
> http://www.postgresql.org/docs/8.4/interactive/sql-createrule.html

Yeah.  I suspect you are going to better off using some combination of
views, triggers, set-returning functions, and SQL-level permissions to
do whatever it is that you are trying to do here rather than inventing
a whole middleware layer.

...Robert


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Hot standby and synchronous replication status
Next
From: Robert Haas
Date:
Subject: Re: machine-readable explain output v4