Craig Small wrote: > On Tue, Oct 20, 2009 at 12:52:09PM +0900, Stephane LAPIE wrote: >> I just tried your file on my test setup, it doesn't work because of the >> AUTO_INCREMENTs (MySQL-isms), which are not declared the same way at all >> in PostgreSQL. > It seems that the mysql "postgresql compatible" mode is not compatible > at all. In fact for anything other than trivial databases it is pretty > useless. > > Thanks for your report, I'm now using the old conversion programs. > I've attached the converted one in this email, gziped so it gets > through.
I ran your schema through a diff with my handmade postgres schema (that included fixed logfiles tables), the result is roughly the same, though for some odd reason sequence names your file contains are truncated to 28 characters. Here is my own file (gzipped) for reference. It is mostly based on the old 0.8.3 file + patches taken from the mysql 0.8.4 file, and adjustments for text field sizes (interface names & such). Best, -- Stephane LAPIE, EPITA SRS, Promo 2005 "Even when they have digital readouts, I can't understand them." --MegaTokyo
jffnms-0.8.4-handmade.pgsql.gz
Description: application/gzip
signature.asc
Description: OpenPGP digital signature
------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference
_______________________________________________ jffnms-users mailing list jffnms-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jffnms-users
