Re: LONG delete with LOTS of FK's

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@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893