Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 78406 invoked from network); 15 Aug 2007 14:11:18 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 15 Aug 2007 14:11:18 -0000 Received: (qmail 29072 invoked by uid 500); 15 Aug 2007 14:11:14 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 29024 invoked by uid 500); 15 Aug 2007 14:11:14 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 29004 invoked by uid 99); 15 Aug 2007 14:11:14 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 15 Aug 2007 07:11:14 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of kubjon@gmail.com designates 64.233.182.186 as permitted sender) Received: from [64.233.182.186] (HELO nf-out-0910.google.com) (64.233.182.186) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 15 Aug 2007 14:11:12 +0000 Received: by nf-out-0910.google.com with SMTP id d3so874665nfc for ; Wed, 15 Aug 2007 07:10:51 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=grwuJB10GobSr/BFARaW4l7qXz3nBdQunQaOJVkjP3XzTEgq0FEt2OPYGVs63z3u8AO7UyYWmgN5JdWLXogIjB866GpY6/cukV3woXC5hO3y4/hKVd+qWpRu42K02hYr3D84JwFUDt2p40dIDPPAnAQTSwygEvgU0NyVR8rWV7U= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=BRKzFkDLSgcJPqBAp8c1d975lpgOz6lQxuyIvOwpb5YhoPt7ynRgZ1YEUNB1GCjIwCTmNaePReoQGXntUtVsP7u57EMpdjMn7g3aQZL50CeGPXxYbc415Ocsd5V2H+havnXgCufdIwhZNCbm0f1xT1Uo1mgyuLvuwhLvDTianuM= Received: by 10.82.170.2 with SMTP id s2mr925421bue.1187187050510; Wed, 15 Aug 2007 07:10:50 -0700 (PDT) Received: by 10.82.107.9 with HTTP; Wed, 15 Aug 2007 07:10:50 -0700 (PDT) Message-ID: <9be95d420708150710l135e4f58p6ff649ecfe533c44@mail.gmail.com> Date: Wed, 15 Aug 2007 15:10:50 +0100 From: "Jakub Jonik" To: derby-user@db.apache.org Subject: Identity column MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Checked: Checked by ClamAV on apache.org I am trying to add an Identity column to an existing table with the following SQL: ALTER TABLE DummyTable ADD COLUMN DummyColumn GENERATED BY DEFAULT AS IDENTITY START WITH 1, INCREMENT BY 1. And I am getting the error: SQL state 42601: ALTER TABLE statement cannot add an IDENTITY column to a table. Is there any way to work around this? Thanks Jakub