On 10/21/05, Zlatko Matić <zlatko.matic1@xxxxxxxxxxx> wrote: > I was reading release notes for 8.1 and there is something about changes> concerning replacing ::text with ::regclass in default clauses. There is a> query in Release notes, that should be executed to update dump from previos> versions.> But, even without it, I see that all serial fileds in my database were> updated authomatically during restore from dump ?! I restored only globals> and schema from dumpall backup... Even without running the script, your database should keep working.Are you sure that the expressions are actually not using ::textanymore? Normally they will keep the ::text, and only to change to thenew system should you use the script. Most people *do* want the newbehavior though, so run it :-). greetings,Nicolas --Nicolas Barbierhttp://www.gnu.org/philosophy/no-word-attachments.html ---------------------------(end of broadcast)---------------------------TIP 6: explain analyze is your friend
