Problem with view upgrading from 7.2 to 7.3 - Mailing list pgsql-admin

From Michael Brusser
Subject Problem with view upgrading from 7.2 to 7.3
Date
Msg-id DEEIJKLFNJGBEMBLBAHCAEDDCPAA.michael@synchronicity.com
Whole thread Raw
Responses Re: Problem with view upgrading from 7.2 to 7.3
List pgsql-admin
Hi,
I am upgrading Postgres from version 7.2.1 to 7.3.2
I use pg_dump (the 7.3.2 version) to dump the old database
into the file. I use psql to load it into the new server.

Generally it seem to work, but it breaks while attempting to load
one view definition. Server complains about nonexistant function -
varchar(int), as far as I remember.
It appears that some casting is no longer supported.
This is the fragment from the dump file that results in error:

CREATE VIEW v_note_links AS
  SELECT note_links_aux.nl_id AS id, note_links_aux.nl_obj_url AS obj_url,
  ((('sync:///Note/SyncNotes/'::"varchar" || note_links_aux.nt_note_name)
  || '/'::"varchar") || "varchar"(note_links_aux.nl_note_id)) AS note_url,
  note_links_aux.nt_note_name AS note_name, note_links_aux.nl_note_id AS
  note_id, note_links_aux.nt_obj_name AS obj_name, note_links_aux.nl_obj_id
  AS obj_id FROM note_links_aux;
------------------------------------------
There's no problem if I try to manually create the view in the way it was
created in the old database:
CREATE VIEW v_note_links AS
SELECT  nl_id               AS id
    ,nl_obj_url             AS obj_url
    ,'sync:///Note/SyncNotes/' || nt_note_name || '/'
     || nl_note_id AS note_url
    ,nt_note_name           AS note_name
    ,nl_note_id             AS note_id
    ,nt_obj_name            AS obj_name
    ,nl_obj_id              AS obj_id
FROM note_links_aux ;
-----------------------------------------------
I would appreciate any help on how to handle this problem.

Mike.


pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: PLSQL
Next
From: Sean Chittenden
Date:
Subject: Re: max_connections limit