From: | Alain Lavigne <alavigne(at)zaq(dot)com> |
---|---|
To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
Subject: | pg_trigger |
Date: | 2000-12-06 16:23:26 |
Message-ID: | B1C07EB3F38AD211B50A00105A0A97CD011778E5@EXCHANGE |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)zaq(dot)com
297 St-Paul, West - Montreal, Quebec, Canada - H2Y 2A5
Phone: 514-282-7073 ext: 371
Fax: 514-282-8011
From | Date | Subject | |
---|---|---|---|
Next Message | George Johnson | 2000-12-06 16:27:56 | MySQL-esque sec_to_time() function |
Previous Message | Tom Lane | 2000-12-06 16:15:26 | Re: AW: beta testing version |