search

google-code-export / ords

Automatically exported from code.google.com/p/ords
1 stars 0 forks source link

hanging integer to bigint in schema designer causes ORDS error #500

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Using Mondial, when changing country.population type from integer to biginteger 
I *sometimes* get the following error.

There has been a problem with the schema you are trying to save. The save 
operation has therefore not happened.
Did you define a column or table name with a space or special character in it 
(because that isn't supported)? Or do you have two columns with the same name? 
org.postgresql.util.PSQLException: ERROR: syntax error at or near "::"
  Position: 138 : the command being run (that has the problem) is CREATE TABLE "country" ("population" BIGINT DEFAULT NULL  ,"area" INTEGER DEFAULT NULL  ,"province" character varying(255) DEFAULT ''NULL::character varying''  ,"capital" character varying(255) DEFAULT ''NULL::character varying''  ,"code" character varying(255)  NOT NULL ,"countryname" character varying(255) DEFAULT ''NULL::character varying''  ,PRIMARY KEY (code)).

Original issue reported on code.google.com by thest...@gmail.com on 31 Jul 2014 at 6:21

GoogleCodeExporter commented 9 years ago 
This should no longer happen with the changes from Issue 442.

Original comment by marxjohn...@gmail.com on 13 Nov 2014 at 3:11