> 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
Here are the lines in question:
"role" VARCHAR NOT NULL,
214 CONSTRAINT role_check CHECK "role" IN
('actor','director','producer','executive_producer','writer','guest_star','host','adapter','presenter','commentator','guest'),
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
