subject:"\[GENERAL\] deleting rows with foreign keys"

Re: [GENERAL] deleting rows with foreign keys

2007-07-11 Thread Tom Lane

Tom Allison <[EMAIL PROTECTED]> writes: > I have ~250K rows in this table. > the token_idx is referenced in two other tables, both of whom have a > foreign key constraint to ON DELETE CASCADE. > Of the other two tables, one has ~1M rows and the other ~350K rows. > Problem: > Deleting one row

[GENERAL] deleting rows with foreign keys

2007-07-11 Thread Tom Allison

Here's my table: Table "public.tokens" Column |Type | Modifiers ---+- + token_idx | bigint