On 11/03/2011 09:40 AM, Robert Haas wrote:
On Thu, Nov 3, 2011 at 11:31 AM, Rodrigo Gonzalez
<rjgonzale@xxxxxxxxxxxxxx> wrote:
El 03/11/11 11:42, Robert Haas escribió:
On Fri, Oct 28, 2011 at 9:39 AM, CS DBA<cs_dba@xxxxxxxxxxxxxxxxxxx> wrote:
No parameters, one of them looks like this:
[ code snippet ]
It's hard to believe this is the real code, because SELECT without
INTO will bomb out inside a PL/pgsql function, won't it?
But he's using CREATE TABLE xyz_view_m AS
So it seems correct to me
Oh, right, I missed that.
That seems pretty mysterious then. But is it possible the function is
getting called more times than it should? I notice that it's set up
as a trigger; is it FOR EACH ROW when it should be a statement-level
trigger or something like that? Maybe run EXPLAIN ANALYZE on the
query that's invoking the trigger to get some more detail on what's
going on?
I'll give it a shot ...
--
---------------------------------------------
Kevin Kempter - Constent State
A PostgreSQL Professional Services Company
www.consistentstate.com
---------------------------------------------
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
