Postgres Pro
Downloads
Home   >   mailing lists

Re: insert statement going into infinite loop - Mailing list pgsql-bugs

From Craig Ringer
Subject Re: insert statement going into infinite loop
Date
Msg-id 4D154125.2010508@postnewspapers.com.au
Whole thread Raw
In response to insert statement going into infinite loop  (Trimurthulu Bandaru <trimurthulub@mediaforte.in>)
Responses Re: insert statement going into infinite loop  (Trimurthulu Bandaru <trimurthulub@mediaforte.in>)
List pgsql-bugs
Tree view 
On 12/24/2010 10:57 PM, Trimurthulu Bandaru 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..

Do you have any triggers on the table?

Can you produce a single .sql file that creates the tables and does the
problem insert?

--
Craig Ringer

pgsql-bugs by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: insert statement going into infinite loop
Next
From: Robert Haas
Date:
Subject: Re: memory leaks? using savepoint