Thanks that worked, but why does that happen or maybe you could point to the proper
thread so I read up on it.
Alain Lavigne - Data Administrator - ZAQ Interactive Solutions E-Mail:
[EMAIL PROTECTED
..2264.16 rows=1 width=8)
EXPLAIN
I don't understand why it's not using the defined index, even after performing VACUUM
FULL ANALYZE on the table.
I tried disabling seqscan but that didn't change anything.
I'm open to suggestions anyone
Thanks!
---
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), **
casts >>
What am I doing wrong ??
Alain Lavigne - Data Administrator - ZAQ.iTv - E-Mail: [EMAIL PROTECTED]
297 St-Paul, West - Montreal, Quebec, Canada - H2Y 2A5
Phone: 514-282-7073 ext: 371
Fax: 514-282-8011
