List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:February 10 2005 3:57pm
Subject:Re: global object-id
View as plain text  
> 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

Thread
global object-idKonrad Kieling10 Feb
  • Re: global object-idMartijn Tonies10 Feb
  • Re: global object-idSergei Golubchik10 Feb
Re: global object-idBill Easton11 Feb