Re: indexes on primary and foreign keys

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: K C Lau <kclau60(at)netvigator(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: indexes on primary and foreign keys
Date: 2006-01-12 01:26:58
Message-ID: BA99EEFA-8C9E-474E-A69B-62C354F53531@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


On Jan 12, 2006, at 9:36 , K C Lau wrote:

>> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
>> "cities_pkey" for table "cities"
>
> Is there a way to suppress this notice when I create tables in a
> script?

Set[1] your log_min_messages to WARNING or higher[2].

[1](http://www.postgresql.org/docs/current/interactive/sql-set.html)
[2](http://www.postgresql.org/docs/current/interactive/runtime-config-
logging.html#RUNTIME-CONFIG-LOGGING-WHEN)

Michael Glaesemann
grzm myrealbox com

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Fuhr 2006-01-12 01:40:57 Re: indexes on primary and foreign keys
Previous Message Simon Riggs 2006-01-12 00:48:36 Re: NOT LIKE much faster than LIKE?