Re: [HACKERS] query path, and rules

2008-10-07 Thread Grzegorz Jaskiewicz


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 ?


PGP.sig
Description: This is a digitally signed message part


Re: [HACKERS] query path, and rules

2008-10-07 Thread Robert Haas
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 [EMAIL PROTECTED] 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 ?


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


Re: [HACKERS] query path, and rules

2008-10-07 Thread Alvaro Herrera

  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 Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


Re: [HACKERS] query path, and rules

2008-10-07 Thread Grzegorz Jaskiewicz


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 :)




PGP.sig
Description: This is a digitally signed message part