Re: loop infinito en triggers

On 5/19/06, Alvaro Herrera <alvherre(at)commandprompt(dot)com> wrote:
>
> gonzalo sáenz escribió:
> > que tal lista,
> >
> > una consulta, que pasa si defino un trigger que se dispare al hacerse un
> > insert, y dentro del codigo del trigger hago un insert en la misma
> tabla?
>
> Que dijo el experimento que hiciste?

el experimento que hice fue en oracle. y oracle no lo permite.

estuve googleando y no encontre nada que me diga q ocurre en postgres.

--
When things are investigated, then true knowledge is achieved;
when true knowledge is achieved, then the will becomes sincere;
when the will becomes sincere, then the heart sees correctly;
when the heart sees correctly, then the personal life is cultivated;
when the personal life is cultivated, then the family life is regulated;
when the family life is regulated, then the national life is orderly;
and when the national life is orderly, then there is peace in this world.

Confucius