Problem with view upgrading from 7.2 to 7.3

From: Michael Brusser <michael(at)synchronicity(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Problem with view upgrading from 7.2 to 7.3
Date: 2003-03-17 21:22:14
Message-ID: DEEIJKLFNJGBEMBLBAHCAEDDCPAA.michael@synchronicity.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sean Chittenden 2003-03-17 21:48:30 Re: max_connections limit
Previous Message Bruce Momjian 2003-03-17 19:53:26 Re: PLSQL