Re: MySQL to Postgres question
От | Justin |
---|---|
Тема | Re: MySQL to Postgres question |
Дата | |
Msg-id | 47E3F97B.5020805@emproshunts.com обсуждение исходный текст |
Ответ на | Re: MySQL to Postgres question ("Joshua D. Drake" <jd@commandprompt.com>) |
Список | pgsql-general |
Joshua D. Drake wrote:
You still get an error if creating a table that specifies a sequence that does not exist yet. I like to control the name of the sequence, plus the starting values or change the incrementing values.I am not sure about 8.3 but certainly earlier releases of PostgreSQL would have specific dependency issues when a sequence was applied to a a column after the fact, versus using the serial or bigserial psuedo-types. Sincerely, Joshua D. Drake - -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ United States PostgreSQL Association: http://www.postgresql.us/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
I might have read something wrong but using serial tells PostgreSQL to automatic transforms.
CREATE TABLEI copied this from the help files.tablename
(colname
SERIAL to CREATE SEQUENCEtablename
_colname
_seq; CREATE TABLEtablename
(colname
integer NOT NULL DEFAULT nextval('tablename
_colname
_seq'));
В списке pgsql-general по дате отправления: