On Mon, 22 Mar 2004, marian wrote: > When I do this, > INSERT INTO orgdata ( name, fax, contact, email, phone, address, > preferred ) VALUES ( 'wally', '123456789', 'wally', '[EMAIL PROTECTED]', > '987654321', 'wally way', 'f' ) > > I get > ERROR: query rewritten 100 times, may contain cycles > : PGRES_FATAL_ERROR > > What is going on here????
Is there a trigger on that table? I'd guess it's getting caught in a loop ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match