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.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