bug in pgmigration-1_2_0

From: "Thomas B(dot) Clark" <tc1(at)clark(dot)durham(dot)nc(dot)us>
To: pgadmin-support(at)postgresql(dot)org
Subject: bug in pgmigration-1_2_0
Date: 2002-11-11 19:47:40
Message-ID: 3DD0095C.87192E83@clark.durham.nc.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

pgmigration makes the following error when migrating a serial field:
DEFAULT nextval('testtable test_id_seq'::text) NOT NULL

The sequence table should be in double quotes surrounded by single
quotes:
DEFAULT nextval('"testtable test_id_seq"'::text) NOT NULL

Any table containing a space will get converted to an invalid string.

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2002-11-12 10:03:44 Re: bug in pgmigration-1_2_0
Previous Message Soma Shekhar K 2002-11-09 07:22:34 how to convert ms-access table to postgresql table in linux