Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.albasani.net!weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail From: Mladen Gogala Newsgroups: comp.databases.postgresql Subject: Re: migrating oracle to postgres Date: Tue, 28 Jun 2011 16:00:38 +0000 (UTC) Organization: solani.org Lines: 15 Message-ID: References: <1308640710.210659@proxy.dienste.wien.at> <96h5hqFo39U1@mid.individual.net> <225b3c7a-66d2-459d-ba55-4d202a780433@n5g2000yqh.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Trace: solani.org 1309276838 22063 eJwFwYEBwCAIA7CXQGyr5wwG/59ggqCztAluDKbTUNKSIn9ATFthXq08+amLp+7VpHVUwB8X4hEF (28 Jun 2011 16:00:38 GMT) X-Complaints-To: abuse@news.solani.org NNTP-Posting-Date: Tue, 28 Jun 2011 16:00:38 +0000 (UTC) User-Agent: Pan/0.133 (House of Butterflies) X-User-ID: eJwFwQEBACAIA7BKgpxrHEHfP4IbZlo2I5EBQUHS/eBJ08yu77wYi2fvImalS6a60T3eEj8MfRER Cancel-Lock: sha1:uENdm+AXh9fEW4PfOiA8EADSedg= X-NNTP-Posting-Host: eJwFwYEBwCAIA7CXUErBcyYr/59gEs7FTjCImBiyMNtojX3Vo8JtZOCXyq5ZuJYSpz45Tz8Y1REK Xref: x330-a1.tempe.blueboxinc.net comp.databases.postgresql:160 On Mon, 27 Jun 2011 00:32:44 -0700, Robert Klemme wrote: > I think we need to separate the ROWID issue from having global indexes > for partitioned tables. I can think of ways to make a global index work > without the existence of ROWID. Well, it would be presumptuous of me to claim otherwise. Having a global ROWID does look like a simple solution to the problem, but there probably are other solutions. Unfortunately, none of those exist in the world of Postgres yet. Neither does this: http://tinyurl.com/38fgjwg -- http://mgogala.byethost5.com