Skip site navigation (1) Skip section navigation (2)

Re: interesting trigger behaviour in 8.3

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Ivan Zolotukhin <ivan(dot)zolotukhin(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: interesting trigger behaviour in 8.3
Date: 2008-07-29 15:33:22
Message-ID: 1217345602.666.108.camel@PCD12478 (view raw or flat)
Thread:
Lists: pgsql-general
On Tue, 2008-07-29 at 19:25 +0400, Ivan Zolotukhin wrote:
> Any clues? Can anybody suggest how to debug this? Is it possible to
> get an explain of the query within the trigger?

I bet it's the difference between prepared/not prepared plans. The
trigger prepares the plan without considering the actual parameter
values, on the psql prompt you give the parameter values explicitly in
the sql. Try to use the PREPARE command to prepare the plan on the psql
prompt, and EXPLAIN EXECUTE it to see how it works in the trigger...

Cheers,
Csaba.



In response to

pgsql-general by date

Next:From: Tom LaneDate: 2008-07-29 15:42:41
Subject: Re: What to do after an "ERROR: out of memory"
Previous:From: John ChengDate: 2008-07-29 15:29:24
Subject: What to do after an "ERROR: out of memory"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group