Wang, Mary Y wrote:
Richard, Thank you so MUCH. I was able to delete the record by using the OID method that you mentioned in (2).
Well, if the column I mentioned in (1) is integer/bigint, then you'll want to do (3) as well and reindex.
-- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match