Re: record new is unassigned yet - Mailing list pgsql-general

From Jan Wieck
Subject Re: record new is unassigned yet
Date
Msg-id 3EBA6C6D.CCFC0795@Yahoo.com
Whole thread Raw
In response to record new is unassigned yet  ("Cristian Custodio" <crstian@terra.com.br>)
List pgsql-general
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 #


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Disk usage
Next
From: Jon Earle
Date:
Subject: Re: PostgreSQL Qs