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 1sCgjO-007Oq0-Eb for pgsql-sql@arkaria.postgresql.org; Thu, 30 May 2024 14:26:15 +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 1sCgiO-003y78-Rg for pgsql-sql@arkaria.postgresql.org; Thu, 30 May 2024 14:25: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 1sCgiO-003y6n-Gm for pgsql-sql@lists.postgresql.org; Thu, 30 May 2024 14:25:12 +0000 Received: from mail-oi1-x234.google.com ([2607:f8b0:4864:20::234]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sCgiH-001WbQ-Fi for pgsql-sql@lists.postgresql.org; Thu, 30 May 2024 14:25:11 +0000 Received: by mail-oi1-x234.google.com with SMTP id 5614622812f47-3d1c077b9baso440855b6e.0 for ; Thu, 30 May 2024 07:25:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1717079104; x=1717683904; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=d5rCjEphUplUBqBCsLxOgyKAj9Tx0fV1dz8+CUF+7ms=; b=PlPNQxOV4vo4JzAPYRbB+oybSPIVLvkMhiLyhTQEoPD658Qn7HAcwnXuDjcyQGYbI9 rSWg7iiCrjr1Y5cFiJb1EaRwy3jo8rPDc2+BMIaO+xJzZjrvF+Xn2M3CZx0OGiQ6X8cA NtI55f/9p5kVoqTvKa5YmRLk8RHCMOR8B+TMo+VaeRS4ce/UUVYHcnYc6+bt7X8NDCF8 K1nIpEF3cdEYQ4Y3o0LmC7hyhnxcm3K2f0cOJVWLkjGVeXIOxnyulP1hb2bjWFqm0REx B9eGltynN4MaetflI5vxSPSOyXvJ5ezqJCUf+LfIqSp3wYGFd0hGfWul6timvlkBAI15 TyLw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1717079104; x=1717683904; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=d5rCjEphUplUBqBCsLxOgyKAj9Tx0fV1dz8+CUF+7ms=; b=X5PzZb6WD1EW2lqoQNA3+Y4ZjQr4y+2z5HZ2wsUEAnwqqHpPJsqkox9cbepXNLrfhU 8ZHq30kjwJ1tTQ3p1/yaoJsT1DPuFIKWZ3HQILQnlIqxyQNMRyzV3z/66PXqzKXfJAV3 uO7BcmlKkLpxOQcX2eYgEPLOcJpVqnZX11mVkUTltYlBNHzONUOyPcIepAl3BTOn22Ni fkx0gh+DDbtcsGnftwKPqYMEvNjQbiib7eUgUKbJ64VDLpI0sio59V2nVlm1/U10Poc/ IfuZXDSO9LWv8gPDmUZD0O+HrXfyZTqUHLm3TS2lIEcGKXvuoLbYDOhMQKAq756eoteJ c9pQ== X-Gm-Message-State: AOJu0YwTIyFs54UgSGS31No9iv90YINfQZksSOxJSxsp0YmN3j70rCD9 1K2inoObzFH1YLQ2MNIkoPyPDrE01SkB/9GI4Ck/j6CYeNVz5r+jU7uuMPbQ8zvwZYOIEN5tJCl AAF+eXZ2sYdyjrR069SfrgLdPlJZ6ywVI+/g= X-Google-Smtp-Source: AGHT+IEswQ4ppN527STcLUqbLzTnaYw3XQer7V0qyCVpMtfCDNKjdl7SXgJEWKwwHc5YP51rgOxcjIYYpqtU/YDRAdk= X-Received: by 2002:a05:6808:6241:b0:3c7:48ba:2190 with SMTP id 5614622812f47-3d1dcd329camr1938762b6e.57.1717079103669; Thu, 30 May 2024 07:25:03 -0700 (PDT) MIME-Version: 1.0 From: intmail01 Date: Thu, 30 May 2024 17:26:25 +0300 Message-ID: Subject: Pgadmin 4 cannot add or modify line in a view To: pgsql-sql@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000068fae0619aca2e1" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000068fae0619aca2e1 Content-Type: text/plain; charset="UTF-8" Hi, I tried to modify and add manuallly a line in a view with pgadmin4 but the interface doesnt allow it because cells are locked and no empty line to add new one. The same issues for Libreoffice Base interface. If I do the operation with command UPDATE then it works well . How to permit pgadmin4 to not lock the interface ? I run postgresql 14.1. Thanks --000000000000068fae0619aca2e1 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,
I tried to modify and add manuallly a l= ine in a view with pgadmin4 but the interface doesnt allow it because cells= are locked and no empty line to add new one.
The same issues for= Libreoffice Base interface.

If I do the operation= with command UPDATE then it works well .
How to permit pgadm= in4 to not lock the interface ?

I run p= ostgresql 14.1.

Thanks
--000000000000068fae0619aca2e1--