Re: Migration from MS Sql server using the plug-in

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: Migration from MS Sql server using the plug-in
Дата
Msg-id D85C66DA59BA044EB96AB9683819CF610150B1@dogbert.vale-housing.co.uk
обсуждение исходный текст
Ответ на Migration from MS Sql server using the plug-in  ("Antti Toivanen" <antti.toivanen@telemerkki.fi>)
Список pgadmin-support
 
-----Original Message-----
From: Antti Toivanen [mailto:antti.toivanen@telemerkki.fi]
Sent: 29 May 2002 12:15
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Migration from MS Sql server using the plug-in

It doesnt import identity fields as serials, and thus is not usable for databases using auto_increment.

 

It is usable because when it has finished it is trivial to do something like:

 
SELECT max(serial_col) FROM tablename;
CREATE SEQUENCE serial_col_id START <result of previous query + 1>;
ALTER TABLE tablename ALTER COLUMN serial_col SET DEFAULT nextval('serial_col_id');
CREATE UNIQUE INDEX serial_col_idx ON tablename (serial_col);
Regards, Dave.

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

Предыдущее
От: "Antti Toivanen"
Дата:
Сообщение: Migration from MS Sql server using the plug-in
Следующее
От: "Raymond Chui"
Дата:
Сообщение: How to partial dump the log in SQL?