Database conversion type serial question - Mailing list pgsql-admin

From Carol Walter
Subject Database conversion type serial question
Date
Msg-id 99CE0FBA-30CB-4DB8-8F58-C7CA1A9EDDB3@indiana.edu
Whole thread Raw
Responses Re: Database conversion type serial question
List 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 by date:

Previous
From: "Marc Fromm"
Date:
Subject: restore from pg_dumpall
Next
From: Tom Lane
Date:
Subject: Re: Database conversion type serial question