Re: MySQL to Postgres question

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: "Adam Rich" <adam(dot)r(at)sbcglobal(dot)net>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: MySQL to Postgres question
Date: 2008-03-23 02:20:44
Message-ID: 20080322192044.0de96b03@jd-laptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, 22 Mar 2008 21:17:10 -0500
"Adam Rich" <adam(dot)r(at)sbcglobal(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2008-03-23 02:31:58 Re: MySQL to Postgres question
Previous Message Adam Rich 2008-03-23 02:17:10 Re: MySQL to Postgres question