Re: Sequence and inserting row
From: Brice <brice_news_at_roads.fr.st>
Date: Tue, 04 Dec 2001 18:00:36 +0000
Message-ID: <3C0D0F44.60000_at_roads.fr.st>
Date: Tue, 04 Dec 2001 18:00:36 +0000
Message-ID: <3C0D0F44.60000_at_roads.fr.st>
Stjepan,
>Primary Key Column (ID) (unique) is populated from sequence and i.e.
>current lastvalue of sequencer is 500. After that I manually insert row
>with ID=600. What would happend when sequencer reaches number 600 and I
>want to insert new row?
>
You would get a Primary Key violation and the row wouldn't get inserted.
Received on Tue Dec 04 2001 - 19:00:36 CET