Re: default parameters

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.typnamespace
JOIN pg_language lng ON lng.oid=prolang
LEFT OUTER JOIN pg_description des ON des.objoid=pr.oid
WHERE proisagg = FALSE AND pronamespace = 2200::oid
AND typname = 'trigger'
AND lanname != 'edbspl'
ORDER BY 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