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: l...@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
