> is there a simple way (ie without creating and deleting datasets in an > extra table) to use an auto_increment id field in several tables. no > table has to have all ids, so i cannot use the field of a master table > in childs. it seems one can use a sequence in postgresql in different > tables. is it possible in a similar way?
"sequences" are separate objects used to generated, guess what, sequential numbers. The actual usage of the numbers is undefined. Auto-inc is auto-inc. Plain and simple. It's something related to a column in a particular table. Each table can have it's own "instance" of 1 (and only 1) auto-incrementing column. Short answer: no. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]