Thread: ERROR PARSER: parse error at or before 'constraint'

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.

I would appreciate ANY suggestions.

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