Re: MySQL to Postgres question

Message-ID: <00e101c88b84$df1bbca0$9d5335e0$(at)r@sbcglobal.net>

On: Fri, 21 Mar 2008 13:53:36 -0500, "Adam Rich" <adam(dot)r(at)sbcglobal(dot)net>
wrote:

> > 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 column after the fact, versus using the serial or bigserial
> > psuedo-types.

> I'd like to point out that using pg_dump does in fact apply sequences
> to columns after the fact. (at least in 8.3) Columns lose their
> "serial" designation after each backup/restore (and therefore during
> version upgrades)

Can someone expand upon this observation with respect to tables with surrogate
primary keys generated by a sequence? I am not at all clear as to the
implications of this statement but it caused me to wonder if the primary key
values of such tables could be changed simply by dumping and reloading the
database as in an upgrade between versions. Surely this is not the case?

--
*** E-Mail is NOT a SECURE channel ***
James B. Byrne mailto:ByrneJB(at)Harte-Lyne(dot)ca
Harte & Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3