Обсуждение: CREATE INDEX error message
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@samurai.com> || PGP Key ID: DB3C29FC
Вложения
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@samurai.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@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
Patch applied. Thanks. --------------------------------------------------------------------------- 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@samurai.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@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073