On Thu, Oct 06, 2005 at 12:40:49PM -0700, CSN wrote: > > --- Scott Marlowe <smarlowe@xxxxxxxxxxxxxxxxx> wrote: > > > > Federated Storage Engine: Allows MySQL to access > > tables in other > > servers like they are here. No real direct > > equivalent in PostgreSQL, > > but dblink provides similar functionality. > > Would that be possible with table partitions? Or > Slony? Slony would give you a loose approximation. Table partitioning is unrelated. Better yet, I don't know of any reason why you can't define a view using dblink that would duplicate the features of a federated system. Of course it would be easier if it was in the back-end... -- 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend