Martijn,

>> > > the statement
>> > > INSERT INTO T1 SELECT * FROM T1 (duplicating T1)
>> > > causes (in Firebird 1.5.1, maybe in IB too) closed loop.
>> > >
>> > > PostgreSQL works correctly!
>>
>> At 12:53 PM 15/08/2004 -0400, Sean Leyne wrote:
>>
>> >Yes, this an old/long standing bug with FB and IB (all versions).
>>
>> ...while others would say it was a crippling bug if database rules
>> prevented a transaction from seeing its own uncommitted work.

MT> Then again - what is the SQL standard behaviour for this?

IIRC the standard says Firebird is wrong. :-(
Ciao
--
Nando mailto:nandod@...