On Wed, Apr 26, 2006 at 11:05:09PM +0300, Andrus wrote: > >> I want to duplicate report so that id order is preserved. > > > > Tables aren't ordered by definition. > > From CLUSTER docs: > > "When a table is clustered, it is physically reordered based on the index > information. " Keep reading... from the same paragraph: Clustering is a one-time operation: when the table is subsequently updated, the changes are not clustered. That is, no attempt is made to store new or updated rows according to their index order. If one wishes, one can periodically recluster by issuing the command again. There is absolutely no way to enforce any kind of table ordering in PostgreSQL as soon as you do *anything* that changes the table. And like others said, I think you need to re-think how you're doing this... :) -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
