We too use a sequence per table, just thought it was an interesting approach when I saw someone doing only one and felt like mentioning to see if any others do that. On some of ours we have a pre-insert trigger and others we do not, there is no consistency here on that other than no one ever seems to manual insert the IDs.
On 3/9/06, Bryan Stevenson <[EMAIL PROTECTED]> wrote: > > I never said I use 1 sequence...just an example > > We use a sequence for each table ;-) > > We also use pre-insert triggers to grab nextval if the PK is not supplied > in the > insert statement > > When inserting a parent and then children we always select from the > sequence > first and use the new PK val in the parent and al children inserts > > Cheers > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234941 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
