Re: [GENERAL] Really strange foreign key constraint problem blocking delete

2014-10-06 Thread Tim Mickelson
width=530) (actual time=0.078..0.081 rows=1 loops=1)" " Index Cond: (idautenticazionesocial = 1622)" "Total runtime: 0.128 ms" On 07/10/2014 00:15, Jim Nasby wrote: > On 10/5/14, 10:06 AM, Andy Colson wrote: >> On 10/05/2014 10:00 AM, Adrian Klaver wrote: >>

Re: [GENERAL] Really strange foreign key constraint problem blocking delete

2014-10-06 Thread Tim Mickelson
:00 AM, Adrian Klaver wrote: >> On 10/05/2014 07:37 AM, Tim Mickelson wrote: >>> Sorry about that, the precise version is: "PostgreSQL 9.1.9 on >>> x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat >>> 4.4.7-3), 64-bit" >> &g

Re: [GENERAL] Really strange foreign key constraint problem blocking delete

2014-10-05 Thread Tim Mickelson
Sorry about that, the precise version is: "PostgreSQL 9.1.9 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-3), 64-bit" On 05/10/2014 15:54, Adrian Klaver wrote: > On 10/05/2014 04:03 AM, Tim Mickelson wrote: >> I can guarantee that t

Re: [GENERAL] Really strange foreign key constraint problem blocking delete

2014-10-05 Thread Tim Mickelson
I can guarantee that there is no entry in channel_mapping with idaut = 1622, it is first deleted. I've double checked, also because the error is indicating precisely this. The Postgresql Version is 9.1 On 04/10/2014 16:00, Adrian Klaver wrote: > On 10/03/2014 10:45 PM, Tim Mickels

Re: [GENERAL] Really strange foreign key constraint problem blocking delete

2014-10-05 Thread Tim Mickelson
Postgresql 9.1 On 04/10/2014 16:06, Andy Colson wrote: > On 10/04/2014 12:45 AM, Tim Mickelson wrote: >> But I don't think so, but here are the table defenitions: >> >> >> CREATE TABLE bulldog.channel_mapping >> ( >>idchannel integer NOT NULL, &g

Re: [GENERAL] Really strange foreign key constraint problem blocking delete

2014-10-03 Thread Tim Mickelson
ar > dependencies. > > On Fri, Oct 3, 2014 at 12:17 PM, Tim Mickelson > wrote: >> Even if I try to delete the data entry in the table channel_mapping with >> idaut 1622, it is not possible to delete from the table >> tmp_autenticazionesocial with the error below. How

[GENERAL] Really strange foreign key constraint problem blocking delete

2014-10-03 Thread Tim Mickelson
Even if I try to delete the data entry in the table channel_mapping with idaut 1622, it is not possible to delete from the table tmp_autenticazionesocial with the error below. How is this even possible since there is no channel_mapping with idaut 1622 any more?? I tried this in Java under a transac