Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28])
	by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f0F0Jtp90377
	for <pgsql-sql@postgresql.org>; Sun, 14 Jan 2001 19:19:55 -0500 (EST)
	(envelope-from pgsql-sql-owner@postgresql.org)
Received: from zaq-msg-01.corp.zaq.com (firewall.zaq.com [205.205.200.101])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0CDZcp37797
	for <pgsql-sql@postgresql.org>; Fri, 12 Jan 2001 08:35:38 -0500 (EST)
	(envelope-from alavigne@zaq.com)
Received: by zaq-msg-01.corp.zaq.com with Internet Mail Service (5.5.2650.21)
	id <Y5ZQMBRX>; Fri, 12 Jan 2001 08:35:52 -0500
Message-ID: <B1C07EB3F38AD211B50A00105A0A97CD0117791F@EXCHANGE>
From: Alain Lavigne <alavigne@zaq.com>
To: "'pgsql-sql@postgresql.org'" <pgsql-sql@postgresql.org>
Subject: SQL question 
Date: Fri, 12 Jan 2001 08:36:29 -0500
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2650.21)
Content-Type: text/plain;
	charset="iso-8859-1"
X-Archive-Number: 200101/135
X-Sequence-Number: 796

I'm trying to extract references (relationships) between tables for the
purpose of reverse/forward engineer from a modeling tool called
PowerDesigner.  

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