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 1thlfl-006dW0-9z for pgsql-docs@arkaria.postgresql.org; Tue, 11 Feb 2025 08:31:13 +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 1thlfj-008nbu-Vy for pgsql-docs@arkaria.postgresql.org; Tue, 11 Feb 2025 08:31:12 +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 1thlfj-008nbh-9a for pgsql-docs@lists.postgresql.org; Tue, 11 Feb 2025 08:31:11 +0000 Received: from fout-a8-smtp.messagingengine.com ([103.168.172.151]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1thlfd-000Brr-2Q for pgsql-docs@lists.postgresql.org; Tue, 11 Feb 2025 08:31:10 +0000 Received: from phl-compute-01.internal (phl-compute-01.phl.internal [10.202.2.41]) by mailfout.phl.internal (Postfix) with ESMTP id B0B2813808AD; Tue, 11 Feb 2025 03:31:03 -0500 (EST) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-01.internal (MEProxy); Tue, 11 Feb 2025 03:31:03 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:reply-to :subject:subject:to:to:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm3; t=1739262663; x=1739349063; bh=VQo8Rt+SILpLQ WkOtPOGj/R5ZfwfKiYLGRX//AiUfw8=; b=odVaQPy84QC9XV10+S2G8C57l4fCf fmS2xh38InL0vWEzMgw5/+VBzB/8uj+OacQQtmKSH5HZYgoRB3Oid+qo0sO/xmSA tfnT40qq6NwHVsix+GdMBrQPf2a/9lmwBoE0Y8rUuRLM4FXSI0HCDn4Ju5+0BYJ/ d8zeA84DVBbYcB6uP9YHx9WlZ0gU4ZU7hlesQ4Pxfb1Io22Xc/DTqt71+3NDBTYn hmsc3ALuCyZ5m5toOe8kgZ73lwa/D5TP7dJh8DMGrTgs/V70wsJ766pZtAePvzOk ZJELB5K7kqVyv+UkQQRkSd2vzxEqrwxK4pBkYNKIEkvWkRpNIPzudNZOQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgdegtdehvdcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdp uffrtefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecunecujfgurhepfffhvf fukfggtggugfgjsehtkeertddttdejnecuhfhrohhmpemllhhvrghrohcujfgvrhhrvghr rgcuoegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhgqeenucggtffrrghtth gvrhhnpeduveegteeiieehfeduveevfeegjeeijedtveetkeeklefggfelgeethedvudet geenucffohhmrghinhepvghnthgvrhhprhhishgvuggsrdgtohhmnecuvehluhhsthgvrh fuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprghlvhhhvghrrhgvsegrlhhv hhdrnhhoqdhiphdrohhrghdpnhgspghrtghpthhtohepvddpmhhouggvpehsmhhtphhouh htpdhrtghpthhtohepsghlvghsshihgeehiegsthhhohhmrghssehgmhgrihhlrdgtohhm pdhrtghpthhtohepphhgshhqlhdqughotghssehlihhsthhsrdhpohhsthhgrhgvshhqlh drohhrgh X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 11 Feb 2025 03:31:03 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=alvh.no-ip.org; s=schmee; t=1739262661; bh=MNregFtx60Ej1odzFvANtChQw78Rqp2/zB46+QBpe1Y=; h=Date:From:To:Subject:In-Reply-To:From; b=MXflOg/FOb5bGBW87M0OSb1pkpTjAFU9w08C4dKRjfWsGSdPMLliOUtptsHSHA4dN vvbP//hnKMHUmktG3R7j5gShenClD7PHilMkFbkULNpZvRP3Vbq7y+ss+LFxWxxSH4 w9tqI9CrlHefp9kZ9GaQDXd/Xgqw48H7yhF/JWiDOUEllz0iAdCEF3DFSnZTRRrXIo xRMlibgQO7vlseoFvld+a0jPPCx1RHfY9UdXJMyJtbTHdtuY2nX2QsSiXDgs81XMs0 WfZty25Yu3+Ds7Cd6PncUb64jGevKd7pbKxAi9KfA04+/Vo3iT7owbO1ZIIFbQ+sU4 XVCtWapDB5zmQ== Received: by schmee.alvh.no-ip.org (Postfix, from userid 1000) id 68ABA8D; Tue, 11 Feb 2025 09:31:01 +0100 (CET) Date: Tue, 11 Feb 2025 09:31:01 +0100 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: blessy456bthomas@gmail.com, pgsql-docs@lists.postgresql.org Subject: Re: Regarding experiencing Message-ID: <202502110831.dgzemrqpnp4y@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <173926144817.707.5435160037273260016@wrigleys.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello On 2025-Feb-11, PG Doc comments form wrote: > ISSUE : According to the above paragraph , locks should either be shared or > exclusive. But when I tried assigning a shared lock and exclusive lock > without unlock of the shared lock , it doesn't show a conflict. I think this > may contradict what is said in above paragraph of documentation. Can you > enlighten me more on this , regarding the understanding if my assumption is > wrong. Your understanding is correct -- there should be a conflict. The lack of one suggests that you're using the lock interfaces incorrectly. Please show the exact commands you're running. Maybe there's something about the documentation text that needs to be made clearer. > I could have attached snaps of the same but I don't find an > attachment option. True. You can reply to this email with attachments. However, I would instead suggest to copy and paste text from terminal window(s), rather than screenshots. -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/