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

thanks for help,
I fixed this with:

CREATE TABLE Adresse (
  pid_adresse INT8 DEFAULT NEXTVAL('seqAdresse') PRIMARY KEY,
  id_person int4 DEFAULT '0' NOT NULL,
  PLZ varchar(50),
  id_ort int4 DEFAULT '0',
  strasse varchar(50),
  id_postcode int4,
  hausnummer int4,
  zusatz varchar(25),
  postfach varchar(20),
  leitcode varchar(18),
  strassen_code char(3),
  FZ char(3),
  adresszusatz varchar(50)
);

Cheers,
Andreas



::-----Urspr�ngliche Nachricht-----
::Von: Patrick Welche [mailto:prlw1@newn.cam.ac.uk]
::Gesendet: Montag, 11. September 2000 15:23
::An: Andreas Jerke
::Cc: Pgsql-General
::Betreff: Re: [GENERAL] can't read SQL dump from MySQL
::
::
::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
::