Re: Any tutorial or FAQ on building an extension?

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: Matt Culbreth <mattculbreth(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Any tutorial or FAQ on building an extension?
Date: 2009-08-11 21:32:01
Message-ID: 603c8f070908111432n79abc332kdd496f6e85d5a341@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Aug 11, 2009 at 4:00 PM, Kevin
Grittner<Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> Matt Culbreth <mattculbreth(at)gmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2009-08-11 21:38:33 Re: machine-readable explain output v4
Previous Message Robert Haas 2009-08-11 21:30:57 Re: Hot standby and synchronous replication status