Return-Path: Delivered-To: apmail-db-ddlutils-user-archive@www.apache.org Received: (qmail 93563 invoked from network); 24 Nov 2006 18:00:36 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 24 Nov 2006 18:00:36 -0000 Received: (qmail 5670 invoked by uid 500); 24 Nov 2006 18:00:45 -0000 Delivered-To: apmail-db-ddlutils-user-archive@db.apache.org Received: (qmail 5655 invoked by uid 500); 24 Nov 2006 18:00:45 -0000 Mailing-List: contact ddlutils-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ddlutils-user@db.apache.org Delivered-To: mailing list ddlutils-user@db.apache.org Received: (qmail 5644 invoked by uid 99); 24 Nov 2006 18:00:45 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 24 Nov 2006 10:00:45 -0800 X-ASF-Spam-Status: No, hits=3.6 required=10.0 tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_POST,DNS_FROM_RFC_WHOIS,INFO_TLD X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: local policy) Received: from [66.163.178.164] (HELO web34415.mail.mud.yahoo.com) (66.163.178.164) by apache.org (qpsmtpd/0.29) with SMTP; Fri, 24 Nov 2006 10:00:31 -0800 Received: (qmail 26226 invoked by uid 60001); 24 Nov 2006 18:00:07 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=jY7SQoMeypaM3towt2ENTRamxKlEXFJacy/TO2he6YvG8VoubjxcCdHisbNChYy9pgXQokm9J3LwpdsqN6wun2x+3CQedHx13NFGHQdeCweyko0/ODep8xAWPrIHLUcdvMyJkBzyMDKAxpqa/3g4kjAiqyIbvkw/wFVsaxOfGeA= ; Message-ID: <20061124180007.26223.qmail@web34415.mail.mud.yahoo.com> Received: from [82.122.202.89] by web34415.mail.mud.yahoo.com via HTTP; Fri, 24 Nov 2006 10:00:07 PST Date: Fri, 24 Nov 2006 10:00:07 -0800 (PST) From: Laurent ROCHE Subject: Identity start values (from Postgres to Derby) To: ddlutils-user@db.apache.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org Hi All,=0A=0AI could not find anything about this issue on the website nor = JIRA. Can the mailing list archives be searched ?=0A=0AI am doing an export= from a PostgreSQL database to a Derby database.=0ASome of my tables have o= ne SERIAL colum (in Postgres) which is correctly translated into Identity (= in Derby) ... however the Identity value generated will be always 1 as the = tables are created like this:=0ACREATE TABLE my_table_auto(auto_id SMALLIN= T NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1),= ...=0A=0AI would expect DDL-Utils to generate something along the lines of= :=0AALTER TABLE my_table_auto ALTER COLUMN auto_id RESTART WITH max_val_in= _the_table=0A=0AWhere of course max_val_in_the_table is the maximum plus 1 = of the id of the table =0A(i.e. SELECT MAX(auto_id) + 1 FROM my_table_auto)= =0A=0AAm I missing something ? Is this not supported ?=0A=0A =0AHave fun,= =0AL@u=0AThe Travelling Froggy=0ATravellingFroggy.info=0A=0A=0A=0A=0A=09=0A= =0A=09=0A=09=09=0A_________________________________________________________= __________________ =0AYahoo! Mail r=E9invente le mail ! D=E9couvrez le nouv= eau Yahoo! Mail et son interface r=E9volutionnaire.=0Ahttp://fr.mail.yahoo.= com