Database conversion type serial question

Поиск
Список
Период
Сортировка
От Carol Walter
Тема Database conversion type serial question
Дата
Msg-id 99CE0FBA-30CB-4DB8-8F58-C7CA1A9EDDB3@indiana.edu
обсуждение исходный текст
Ответы Re: Database conversion type serial question  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
I'm converting a database developed by a group of students from
Oracle to Postgres.  There are fields that should be primary keys
using sequences.  I can get the primary keys designated but when I
try to change the type from integer to serial I get an error saying
that 'type "serial" does not exist.  Can I designate a column not
previously defined as serial to serial.  It was a sequence on the
Oracle database that I'm converting it from.

Carol

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

Предыдущее
От: "Marc Fromm"
Дата:
Сообщение: restore from pg_dumpall
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Database conversion type serial question