Re: [pgsql-advocacy] MySQL to PostgreSQL, was ENUM type - Mailing list pgsql-general

From Christopher Kings-Lynne
Subject Re: [pgsql-advocacy] MySQL to PostgreSQL, was ENUM type
Date
Msg-id 42E84FE9.9020705@familyhealth.com.au
Whole thread Raw
In response to Re: [pgsql-advocacy] MySQL to PostgreSQL, was ENUM type  (Gregory Youngblood <pgcluster@netio.org>)
List pgsql-general
> I think one of the more difficult areas will be to convert unsigned
> fields from mysql into postgres. For smaller sizes it is possible to
> convert to postgres by moving one size up and using constraints to
> restrict numbers to be positive, and possibly within the mysql range
> too. But, the problem is unsigned bigint in mysql to postgresql.
> There's not another larger integer size that can be used that would
> allow the 18446744073709551615 (is that the max value?) max value
> available in mysql. Or am I missing something?

You'd just issue a warning...


pgsql-general by date:

Previous
From: Gregory Youngblood
Date:
Subject: Re: [pgsql-advocacy] MySQL to PostgreSQL, was ENUM type
Next
From: Tony Caduto
Date:
Subject: Re: GUID for postgreSQL