Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qixyn-008gkZ-Kf for pgsql-admin@arkaria.postgresql.org; Wed, 20 Sep 2023 14:15:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qixyl-000UcM-TZ for pgsql-admin@arkaria.postgresql.org; Wed, 20 Sep 2023 14:14:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qixyl-000Ubz-Ew for pgsql-admin@lists.postgresql.org; Wed, 20 Sep 2023 14:14:59 +0000 Received: from mail-ej1-x629.google.com ([2a00:1450:4864:20::629]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qixyi-006KWD-Gj for pgsql-admin@lists.postgresql.org; Wed, 20 Sep 2023 14:14:58 +0000 Received: by mail-ej1-x629.google.com with SMTP id a640c23a62f3a-99c93638322so218664266b.1 for ; Wed, 20 Sep 2023 07:14:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1695219294; x=1695824094; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=nKgkqx4BbrNlzmqIQYcVdhqwvSBCjNhfFtV4Mgt75Qw=; b=lzqoSfYh4oDIIJk8+8jL3zwV2x8pIkr8hat0kpyWsi//9aSuOpehTTQlpO2kDej+Zm L9ew9BubbZdmCIQBaoDHLF1QIkUWILZYrFh5xsCwOwryvtt6YxPGu8HsM6ANOdw9Q3C9 fUCgHRegU3zqLReTnJa/sKfNbbjuXV55RzzraRmVNqzjicaaLJUOcC5UneY5lh3bw9d1 t1Oxsl8pMKLtREak9vWrqQA8GaSrQXjui/PhorNwCZLaCQazAybg04u7brQlEHLdzOCi pviIlCsQezs20nGvHxL0cmefvq60V80Ox0obPfFssLpaenr3mqMhN1G5BIZkPbV9ulle 9iUQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1695219294; x=1695824094; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=nKgkqx4BbrNlzmqIQYcVdhqwvSBCjNhfFtV4Mgt75Qw=; b=ZdhOp3bgzBt6J9yBKwpCBUlLrEjG5lkf0SGssIRvl6WHY4sO+pn50TjuOH7CVD1CJz AmLhj3DaBP1CJd8XHpvkPNRlmN3mxcfoaqeFd63L+a/ORPsG+9ew36YaituMjXFnrGkU vuOCAFCsPg0j15Ep7At5T51sxnTIQZfOvbFxy4mDWCQKCrR38JOKmg9gWdtzMe6NY/co /3DgfeI37/9KLVQfqyQpY3hfpp//RJQYfJwynp3sbfupC9+YdhTJZGCMAqZrwGkgB5c8 krsD3vyPa80X1CGaP4TUYNxoGtOG5x+FGtv/RFYNcHm7HVGCet/Hi3hhz3ERh2cVVpqt pESg== X-Gm-Message-State: AOJu0YypN/aKEgKoXdn5yd+OLktBlaNrM4IJqkAsCva/w7fh9ZsHkAwR U3g3C6m29I9yJawLKhMVtoLyAA== X-Google-Smtp-Source: AGHT+IG4UOtyXuCOKtV3rgxuE+TIDgJqhRoiNyVUKxXkknNj09evBAj8Hyf6HzoCKQUQ1Dy6m2ZlOw== X-Received: by 2002:a17:907:868e:b0:9aa:1dc9:1474 with SMTP id qa14-20020a170907868e00b009aa1dc91474mr8101481ejc.33.1695219294577; Wed, 20 Sep 2023 07:14:54 -0700 (PDT) Received: from localhost.localdomain (178-190-171-65.adsl.highway.telekom.at. [178.190.171.65]) by smtp.gmail.com with ESMTPSA id f26-20020a170906495a00b0099d45ed589csm9317358ejt.125.2023.09.20.07.14.53 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 20 Sep 2023 07:14:53 -0700 (PDT) Message-ID: <3983831447229a17fc9028fd2f5b2aaf0996c291.camel@cybertec.at> Subject: Re: Unique index From: Laurenz Albe To: Rajesh Kumar , Pgsql-admin Date: Wed, 20 Sep 2023 16:14:52 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.48.4 (3.48.4-1.fc38) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2023-09-20 at 19:16 +0530, Rajesh Kumar wrote: > Why unique index is used over unique constraints? A unique constraint is implemented by a unique index. If you create the constraint, the index is created automatically. You cannot drop the index unless you drop the constraint. Yours, Laurenz Albe