Regarding this old subject, we moved to 8.0.2. Updating to 7.2.5 didn't solved the issue (I could not find an 7.2.7 rpm release for Red hat 7.2. since that's the plataform already installed by client, I had to stick to that). The upgrade to 8.0.2 was done in a Red Hat 9.0 system. Import of 'lo' was now succesfully. Greetings --- I'll resume here steps taken to upgrade(not recommended, just taken for compatibility with a VB6 app with ODBC) ----------------------------------------------------- usefull changes in postgresql.conf regex_flavor = advanced # advanced, extended, or basic default_with_oids = true ----------------------------------------------------- createdb --encoding SQL-ANSI BASEDEDATOS (for import from 7.2 database) ----------------------------------------------------- our app use this datatype: CREATE DOMAIN datetime AS timestamp ---------------------------------------------------------------
