Re: autoincrement in PostgreSQL

Alik Kurdjukov <alik@xxxxxxxxxxxx> writes:

Please state the version of Torque that you have used.
Please supply patches in diff -u format.
Please file a bug report with our issues tracker.

        Regards
                Henning


>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@xxxxxxxxxxxxx
>For additional commands, e-mail: torque-user-help@xxxxxxxxxxxxx

-- 
Dipl.-Inf. (Univ.) Henning P. Schmiedehausen          INTERMETA GmbH
hps@xxxxxxxxxxxx        +49 9131 50 654 0   http://www.intermeta.de/

RedHat Certified Engineer -- Jakarta Turbine Development  -- hero for hire
   Linux, Java, perl, Solaris -- Consulting, Training, Development

What is more important to you...
   [ ] Product Security
or [ ] Quality of Sales and Marketing Support
              -- actual question from a Microsoft customer survey