Thread: bug in pgmigration-1_2_0

bug in pgmigration-1_2_0

From
"Thomas B. Clark"
Date:
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.


Re: bug in pgmigration-1_2_0

From
"Dave Page"
Date:

> -----Original Message-----
> From: Thomas B. Clark [mailto:tc1@clark.durham.nc.us]
> Sent: 11 November 2002 19:48
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] bug in pgmigration-1_2_0
>
>
> 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.

Hi Thomas,

This should now be fixed. Please can you test the latest snapshot at
http://cvs.pgadmin.org/ in the binaries folder. Installation
instructions are in the README.

Thanks for the report,

Regards, Dave.