pg_trigger
От | Alain Lavigne |
---|---|
Тема | pg_trigger |
Дата | |
Msg-id | B1C07EB3F38AD211B50A00105A0A97CD011778E5@EXCHANGE обсуждение исходный текст |
Список | pgsql-general |
Hi list, I'm trying to extract references between tables. Here is the sql: select u.usename, p.relname, v.usename, c.relname, t.tgconstrname, dumpref(t.tgargs, 4), dumpref(t.tgargs, 5) from pg_trigger t, pg_proc f, pg_class p, pg_class c, pg_user u, pg_user v where 1=1 and f.proname='RI_FKey_check_ins' and t.tgfoid=f.oid and c.oid=t.tgrelid and p.oid=t.tgconstrrelid and u.usesysid=p.relowner and v.usesysid=c.relowner; I always the following message: Error while executing the query; ERROR: Function 'dumpref(bytea, int4)' does not exist Unable to identify a function that satisfies the given argument types You may need to add explicit typecasts What am I doing wrong ?? Alain Lavigne - Data Administrator - ZAQ.iTv - E-Mail: alavigne@zaq.com 297 St-Paul, West - Montreal, Quebec, Canada - H2Y 2A5 Phone: 514-282-7073 ext: 371 Fax: 514-282-8011
В списке pgsql-general по дате отправления: