Обсуждение: record new is unassigned yet
Peple,
This error is happening when I try delete
some registers of one specific table:
record new is unassigned yet.
I already erase the triggers of this table and
record new is unassigned yet.
I already erase the triggers of this table and
I already desabled the constraints,
but the error is happing yet.
What I could do?
Cristian Luciano Custodio
What I could do?
Cristian Luciano Custodio
Dennis, I found the problem. There were a constraint delete cascade. Thanks, Cristian >quote your commands >quote the errors. >We'll try to help. Cristian Custodio wrote: >> Peple, >> This error is happening when I try delete >> some registers of one specific table: >> >> record new is unassigned yet. >> >> I already erase the triggers of this table and >> I already desabled the constraints, >> but the error is happing yet. >> >> What I could do? >> >> Cristian Luciano Custodio Esta mensagem foi verificada pelo E-mail Protegido Terra. Scan engine: VirusScan / Atualizado em 02/05/2003 / Versão: 1.3.13 Proteja o seu e-mail Terra: http://www.emailprotegido.terra.com.br/
Cristian Custodio wrote: > > Dennis, > > I found the problem. > > There were a constraint delete cascade. That cannot be the direct cause for that error message. There must be a custom trigger defined on one of the tables where you (or a constraint or some other custom trigger) delete from and that ON DELETE trigger tries to access NEW. Jan > > Thanks, > > Cristian > > >quote your commands > > >quote the errors. > > >We'll try to help. > > Cristian Custodio wrote: > >> Peple, > >> This error is happening when I try delete > >> some registers of one specific table: > >> > >> record new is unassigned yet. > >> > >> I already erase the triggers of this table and > >> I already desabled the constraints, > >> but the error is happing yet. > >> > >> What I could do? > >> > >> Cristian Luciano Custodio > > Esta mensagem foi verificada pelo E-mail Protegido Terra. > Scan engine: VirusScan / Atualizado em 02/05/2003 / Versão: 1.3.13 > Proteja o seu e-mail Terra: http://www.emailprotegido.terra.com.br/ > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #