Re: [BUGS] insert statement going into infinite loop

2010-12-27 Thread John R Pierce
On 12/27/10 10:31 PM, Trimurthulu Bandaru wrote: Can you produce a single .sql file that creates the tables and does the problem insert? Can you please make me clear in this issue.. he's asking if you can produce a test case in the form of a .SQL file that creates a schema and demonstrates t

Re: [BUGS] insert statement going into infinite loop

2010-12-27 Thread Trimurthulu Bandaru
On Sat, 2010-12-25 at 11:56 +1100, Craig Ringer wrote: > 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

Re: [BUGS] insert statement going into infinite loop

2010-12-24 Thread Craig Ringer
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 prod

Re: [BUGS] insert statement going into infinite loop

2010-12-24 Thread Jaime Casanova
On Fri, Dec 24, 2010 at 6:57 AM, 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.. define "infinite loop", the truth i