Re: autoincrement in PostgreSQL

2004-11-14 Thread Henning P. Schmiedehausen
Alik Kurdjukov <[EMAIL PROTECTED]> 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

Re: autoincrement in PostgreSQL

2004-11-12 Thread Alik Kurdjukov
Hello! T E Schmitz wrote: I found that autoincrement flag on the column is ignored in PostgreSQL backend. While it doesn't use SERIAL, it has the same effect. The idMethod has to be set to native for this to work (I believe). Yes, I am using defaultIdMethod="native" Sorry, i just forgot to use

Re: autoincrement in PostgreSQL

2004-11-11 Thread T E Schmitz
Matt Hughes wrote: Alik Kurdjukov wrote: I found that autoincrement flag on the column is ignored in PostgreSQL backend. While it doesn't use SERIAL, it has the same effect. The idMethod has to be set to native for this to work (I believe). Yes, I am using defaultIdMethod="native" -- Regards/

Re: autoincrement in PostgreSQL

2004-11-11 Thread Matt Hughes
Alik Kurdjukov wrote: Hello! I found that autoincrement flag on the column is ignored in PostgreSQL backend. Hi, I've been using PostgreSQL 7 for a long time with Torque, and this schema snippet generates auto incrementing primary keys: ... Output SQL: DROP TABLE Fo

Re: autoincrement in PostgreSQL

2004-11-11 Thread T E Schmitz
Hello Alik, Alik Kurdjukov wrote: 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. I don't understand that. I've been using Torque 3.1 with PostgreSQL and autoincrement for months - it works fine

autoincrement in PostgreSQL

2004-11-11 Thread Alik Kurdjukov
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 (

Re: autoIncrement in PostgreSQL

2004-01-04 Thread Scott Eade
Thomas Lohmueller wrote: I have a problem with autoIncrement in PostgreSQL. The following part from the xml-file does not even generate valid SQL. Torque-gen-3.1 generates this sql-code. CREATE TABLE addr_groups

autoIncrement in PostgreSQL

2004-01-04 Thread Thomas Lohmueller
Hi I have a problem with autoIncrement in PostgreSQL. The following part from the xml-file does not even generate valid SQL. Torque-gen-3.1 generates this sql-code. CREATE TABLE addr_groups ( addr_group_id