Select Statement Hang...

From: ttzhang <ttzhang(at)uclink(dot)berkeley(dot)edu>
To: pgsql-novice(at)postgresql(dot)org
Subject: Select Statement Hang...
Date: 2003-07-13 20:49:52
Message-ID: 3F1C6D6F@bearmail.berkeley.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I was trying to set up a foreign key for an id field but found out that some
of the ids are not in the referenced table. To look things up, I tried

select id from btable where id not in (select id from atable)

The query just hang..... My tables are pretty big (200, 000?) can anyone
help me to pinpoint the problem?

Thanks!

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Rasputin 2003-07-14 13:16:21 Practical SQL Handbook
Previous Message Kim Henderson 2003-07-13 04:08:01 Where do I get LIBPQEASY?