Brian,
> CREATE TABLE palm_addressbook (
> cal_id int(11) NOT NULL default '0',
> account_id int(11) NOT NULL default '0',
> palm_rec_id int(11) NOT NULL default '0',
> PRIMARY KEY (cal_id,account_id),
> UNIQUE KEY account_id (account_id,palm_rec_id)
> ) TYPE=MyISAM;
Aieee! I had no idea that MySQL syntax was that non-standard ...
> I think it would be
You're close. Use:
> CREATE TABLE palm_addressbook (
> cal_id int4 NOT NULL default (0),
> account_id int4 NOT NULL default (0),
> palm_rec_id int4 NOT NULL default (0),
> CONSTRAINT cs_palm_address_key PRIMARY KEY (cal_id,account_id)
> );
And, hey, if you get a Palm-to-postgresql app running, send me e-mail.
I might be able to re-sell it.
-Josh