projects
/
dbsrgits/SQL-Translator.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
Fix incorrect serial instead of bigserial in PG
[dbsrgits/SQL-Translator.git]
/
lib
/
SQL
/
Translator
/
Producer
/
PostgreSQL.pm
diff --git
a/lib/SQL/Translator/Producer/PostgreSQL.pm
b/lib/SQL/Translator/Producer/PostgreSQL.pm
index
7685587
..
455f745
100644
(file)
--- a/
lib/SQL/Translator/Producer/PostgreSQL.pm
+++ b/
lib/SQL/Translator/Producer/PostgreSQL.pm
@@
-651,7
+651,7
@@
sub convert_datatype
$data_type = 'character varying';
}
elsif ( $field->is_auto_increment ) {
- if ( defined $size[0] && $size[0] > 11 ) {
+ if ( (defined $size[0] && $size[0] > 11) or $data_type eq 'bigint' ) {
$data_type = 'bigserial';
}
else {