Home > mailing lists

Select Statement Hang... - Mailing list pgsql-novice

From	ttzhang
Subject	Select Statement Hang...
Date	July 20, 2003 05:20:09
Msg-id	3F1C6D6F@bearmail.berkeley.edu Whole thread Raw
List	pgsql-novice

Tree view

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!

pgsql-novice by date:

From: Alejandro Fuentes González
Date: 19 July 2003, 00:01:06
Subject: RE: [NOVICE] I´ve got problems when I try to use de psql

From: "Brian Johnson"
Date: 20 July 2003, 05:20:40
Subject: Cannot insert a duplicate key into unique index?

Select Statement Hang... - Mailing list pgsql-novice

Previous

Next