From: David Durst <ddurst@larubber.com>
To: pgsql-sql@postgresql.org
Subject: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
Date: Wed, 22 Jan 2003 02:11:32 -0800 (PST)
Message-ID: <34547.216.86.192.34.1043230292.squirrel@www.la-rubber.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ddurst@larubber.com
Subject: Re: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
In-Reply-To: <34547.216.86.192.34.1043230292.squirrel@www.la-rubber.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox