Michael Brusser <michael@synchronicity.com> writes:
> 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.
Yeah, we removed the int->varchar cast because it was redundant with
int->text, and caused operator resolution failures in some cases.
> There's no problem if I try to manually create the view in the way it was
> created in the old database:
Re-enter the view, then. The || expression will come out as text
instead of varchar; if you really want the view column to look like
it's a varchar you can do
('sync:///Note/SyncNotes/' || nt_note_name || '/'
|| nl_note_id)::varchar AS note_url
regards, tom lane