Обсуждение: query path, and rules
Hey folks, I would like to learn more about execution path for a simple query, that is going to be changed by a rule. I want to find out, why output of 'affected rows' isn't always altered properly in rules rewriting inserts and updates. Can someone give me simple guide on where should I look, what functions is a query going through, etc, etc ? (based on cvs head). thanks.
On 2008-10-06, at 20:59, Grzegorz Jaskiewicz wrote: > Hey folks, > > I would like to learn more about execution path for a simple query, > that is going to be changed by a rule. I want to find out, why > output of 'affected rows' isn't always altered properly in rules > rewriting inserts and updates. > Can someone give me simple guide on where should I look, what > functions is a query going through, etc, etc ? > > (based on cvs head). I might say it wrong. I am looking for someone who could kindly walk me through query execution, in head code, especially in regard on how rules are applied. Please ?
This is not a support list. Sounds like you should consider purchasing a commercial support contract, or you could try asking on pgsql-general. ...Robert On Tue, Oct 7, 2008 at 4:30 PM, Grzegorz Jaskiewicz <gj@pointblue.com.pl> wrote: > > On 2008-10-06, at 20:59, Grzegorz Jaskiewicz wrote: > >> Hey folks, >> >> I would like to learn more about execution path for a simple query, that >> is going to be changed by a rule. I want to find out, why output of >> 'affected rows' isn't always altered properly in rules rewriting inserts and >> updates. >> Can someone give me simple guide on where should I look, what functions is >> a query going through, etc, etc ? >> >> (based on cvs head). > > I might say it wrong. > I am looking for someone who could kindly walk me through query execution, > in head code, especially in regard on how rules are applied. Please ? >
> > On 2008-10-06, at 20:59, Grzegorz Jaskiewicz wrote: > > > >> Hey folks, > >> > >> I would like to learn more about execution path for a simple query, that > >> is going to be changed by a rule. I want to find out, why output of > >> 'affected rows' isn't always altered properly in rules rewriting inserts and > >> updates. > >> Can someone give me simple guide on where should I look, what functions is > >> a query going through, etc, etc ? Robert Haas escribió: > This is not a support list. Sounds like you should consider > purchasing a commercial support contract, or you could try asking on > pgsql-general. Actually I find this to be a perfectly acceptable question for this list. ISTM the answer, however, is to have a look at the documentation we have already in place ... perhaps starting with the Developer's FAQ at http://wiki.postgresql.org/wiki/Developer_FAQ In particular, the question "How is the source code organized?" -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
On 2008-10-08, at 01:57, Alvaro Herrera wrote: >> > > Actually I find this to be a perfectly acceptable question for this > list. ISTM the answer, however, is to have a look at the > documentation > we have already in place ... perhaps starting with the Developer's FAQ > at http://wiki.postgresql.org/wiki/Developer_FAQ In particular, the > question "How is the source code organized?" Thanks, I'll read that through, and next time I'll just try to be more specific :)