On 2/5/07, Jim C. wrote:
CREATE TABLE "credits" (
"person" integer NOT NULL default '0',
"chanid" int NOT NULL default '0',
"starttime" timestamp NOT NULL default '1970-01-01 00:00:00+00',
"role" VARCHAR NOT NULL,
CONSTRAINT role_check CHECK "role" IN
('actor','director','producer','executive_producer','writer','guest_star','host','adapter','presenter','commentator','guest'),
-- CONSTRAINT "chanid_constraint0" UNIQUE
("chanid","starttime","person","role")
-- UNIQUE KEY "chanid" ("chanid","starttime","person","role"),
-- KEY "person" ("person","role")
);
Well, here is what I got:
"mysqlDump.postgres.working.sql" 1398L, 13611680C written
[EMAIL PROTECTED] jims]$ psql inscom < mysqlDump.postgres.working.sql 2>&1 |
grep ERROR
ERROR: syntax error at or near "," at character 164
ERROR: syntax error at or near ""role"" at character 218
Should be
CONSTRAINT role_check CHECK ("role" IN
('actor','director','producer','executive_producer','writer','guest_star','host','adapter','presenter','commentator','guest'))
Jochem
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]