Postgres Pro
Downloads
Home   >   mailing lists

Thread: DUMPall PG7.1.3 restore to PG7.3.2

DUMPall PG7.1.3 restore to PG7.3.2

From
"Eko Pranoto"
Date:
I have error when restoring file DUMPall PG7.1.3 to
PG7.3.2
  with error message "function varchar(integer) does not
exist"

any one can help ?

thanks before it
===========================================================================================
"TELKOMNet Instan memberikan diskon 40% untuk akses malam hari dari pukul 23.00 sampai 06.00.
Berlaku untuk wilayah Jawa Timur mulai 1 Mei 2003 sampai 30 Juni 2003."
===========================================================================================

Re: DUMPall PG7.1.3 restore to PG7.3.2

From
"Mendola Gaetano"
Date:
"Eko Pranoto" <koprapostgres@telkom.net> wrote:
> I have error when restoring file DUMPall PG7.1.3 to
> PG7.3.2
>   with error message "function varchar(integer) does not
> exist"
>
> any one can help ?

Postgres 7.3.X is missing of a lot implicit cast present before
so I suggest you to define your cast integer => varchar before
to import the DB.


Regards
Gaetano

Re: DUMPall PG7.1.3 restore to PG7.3.2

From
"kopra"
Date:
>
> Postgres 7.3.X is missing of a lot implicit cast present before
> so I suggest you to define your cast integer => varchar before
> to import the DB.
>

  do you mean I redefine this function....

      varchar(integer)    -----into---->   varchar(varchar)   ?

  because this function varchar(integer) is from PostgreSQL 7.1.3 itself

best regards
Eko Pranoto