logo       

autoincrement in PostgreSQL: msg#00047

jakarta.turbine.torque.user

Subject: autoincrement in PostgreSQL

Hello!

I found that autoincrement flag on the column is ignored in PostgreSQL backend. So I created a patch. Here's new columns.vm I created for PostgreSQL.

====================================================
#foreach ($col in $table.Columns)
#set ( $type = $col.Domain.SqlType )
#set ( $size = $col.printSize() )
#set ( $default = $col.DefaultSetting )
#set ( $autoIncrement = $col.isAutoIncrement() )
#if ( $autoIncrement )
#if ( $type == "INT8" )
#set ( $type = "SERIAL8" )
#elseif ( $type == "INT" )
#set ( $type = "SERIAL4" )
#elseif ( $type == "INT4" )
#set ( $type = "SERIAL4" )
#end
#end
#set ( $entry = "$col.Name $type $size $default $col.NotNullString," )
$strings.sub($strings.collapseSpaces($entry)," ,",",")
#end
====================================================

Can this patch be commited to CVS repository?

best regards,
alik.


<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

News | FAQ | advertise