Re: MySQL to Postgres question

On Sat, 22 Mar 2008 21:17:10 -0500
"Adam Rich" <adam.r@sbcglobal.net> wrote:

> > The short answer is that Adam's statement is wrong, or at least
> > misleading.
>
> Sorry Tom, I wasn't trying to do either.  Joshua Drake (who I
> understand to be a reliable source of postgresql information) said
> that applying a sequence to a column after creation created issues,
> versus using the serial type which did not.

Right but as Tom reminded me, the behavior I was referring to was pre
8.3 and in (I believe) it was 8.2 we introduced alter sequence options
to fix the problem.

Sincerely,

Joshua D. Drake

--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL SPI Liaison | SPI Director |  PostgreSQL political pundit