Skip site navigation (1) Skip section navigation (2)

Re: CREATE INDEX error message

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: CREATE INDEX error message
Date: 2002-08-27 21:19:56
Message-ID: 200208272119.g7RLJur19852@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-patches
Your patch has been added to the PostgreSQL unapplied patches list at:

	http://candle.pha.pa.us/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

---------------------------------------------------------------------------


Neil Conway wrote:
> This trivial patches fixes the error message returned by CREATE INDEX
> when it finds an existing relation with the same name as the
> to-be-created index. 
> 
> Old error message:
> 
> nconway=# create table foo (a int);
> CREATE TABLE
> nconway=# create index foo on foo (a);
> ERROR:  index named "foo" already exists
> 
> I replaced 'index' with 'relation' in the error message.
> 
> Cheers,
> 
> Neil
> 
> -- 
> Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC

[ Attachment, skipping... ]

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-patches by date

Next:From: Bruce MomjianDate: 2002-08-27 21:24:01
Subject: Re: [HACKERS] CREATE TEMP TABLE .... ON COMMIT
Previous:From: Bruce MomjianDate: 2002-08-27 21:19:42
Subject: Re: [HACKERS] pg_attribute.attisinherited ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group