Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 7A68F475EDC
	for <pgsql-sql@postgresql.org>; Wed, 22 Jan 2003 04:37:51 -0500 (EST)
Received: from localhost.localdomain (unknown [216.31.142.3])
	by postgresql.org (Postfix) with ESMTP id 9FB49475BC3
	for <pgsql-sql@postgresql.org>; Wed, 22 Jan 2003 04:37:49 -0500 (EST)
Received: from larubber.com (server [127.0.0.1])
	by localhost.localdomain (8.11.6/8.11.6) with SMTP id h0MABWP21080
	for <pgsql-sql@postgresql.org>; Wed, 22 Jan 2003 02:11:32 -0800
Received: from 216.86.192.34 (SquirrelMail authenticated user ddurst)
	by www.la-rubber.com with HTTP; Wed, 22 Jan 2003 02:11:32 -0800 (PST)
Message-ID: <34547.216.86.192.34.1043230292.squirrel@www.la-rubber.com>
Date: Wed, 22 Jan 2003 02:11:32 -0800 (PST)
Subject: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
From: "David Durst" <ddurst@larubber.com>
To: <pgsql-sql@postgresql.org>
X-Priority: 3
Importance: Normal
X-MSMail-Priority: Normal
Reply-To: ddurst@larubber.com
X-Mailer: SquirrelMail (version 1.2.7)
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200301/325
X-Sequence-Number: 11190

Can anyone tell me why postgres is creating a implicit index when
I already have a PKEY specified????

Or am I just interpreting this all wrong?

Here is the entry I am putting in:

create sequence journal_line_id_seq increment 1 start 1;

create table journal_lines (
  journal_line_id int4 PRIMARY KEY DEFAULT NEXTVAL('journal_line_id_seq'),
  entry_id int4,
  account_id int4,
  line_type int2 CHECK (line_type >= 1 AND line_type <= 2),
  line_amount money,
  CONSTRAINT eid FOREIGN KEY(entry_id) REFERENCES journal(entry_id),
  CONSTRAINT aid FOREIGN KEY(account_id) REFERENCES accounts(account_id)
);

Here is the notice postgres spits out:
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'journal_lines_pkey' for table 'journal_lines'
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
CREATE TABLE