From: | Nicolas Barbier <nicolas(dot)barbier(at)gmail(dot)com> |
---|---|
To: | Zlatko Matić <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: sequences, moving from 8.0.4 to 8.1 ? |
Date: | 2005-10-21 18:29:18 |
Message-ID: | b0f3f5a10510211129r681b8ec0vb426a65d1f3afcea@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 10/21/05, Zlatko Matić <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr> 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 ::text
anymore? Normally they will keep the ::text, and only to change to the
new system should you use the script. Most people *do* want the new
behavior though, so run it :-).
greetings,
Nicolas
--
Nicolas Barbier
http://www.gnu.org/philosophy/no-word-attachments.html
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2005-10-21 18:38:13 | Re: scheduled backup |
Previous Message | Jeff Davis | 2005-10-21 18:17:48 | Re: [GENERAL] Oracle buys Innobase |