Re: sequences, moving from 8.0.4 to 8.1 ?

Поиск
Список
Период
Сортировка
От Nicolas Barbier
Тема Re: sequences, moving from 8.0.4 to 8.1 ?
Дата
Msg-id b0f3f5a10510211129r681b8ec0vb426a65d1f3afcea@mail.gmail.com
обсуждение исходный текст
Ответ на sequences, moving from 8.0.4 to 8.1 ?  (Zlatko Matić <zlatko.matic1@sb.t-com.hr>)
Список pgsql-general
On 10/21/05, Zlatko Matić <zlatko.matic1@sb.t-com.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

В списке pgsql-general по дате отправления:

Предыдущее
От: Tino Wildenhain
Дата:
Сообщение: Re: scheduled backup
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: scheduled backup