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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
