MySQL to Postgres question - Mailing list pgsql-general

From Edward Blake
Subject MySQL to Postgres question
Date
Msg-id eae776d40803210915l9b45da2r73894b510cdf8998@mail.gmail.com
Whole thread Raw
Responses Re: MySQL to Postgres question  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: MySQL to Postgres question  (Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>)
Re: MySQL to Postgres question  (Rodrigo Gonzalez <rjgonzale@gmail.com>)
Re: MySQL to Postgres question  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: MySQL to Postgres question  (Justin <justin@emproshunts.com>)
List pgsql-general
The table I have in MySQL is similar to below:

 0 SET FOREIGN_KEY_CHECKS=0;
 1 CREATE TABLE products (
 2     product_id integer(11) not null auto_increment,
 3     product_name varchar(255) not null,
 4     product_descrition varchar(255) not null,
 5     class_id integer(11) not null,
 6     subclass_id integer(11) not null,
 7     department_id integer(11) not null
 8     PRIMARY KEY (product_id),
 9     KEY class_id (class_id),
10     KEY subclass_id (subclass_id),
11     KEY department_id (department_id)
12 );

When I try and rewrite it as a Postgres statement (below), it fails at line 9.
 0 SET CONSTRAINTS ALL DEFERRED;
 1 CREATE TABLE products (
 2      product_id serial[11] not null,
 3      product_name varchar[255] not null,
 4      product_descrition varchar[255] not null,
 5      class_id integer[11] not null,
 6      subclass_id integer[11] not null,
 7      department_id integer[11] not null
 8      PRIMARY KEY (product_id),
 9      KEY class_id (class_id),
10      KEY subclass_id (subclass_id),
11      KEY department_id (department_id)
12 );

Any ideas?

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: ecpg program getting stuck
Next
From: "Joshua D. Drake"
Date:
Subject: Re: MySQL to Postgres question