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(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