db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alik Kurdjukov <a...@dotcomltd.ru>
Subject autoincrement in PostgreSQL
Date Thu, 11 Nov 2004 18:36:01 GMT
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.


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message