aboutsummaryrefslogtreecommitdiff
path: root/contrib/mysql_to_pgsql/src
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/mysql_to_pgsql/src')
-rw-r--r--contrib/mysql_to_pgsql/src/defines.h15
1 files changed, 13 insertions, 2 deletions
diff --git a/contrib/mysql_to_pgsql/src/defines.h b/contrib/mysql_to_pgsql/src/defines.h
index 662a7aab2fd..ed151bf5fae 100644
--- a/contrib/mysql_to_pgsql/src/defines.h
+++ b/contrib/mysql_to_pgsql/src/defines.h
@@ -89,9 +89,20 @@ string ConvertNativeType(enum_field_types mysqlType, uint32 length)
case FIELD_TYPE_INT24:
return "integer";
case FIELD_TYPE_LONGLONG:
- return "int8";
case FIELD_TYPE_LONG:
- return "bigint";
+ {
+ string temp;
+ char str[10];
+ temp = "numeric";
+ if (length)
+ {
+ temp.append("(");
+ sprintf(str,"%d",length);
+ temp.append(str);
+ temp.append(")");
+ }
+ return temp;
+ }
case FIELD_TYPE_DECIMAL:
case FIELD_TYPE_FLOAT:
case FIELD_TYPE_DOUBLE: