From: | Clodoaldo <clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Deleting a row leads to crash 1.6.2 |
Date: | 2007-01-19 11:55:40 |
Message-ID: | a595de7a0701190355i7b1a2544p28ffd6e727b48cc3@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
2007/1/19, Clodoaldo <clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com>:
> 2007/1/19, Dave Page <dpage(at)postgresql(dot)org>:
> > Clodoaldo wrote:
> > > 2007/1/18, Dave Page <dpage(at)postgresql(dot)org>:
> > >>
> > >>
> > >> > ------- Original Message -------
> > >> > From: Laurent ROCHE <laurent_roche(at)yahoo(dot)com>
> > >> > To: pgadmin-support(at)postgresql(dot)org
> > >> > Sent: 1/18/07, 7:21:35 PM
> > >> > Subject: [pgadmin-support] Crash and sending report !
> > >> >
> > >> > Hi,
> > >> >
> > >> > When ever there's a crash (it's about every other time ... when I
> > >> close PG Admin ... so no big deal ;-) !) is it worth me sending the
> > >> report to Microsoft ?
> > >> > Does it get to the PG Admin people in the end ?
> > >> >
> > >>
> > >> LOL! No, we'll never see those!
> > >>
> > >> What crashes though? That should never happen :-(
> > >
> > > I can always reproduce a crash:
> > >
> > > 1) Right click a table
> > > 2) Select View Data -> View top 100 rows
> > > 3) Click the row number to select it
> > > 4) Click the delete icon (Trash)
> > > 5) Click Yes on the confirmation dialog.
> > > 6) Certain crash
> > >
> > > The row is not deleted. I can delete it with a delete command in psql.
> > >
> >
> > Works fine for me with my dummy data - but I did have to remove the
> > foreign key and the call to valida_cpf(cpf) in the cpf check constraint.
> >
> > When you delete in psql, do you see any notices from the backend?
>
> No
>
> > Are
> > there any other tables referencing this one that might be preventing the
> > delete (not that that should cause a crash either of course).
>
> Yes, there is a table with a FK referencing this one. But I'm deleting
> a not referenced row to reproduce the crash.
>
> I also tried to delete a row referenced by that other table and it
> crashs the same.
>
> If there is a method to trace the crash just let me know and I will
> try to use it.
I'm sending you the crash log and the db dump so hopefully you can reproduce it.
Regards,
--
Clodoaldo Pinto Neto
From | Date | Subject | |
---|---|---|---|
Next Message | Laurent ROCHE | 2007-01-19 12:33:15 | Crash at closing [was: Crash and sending report !] |
Previous Message | Dave Page | 2007-01-19 11:31:28 | Re: Re : Crash and sending report ! |