Postgres Pro
Downloads
Home   >   mailing lists

Thread: prob with really simple insert

prob with really simple insert

From
marian
Date:
When I do this,
INSERT INTO orgdata ( name, fax, contact, email, phone, address,
preferred ) VALUES ( 'wally', '123456789', 'wally', 'wally@wally.com',
'987654321', 'wally way', 'f' )

I get
ERROR:  query rewritten 100 times, may contain cycles
: PGRES_FATAL_ERROR

What is going on here????

Re: prob with really simple insert

From
"scott.marlowe"
Date:
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', 'wally@wally.com',
> '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

Re: prob with really simple insert

From
Stephan Szabo
Date:
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', 'wally@wally.com',
> '987654321', 'wally way', 'f' )
>
> I get
> ERROR:  query rewritten 100 times, may contain cycles
> : PGRES_FATAL_ERROR

Do you have any rules on orgdata?