Bob Pawley wrote: >> I'm sure that PG Admin just generates the numbers in the GUI as it >> displays them (as they're meaningless as persistent data). > Perhaps - but they aren't necessarily meaningless as pure information. Can't you just do the same - generate the numbers within your application - and only store them once this "construction phase" ends? It seems weird to keep some arbitraty numbering scheme in the database. What does it signify in that phase? Does order matter at all - or is that what it's supposed to be? You could also use a mixed solution: - use a sequence during the construction phase to order by, - generate the "real" numbering in your client application based on that order, - store the generated numbers instead of the sequence values once the construction phase is finished. PS. please don't top post, I had to reconstruct your message to let it make sense. -- Alban Hertroys alban@xxxxxxxxxxxxxxxxx magproductions b.v. T: ++31(0)534346874 F: ++31(0)534346876 M: I: www.magproductions.nl A: Postbus 416 7500 AK Enschede // Integrate Your World //
