Re: can't read SQL dump from MySQL - Mailing list pgsql-general

From Patrick Welche
Subject Re: can't read SQL dump from MySQL
Date
Msg-id 20000911142256.A24218@quartz.newn.cam.ac.uk
Whole thread Raw
In response to can't read SQL dump from MySQL  ("Andreas Jerke" <info@vrdesign.de>)
Responses AW: can't read SQL dump from MySQL  ("Andreas Jerke" <info@vrdesign.de>)
List pgsql-general
On Mon, Sep 11, 2000 at 12:38:54PM +0200, Andreas Jerke wrote:
>
> 1   CREATE TABLE Adresse (
> 2   pid_adresse int(11) DEFAULT '0' NOT NULL auto_increment,
> 3   id_person int(11) DEFAULT '0' NOT NULL,
> 4   PLZ varchar(50),
> 5   id_ort int(11) DEFAULT '0',
> 6   strasse varchar(50),
> 7   id_postcode int(11),
> 8   hausnummer int(11),
> 9   zusatz varchar(25),
> 10  postfach varchar(20),
> 11  leitcode varchar(18),
> 12  strassen_code char(3),
> 13  FZ char(3),
> 14  adresszusatz varchar(50),
> 15  PRIMARY KEY (pid_adresse),
> 16  KEY id_person (id_person)
> 17  );
>
> any suggestions ?

I think the problem is int(11) - maybe this should be numeric rather than int?
Or will integer on its own do?

Not sure about the "KEY" bit at the end - maybe

id_person INTEGER NOT NULL UNIQUE DEFAULT 0,

is sufficient?

Cheers,

Patrick

pgsql-general by date:

Previous
From: "Mike Sears"
Date:
Subject: Re: PostgreSQL + PHP can't connect
Next
From: "Dan Browning"
Date:
Subject: Removing all NOT NULL constraints from multiple tables easily