On Fri, 2012-07-20 at 20:25 +0200, Maximilian Tyrtania wrote:
> Am 20.07.2012 um 18:36 schrieb Guillaume Lelarge:
>
> > Nope. I'm quite puzzled. Can you give me the result of these queries?
>
> Sure.
>
> > SELECT count(*) FROM pg_attribute
> > WHERE attrelid = 'pg_catalog.pg_proc'::regclass
> > AND attname = 'proargdefaults';
>
> 1
>
> >
> > and
> >
> > SELECT count(*) FROM pg_attribute
> > WHERE attrelid = 'pg_catalog.pg_proc'::regclass
> > AND attname = 'proargdefvals';
>
>
> 0
>
OK. Then, can you give me the results of this query?
SELECT pr.oid, pr.xmin, pr.*, format_type(TYP.oid, NULL) AS typname, typns.nspname AS typnsp, lanname, proargnames,
pg_get_expr(proargdefaults,'pg_catalog.pg_class'::regclass) AS
proargdefaultvals, pronargdefaults, proconfig,
pg_get_userbyid(proowner) as funcowner, description,
(SELECT array_agg(label) FROM pg_seclabels sl1 WHERE sl1.objoid=pr.oid)
AS labels,
(SELECT array_agg(provider) FROM pg_seclabels sl2 WHERE
sl2.objoid=pr.oid) AS providers FROM pg_proc pr JOIN pg_type typ ON typ.oid=prorettype JOIN pg_namespace typns ON
typns.oid=typ.typnamespaceJOIN pg_language lng ON lng.oid=prolang LEFT OUTER JOIN pg_description des ON
des.objoid=pr.oidWHEREproisagg = FALSE AND pronamespace = 2200::oid AND typname = 'trigger' AND lanname !=
'edbspl'ORDERBY proname;
Please, do it inside psql, and first fire a \x meta-command. And then
send the result as an attached file. Thank you.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com