Re: MySQL to Postgres question

From: Rodrigo Gonzalez <rjgonzale(at)gmail(dot)com>
To: Edward Blake <comedian(dot)watchman(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: MySQL to Postgres question
Date: 2008-03-21 16:29:51
Message-ID: 47E3E27F.4050400@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Edward Blake escribió:
> 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?
CREATE TABLE products (
product_id serial not null,
product_name varchar(255) not null,
product_description varchar(255) not null,
class_id integer not null,
subclass_id integer not null,
department_id integer not null,
PRIMARY KEY (product_id)
);

CREATE INDEX idx_prod_class_id ON products (class_id);
CREATE INDEX idx_prod_subclass_id ON products (subclass_id);
CREATE INDEX idx_prod_department_id ON products (department_id);

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Clark 2008-03-21 16:30:59 Re: ecpg program getting stuck
Previous Message Andreas 'ads' Scherbaum 2008-03-21 16:28:58 Re: MySQL to Postgres question