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
Message-ID: <B1C07EB3F38AD211B50A00105A0A97CD0117791F@EXCHANGE> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: alavigne@zaq.com
Subject: Re: SQL question
In-Reply-To: <B1C07EB3F38AD211B50A00105A0A97CD0117791F@EXCHANGE>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox