From: | Larry Rosenman <ler(at)lerctr(dot)org> |
---|---|
To: | sthomas(at)optionshouse(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: LONG delete with LOTS of FK's |
Date: | 2013-05-09 21:22:22 |
Message-ID: | 0528544f2b1b6c12c68461b6518cb36b@webmail.lerctr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)lerctr(dot)org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | Larry Rosenman | 2013-05-09 21:23:07 | Re: LONG delete with LOTS of FK's |
Previous Message | Tom Lane | 2013-05-09 21:22:03 | Re: LONG delete with LOTS of FK's |