usage of pg_get_functiondef() -- SQL state 42809 - Mailing list pgsql-general

From
Subject usage of pg_get_functiondef() -- SQL state 42809
Date
Msg-id F3CBFBA88397EA498B22A05FFA9EC49D697BA937@MX22A.corp.emc.com
Whole thread Raw
Responses Re: usage of pg_get_functiondef() -- SQL state 42809  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
-- This works.

select
  TRG.tgname,  TFX.proname,  pg_get_functiondef(TFX.oid) as fdef
from
  pg_trigger         TRG
  inner join pg_proc TFX on TFX.oid = TRG.tgfoid
where
  TRG.tgisinternal = true


-- This blows up.  -- SQL state: 42809 -- ERROR: "array_agg" is an aggregate function

select
  TRG.tgname,  TFX.proname,  pg_get_functiondef(TFX.oid) as fdef
from
  pg_trigger         TRG
  inner join pg_proc TFX on TFX.oid = TRG.tgfoid
where
  TRG.tgisinternal = true
  and
  pg_get_functiondef(TFX.oid) = 'whatever'


Can you help me understand why this blows up ?
I am running "PostgreSQL 9.1.2, compiled by Visual C++ build 1500, 64-bit"

-dvs-


pgsql-general by date:

Previous
From: Lonni J Friedman
Date:
Subject: Re: pg_upgrade + streaming replication ?
Next
From: Mike Christensen
Date:
Subject: Re: current thinking on Amazon EC2?