On Wed, May 24, 2000 at 05:58:56PM -0400, joe briggs wrote:
> Hello,
>
> When I try to import a data base from one Linux box to another ( cat
> db.out | psql dbname ), I get an error:
>
> ERROR PARSER: parser error at or before 'constraint'.
>
> The source box was Linxu 6.1 with PostgreSQL 7.0 manually installed.
> The target box has been the same configuration, but also a RH61 with
> default PostgreSQL installation. Results are the same.
RedHat 6.1 comes with PostgreSQL 6.5.3, I beleive. Ceratinly not 7.0.
Grab the 7.0 RPMs, replace the 6.5.x install, and everything should
work fine.
Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005