Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group