Re: indexes on primary and foreign keys - Mailing list pgsql-performance

From Michael Fuhr
Subject Re: indexes on primary and foreign keys
Date
Msg-id 20060112014057.GA89601@winnie.fuhr.org
Whole thread Raw
In response to Re: indexes on primary and foreign keys  (Michael Glaesemann <grzm@myrealbox.com>)
List pgsql-performance
On Thu, Jan 12, 2006 at 10:26:58AM +0900, Michael Glaesemann wrote:
> 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].

Or client_min_messages, depending on where you don't want to see
the notice.

--
Michael Fuhr

pgsql-performance by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: indexes on primary and foreign keys
Next
From: Tom Lane
Date:
Subject: Re: Extremely irregular query performance