Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 0AFE6633E29 for ; Thu, 11 Jun 2009 04:31:31 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 21618-03 for ; Thu, 11 Jun 2009 04:31:22 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.187]) by mail.postgresql.org (Postfix) with ESMTP id 2A003633C35 for ; Thu, 11 Jun 2009 04:31:25 -0300 (ADT) Received: from webserv.wug.de ([194.25.154.138]) by mrelayeu.kundenserver.de (node=mreu2) with ESMTP (Nemesis) id 0MKv5w-1MEekl2g8I-00018K; Thu, 11 Jun 2009 09:31:23 +0200 Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1) id 1MEekc-0007IL-00 for pgsql-sql@postgresql.org; Thu, 11 Jun 2009 09:31:06 +0200 Date: Thu, 11 Jun 2009 09:31:06 +0200 From: "A. Kretschmer" To: pgsql-sql@postgresql.org Subject: Re: Avoiding "will create implicit index" NOTICE Message-ID: <20090611073106.GB16593@a-kretschmer.de> References: <4A242CC4.5000400@obviously.com> <5c4ddc540906011321v2162f928v451cca8833a44e20@mail.gmail.com> <4A30A239.8080700@obviously.com> <4A30AC42.1060709@obviously.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4A30AC42.1060709@obviously.com> X-OS: Debian/GNU Linux - weil ich es mir Wert bin! User-Agent: Mutt/1.5.9i X-Provags-ID: V01U2FsdGVkX1/uqyFEimNja0DiqBZgT/6sSc+90xrogPeAkwR OsRZSM4/PhVQh1nwl/ZV756kPFXYPGOfiz3kNKm9RBHne783wo fHrTHDG/BkgELGPyu8Tfg== X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.037 tagged_above=0 required=5 tests=AWL=0.037 X-Spam-Level: X-Archive-Number: 200906/50 X-Sequence-Number: 32655 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 -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net