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
Show quoted text
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 :)