"Scott Marlowe" <[EMAIL PROTECTED]> writes:
> On Wed, 2004-06-09 at 02:16, Mauri Sahlberg wrote:
>> It just took about three quarters of a hour to delete 6500 rows!
> Do you have any foreign key references that are of mismatched types
> involved?
Specifically, what other tables reference this one? Are their
referencing columns of identical types, and *do they have indexes*?
I'm betting on lack of index myself; that's the only FK mistake that
hurts you only at primary-key-delete time.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
