Re: MySQL to Postgres question - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: MySQL to Postgres question
Date
Msg-id 20080322181444.3088d7f3@commandprompt.com
Whole thread Raw
In response to Re: MySQL to Postgres question  ("James B. Byrne" <byrnejb@harte-lyne.ca>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Sat, 22 Mar 2008 21:01:19 -0400 (EDT)
"James B. Byrne" <byrnejb@harte-lyne.ca> wrote:

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

>  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?

Of course not :). It just has to do with serial being a psuedo type
and thus the actual declaration is just an integer with a default. This
isn't that other database, we don't munge data :P

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


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFH5a8GATb/zqfZUUQRAn4JAJ9xzhFNq+pE4QqX7P1OVQNhe6thqgCgpVQC
M3zEIsj5c+JTo3mU9XOjJqQ=
=RPjl
-----END PGP SIGNATURE-----

pgsql-general by date:

Previous
From: "James B. Byrne"
Date:
Subject: Re: MySQL to Postgres question
Next
From: Craig Ringer
Date:
Subject: Re: --enable-thread-safety bug