| From: | Shaun Thomas <sthomas(at)optionshouse(dot)com> |
|---|---|
| To: | Larry Rosenman <ler(at)lerctr(dot)org> |
| 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:20:32 |
| Message-ID: | 518C1320.3070206@optionshouse.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
sthomas(at)optionshouse(dot)com
______________________________________________
See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email
--
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 | Tom Lane | 2013-05-09 21:22:03 | Re: LONG delete with LOTS of FK's |
| Previous Message | Tom Lane | 2013-05-09 21:11:43 | Re: Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4 |