Re: insert statement going into infinite loop

On Fri, Dec 24, 2010 at 6:57 AM, Trimurthulu Bandaru
<trimurthulub@mediaforte.in> wrote:
> Hi everybody..
> I have table with 11 attributes, 6 of them refers different tables and
> having one primary key.
> when I am trying to insert row with 121 key value, its going into
> infinite loop..

define "infinite loop", the truth is that you're giving almost no
information so all we can try now is to guess and cross fingers ;)

are you describing that the INSERT never finishes?
if so, maybe the table is locked... you can know that by looking in
pg_stat_activity view and find your statement in the field
current_query and see the field waiting, if is true then the statement
is locked waiting for something...
or you can see the pg_locks view where relation =3D 'your_table'::regclass

another posibility is that you have a trigger in the table after or
before insert and then inside the trigger inserting a new value on the
same table forcing a new execution of the trigger making it
recursive...

> I am thinking its a bug in postgres..

it's too early to blame postgres

--=20
Jaime Casanova=C2=A0 =C2=A0 =C2=A0 =C2=A0=C2=A0 www.2ndQuadrant.com
Professional PostgreSQL: Soporte y capacitaci=C3=B3n de PostgreSQL