DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:content-type:content-transfer-encoding;
	b=ZFy7cA9kgHq1EpBYk3k+zQzOTPgj/v6BOpPRYxjRpHcCvs9Jl6Qkxlnx5GQBxzemDO
	2eMv/+tsQEJTYFC9s6BlRGLz1ruw0kql0x4xpAMcA3N6zgIlNb4FqkSke4Ey+aglW44O
	WfdthF6UDoc06XxHF6xnGcgtJl+/9pf0v9i1c=
Message-ID: <4A312B53.7010000@gmail.com>
Date: Thu, 11 Jun 2009 10:05:39 -0600
From: Rob Sargent <robjsargent@gmail.com>
User-Agent: Thunderbird 2.0.0.21 (X11/20090318)
MIME-Version: 1.0
To: "A. Kretschmer" <andreas.kretschmer@schollglas.com>
CC: pgsql-sql@postgresql.org
Subject: Re: Avoiding "will create implicit index" NOTICE
References: <4A242CC4.5000400@obviously.com>
	<5c4ddc540906011321v2162f928v451cca8833a44e20@mail.gmail.com>
	<4A30A239.8080700@obviously.com> <4A30AC42.1060709@obviously.com>
	<20090611073106.GB16593@a-kretschmer.de>
In-Reply-To: <20090611073106.GB16593@a-kretschmer.de>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

A. Kretschmer wrote:
> In response to Bryce Nesbitt :
>   
>> Hmm, no.  I still get the NOTICE. How can I create the primary key
>> without triggering a NOTICE?
>>     
>
> Sure, set client_min_messages='...'
>
> test=*# create table bla(id int primary key);
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "bla_pkey" for table "bla"
> CREATE TABLE
> test=*# rollback;
> ROLLBACK
> test=# set client_min_messages='warning';
> SET
> test=*# create table bla(id int primary key);
> CREATE TABLE
> test=*#
>
>
> Andreas
>   
Funny thing is I'm using set client_min_message in my own scripts!

Also was assuming OP was in a scripting/temp-table mode and that the 
notion of explicit primary key (vs. simply stating the index) isn't of 
great value in that realm I don't think.