Search Postgresql Archives

Re: MySQL to Postgres question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Sat, 22 Mar 2008 21:01:19 -0400 (EDT)
"James B. Byrne" <byrnejb@xxxxxxxxxxxxx> 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-----

-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux