Re: can't read SQL dump from MySQL

From: Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk>
To: Andreas Jerke <info(at)vrdesign(dot)de>
Cc: Pgsql-General <pgsql-general(at)hub(dot)org>
Subject: Re: can't read SQL dump from MySQL
Date: 2000-09-11 13:22:56
Message-ID: 20000911142256.A24218@quartz.newn.cam.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dan Browning 2000-09-11 13:32:27 Removing all NOT NULL constraints from multiple tables easily
Previous Message Darrin Ladd 2000-09-11 12:28:35 Re: Help! How to find the definition of a user-defined function