db - Mailing list pgsql-odbc

From Daniel Phlander
Subject db
Date
Msg-id 002f01c33fbc$d0831940$cb566150@phlandernpfjk7
Whole thread Raw
List pgsql-odbc

Hello!
I have a problem:
I have installed PostgreSQL 7.3.3 and I have also put in the db a ( /usr/local/pgsql/bin/pg_dumpall > backup.sql ), which I made from a PostgreSQL 7.2.4.  backup.sql; has uploaded with no problem, but now in the applications on which I work I have to make backup.sql from PgSQL 7.3.3 and to put into PgSQL 7.2.4., but I see this is not working (I have errors).
I want to know how can I put a backup.sql made on a PgSQL 7.3.3 and to upload it into PgSQL 7.2.4. ?
I look forward to hear from you! Thanks.
Daniel
 
[gnuworld@nx2 gnuworld]$ /usr/local/pgsql/bin/psql ccontrol < ccontrol.sql
You are now connected as new user gnuworld.
ERROR:  parser: parse error at or near "public"
ERROR:  parser: parse error at or near "public"
ERROR:  parser: parse error at or near "public"
ERROR:  parser: parse error at or near "public"
ERROR:  parser: parse error at or near "public"
ERROR:  parser: parse error at or near "public"
ERROR:  parser: parse error at or near "public"
ERROR:  parser: parse error at or near "public"
ERROR:  parser: parse error at or near "public"
ERROR:  parser: parse error at or near "public"
ERROR:  parser: parse error at or near "public"
ERROR:  parser: parse error at or near "public"
ERROR:  parser: parse error at or near "public"
ERROR:  parser: parse error at or near "public"
ERROR:  parser: parse error at or near "public"
ERROR:  parser: parse error at or near "public"
ERROR:  parser: parse error at or near "public"
ERROR:  parser: parse error at or near "public"
ERROR:  parser: parse error at or near "public"
ERROR:  parser: parse error at or near "public"
ERROR:  parser: parse error at or near "public"
ERROR:  parser: parse error at or near "public"
ERROR:  parser: parse error at or near "public"
ERROR:  parser: parse error at or near "public"
ERROR:  parser: parse error at or near "public"
ERROR:  parser: parse error at or near "public"
ERROR:  parser: parse error at or near "public"
ERROR:  parser: parse error at or near "public"
ERROR:  parser: parse error at or near "public"
ERROR:  parser: parse error at or near "public"
ERROR:  parser: parse error at or near "public"
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
ERROR:  parser: parse error at or near "("
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \.
ERROR:  parser: parse error at or near "4"
invalid command \.
ERROR:  parser: parse error at or near "4"
ERROR:  parser: parse error at or near "ACCESS"
ERROR:  parser: parse error at or near "moduser"
invalid command \.
ERROR:  parser: parse error at or near "gchan"
invalid command \.
ERROR:  parser: parse error at or near "190"
invalid command \.
ERROR:  parser: parse error at or near "mciuc"
invalid command \.
ERROR:  parser: parse error at or near "("
invalid command \.
ERROR:  parser: parse error at or near "("
invalid command \.
ERROR:  parser: parse error at or near "("
invalid command \.
ERROR:  parser: parse error at or near "ACCESS"
invalid command \.
ERROR:  parser: parse error at or near "("
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
invalid command \N
ERROR:  parser: parse error at or near "checkver"
invalid command \.
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index 'opers_pkey' for table 'opers'
ALTER
CREATE
CREATE
CREATE
ERROR:  parser: parse error at or near "("
ERROR:  parser: parse error at or near "("
ERROR:  parser: parse error at or near "("
[gnuworld@nx2 gnuworld]$

pgsql-odbc by date:

Previous
From: Jeff Eckermann
Date:
Subject: Re: (ODBC) Error connecting to postgres 7.2.2
Next
From: Hiroshi Inoue
Date:
Subject: Re: A few problems with the ODBC driver