Re: revised hstore patch

Bruce Momjian wrote:
> Andrew Dunstan wrote:
> > > I can't imagine losing a huge percentage of pg_migrator users via hstore
> > > changes, especially since you can migrate hstore manually and still use
> > > pg_migrator.
> > >
> > >   
> > 
> > We could finesse the hstore issues, but we are already blown out of the 
> > water right now by the enum issue. My biggest end client has been 
> > replacing small lookup tables with enums ever since they migrated to 8.3 
> > many months ago. Another end client is currently moving to implement FTS 
> 
> Ah, yea, enum is an issue.
> 
> > on 8.4, and they will be hit by the tsvector/GIN restrictions in the 
> > future unless we fix that. All I was saying is that the more such 
> 
> FTS will be fine for migration from 8.4 to 8.5;  it was only the
> internal format change that caused FTS migration not to work from 8.3 to
> 8.4 (index rebuild required).  There is nothing about FTS that prevents
> migration.
> 
> Here is the pg_migrator README with the restrictions:
> 
>
http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pg-migrator/pg_migrator/README?rev=1.56&content-type=text/x-cvsweb-markup
> 
> I will need to document that many of these are 8.3-8.4-only migration
> issues.

Done:
http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pg-migrator/pg_migrator/README?rev=1.57&content-type=text/x-cvsweb-markup

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +