On Thu, Oct 06, 2005 at 12:40:49PM -0700, CSN wrote: > > --- Scott Marlowe <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] 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