Re: indexes on primary and foreign keys

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Michael Glaesemann <grzm(at)myrealbox(dot)com>
Cc: K C Lau <kclau60(at)netvigator(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: indexes on primary and foreign keys
Date: 2006-01-12 01:40:57
Message-ID: 20060112014057.GA89601@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2006-01-12 03:23:55 Re: Extremely irregular query performance
Previous Message Michael Glaesemann 2006-01-12 01:26:58 Re: indexes on primary and foreign keys