Andy Colson <[EMAIL PROTECTED]> writes: > I have an 8.2 database that has full text searching. I tried to > backup/restore it to 8.3 but got lots of errors: > ... > I didn't really expect it to totally work, but I'm not sure how to move > my db.
Did the data transfer over? The declarations of the former contrib functions would of course fail, but type tsvector is still there. I would like to think that ignoring pg_restore's whining would get you most of the way there. (As noted in the beta release notes, somebody really really needs to write a migration guide for existing tsearch2 users.) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match