Database Migration Wizard and Sequences.

Поиск
Список
Период
Сортировка
От Brage Førland
Тема Database Migration Wizard and Sequences.
Дата
Msg-id 20030212155629.A38992@sisyfos.zoo.uib.no
обсуждение исходный текст
Список pgadmin-hackers
Are there any reasons why the data migration plugin always converts the type
of the field to INT8? This can be a bit annoying if there are foreign keys
of type INT4 which refers to the fields. The default behaviour in PostgreSQL
is to create new serial columns of type int4.

I suggest you keep the type of the field, and only change it only according
to the type map.

Another small annoyance is that the plugin uses "_key" to name the
sequences. Could this be changed to "_seq" to be consistent with the SERIAL
type in PostgreSQL?

     -Brage


Вложения

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

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: NOT NULL-bug in data migration wizard.
Следующее
От: "Dave Page"
Дата:
Сообщение: Re: Database Migration Wizard and Sequences.