PGSQL GENERAL 35 RE MIGRATING FROM INFORMIX
From: systemguards@no-spam (Jaime Casanova)
Subject: Re: migrating from informix
Date: Fri, 10 Dec 2004 14:10:36 -0600 (CST)


--- "Gregory S. Williamson" <gsw@no-spam>
escribió: > Jaime --
> > > > Sorry that I didn't respond earler -- been quite > > busy.
> don't worry.
> > > > > We have migrated our runtime aspect (which is > heavy > > use of the Spatial Blade/postGIS in a mostly > > read-only environment); we were using Informix 9.3
> > dynamic server.
> > > > I have some notes I wrote up that I'll post > tonight > that will be of help > > > -- they are on a machine I don't have access to > > right now. Most of the tables and supporting SQL > > (perl scripts mostly) transferred cleanly; > i'm doing that at hand right now.
> > > I didn't > > try to automate conversion of stored procedures or > > triggers (not a lot of these in our runtime).
> i have no one.
> > > > > Greg Williamson > > DBA > > GlobeXplorer LLC > > > thanx, greg for your answer regards, Jaime Casanova
_________________________________________________________
> Do You Yahoo!?
> Información de Estados Unidos y América Latina, en > Yahoo! Noticias.
> Visítanos en http://noticias.espanol.yahoo.com >
_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match