Mailing-List: contact ddlutils-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ddlutils-user@db.apache.org
Received-SPF: pass (asf.osuosl.org: domain of tomdzk@gmail.com designates
 66.249.92.173 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=CYHriK7+GTzB+63OovCkJ3YxZHbNbTk1iyj+EBdH5fFPUsEZBSfuvIUxciX3rnzx8cliZGUWwwVbtzUMqORTJQqFRqESJs70mRkQ6eCqYKex8omTxyNEtyAjM0Sl/9DMeXHCTYKPgKMV+F1rEaRCl34QHvIqoLIFbg6hJg/Y4EU=
Message-ID: <224f32340608240942g28934440wf80ee23ab1c5dc59@mail.gmail.com>
Date: Thu, 24 Aug 2006 09:42:18 -0700
From: "Thomas Dudziak" <tomdzk@gmail.com>
To: ddlutils-user@db.apache.org
Subject: Re: autoincrement
In-Reply-To: <44EBF085.4060902@berkeley.edu>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <44EBA2B0.4060208@berkeley.edu>
	 <224f32340608222231y2bf91e88ta2e14b6d094c9cf8@mail.gmail.com>
	 <44EBEE62.6080500@berkeley.edu> <44EBF085.4060902@berkeley.edu>

On 8/22/06, Rusty Wright <rusty@berkeley.edu> wrote:

> I'm also getting some warning that I don't understand (I'm a postgresql
> newbie):
>
> > CREATE SEQUENCE
> > psql:waitlist_generated.sql:40: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "waitlist_pkey" for table "waitlist"
> > CREATE TABLE

That's normal. PostgreSQL simply informs you that it will create an
index for the primary key (since you didn't specify one yourself).
Just ignore it.

> (I don't even know how to examine the tables that I've just created.  Duh.)

There's a commandline tool (called psql or pgsql or something like
this). On Windows, you also get a graphical client with your
PostgreSQL installation.
Since you're using Java, you can also use the great Squirrel SQL tool
(http://squirrel-sql.sourceforge.net/).

Tom