On Tue, Feb 15, 2005 at 12:38:17 +0000, Zoltan Szmutku <[EMAIL PROTECTED]> wrote: > > My next commands : > > 1. > CREATE UNIQUE INDEX kod > ON proba > USING btree > (mezo1) > > 2. > CREATE UNIQUE INDEX kod > ON proba2 > USING btree > (mezo1) > > The second command not success, I get the error message : > > ERROR: relation "kod" already exists > > Why ?
Because you tried to name both indexes the same name. Perhaps you might use something like proba_kod and proba2_kod? ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
