On 2013-05-09 16:20, Shaun Thomas wrote:
On 05/09/2013 03:58 PM, Larry Rosenman wrote: "SELECT 1 FROM ONLY "public"."ibmgbs_values" x WHERE $1 OPERATOR(pg_catalog.=) "account_id" FOR SHARE OF x" This is the statement it canceled on. I've found that when long deletes like this happen, it's because of the statement that you see when you cancel. Something tells me that if you try this again, it'll be the same foreign key check. Look and make sure account_id in ibmgbs_values is the same exact type as the referenced table.
it is: druckerdb=> \d ibmgbs_values Table "public.ibmgbs_values" Column | Type | Modifiers -------------------+-----------------------------+----------- account_id | bigint | not null All are bigints. It's been on various tables, and they are all bigints. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 214-642-9640 (c) E-Mail: ler@xxxxxxxxxx US Mail: 430 Valona Loop, Round Rock, TX 78681-3893 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
