Postgres Pro
Downloads
Home   >   mailing lists

Thread: record new is unassigned yet

record new is unassigned yet

From
"Cristian Custodio"
Date:
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

Re: record new is unassigned yet

From
"Cristian Custodio"
Date:
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/

Re: record new is unassigned yet

From
Jan Wieck
Date:
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 #