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 just tried generating my database with the schema you provided, but
since it still contains the logfiles table definition with a "offset"
field, it fails with the following error :
Oct 21 10:41:38 eirei-no-za postgres[62248]: [25-1] ERROR: syntax error
at or near "offset" at character 191
Oct 21 10:41:38 eirei-no-za postgres[62248]: [25-2] STATEMENT: CREATE
TABLE logfiles (
Oct 21 10:41:38 eirei-no-za postgres[62248]: [25-3] id INT4
DEFAULT nextval('logfiles_id_seq'),
Oct 21 10:41:38 eirei-no-za postgres[62248]: [25-4] filename
varchar(60) NOT NULL,
Oct 21 10:41:38 eirei-no-za postgres[62248]: [25-5] parse_group
INT4 NOT NULL DEFAULT '0',
Oct 21 10:41:38 eirei-no-za postgres[62248]: [25-6] last_poll_date
INT4 NOT NULL DEFAULT '0',
Oct 21 10:41:38 eirei-no-za postgres[62248]: [25-7] offset INT4
NOT NULL DEFAULT '0',
Oct 21 10:41:38 eirei-no-za postgres[62248]: [25-8] PRIMARY KEY (id)
Oct 21 10:41:38 eirei-no-za postgres[62248]: [25-9] );
I had to remove the logfiles definitions and fix the sequence names by
hand for the schema to be accepted (they are used inconsistently, table
definitions use names truncated to 28 characters, but setval use the
proper full name).
I attached my modified file, and the result of a diff -r output.
Best,
--
Stephane LAPIE, EPITA SRS, Promo 2005
"Even when they have digital readouts, I can't understand them."
--MegaTokyo
diff-jffnms-0.8.5.pgsql.gz
Description: application/gzip
jffnms-0.8.5-modified.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
