NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index

From: "David Durst" <ddurst(at)larubber(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
Date: 2003-01-22 10:11:32
Message-ID: 34547.216.86.192.34.1043230292.squirrel@www.la-rubber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Hostbaek 2003-01-22 10:14:28 Re: optimal sql
Previous Message Michael Paesold 2003-01-22 10:03:47 Re: optimal sql