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 1sCnVp-008BJe-1P for pgsql-sql@arkaria.postgresql.org; Thu, 30 May 2024 21:40:42 +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 1sCnVo-006IFy-LQ for pgsql-sql@arkaria.postgresql.org; Thu, 30 May 2024 21:40:40 +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 1sCnVo-006IFq-Bo for pgsql-sql@lists.postgresql.org; Thu, 30 May 2024 21:40:40 +0000 Received: from mail-ej1-f48.google.com ([209.85.218.48]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sCnVi-001ZSs-Pk for pgsql-sql@lists.postgresql.org; Thu, 30 May 2024 21:40:39 +0000 Received: by mail-ej1-f48.google.com with SMTP id a640c23a62f3a-a673a60f544so63171866b.3 for ; Thu, 30 May 2024 14:40:34 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1717105234; x=1717710034; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=vzbpzGd6AoT1shP6e3iqDXj5zjTW8Y4JNe26/64WHRg=; b=xSMqR8oRhaJfgzopx4RmtPFv2bfPPWEht6+kcEV1832DFzhfWwH/vBnxY9PiZvzrFz 7I7cxf7+TSp2Uf2vqXswETI7d/P8gMfHpEODmTRVio3IpeEvzcfIOMK9ndPQPrqoopTk eu1wHnR9PbaE0MW6CLVZM8xCdVImgvEg21mGyWhbGOEXTtooSxUOu1d5ijDPSXyN7TUc C+F+SYuGeqPZpaWc4MdMPW2EJnZFemuMogEERz+glChbMKHs+AoMxM7RnipyKpJng2zZ rayb9F6IDph29bEqebO7LjbelLfWp1UOH6Ca9C93CyDhta5aJpOgrw4++sPAxBOQf51a J6fQ== X-Gm-Message-State: AOJu0Yww6BPwJv/wBMfzG2tiqlRG7wjmVYVAvdDFFSndxFqpfoyXPh8P 7m/eVibAmfWEimx1gFLr1B3Rsqg+Oqq8P0hHoKfUMi5NtKcVART5NjCrxQbA X-Google-Smtp-Source: AGHT+IHYVPih464NWj7hDhjwosuz2I1kr+BjKnlPZ2Y7yMGY9CcYxo+5BFhfWHg2+1jhx0rSw9l90Q== X-Received: by 2002:a17:906:a3d6:b0:a5a:1579:9033 with SMTP id a640c23a62f3a-a681fc5bbeemr6337566b.1.1717105233319; Thu, 30 May 2024 14:40:33 -0700 (PDT) Received: from mail-wr1-f45.google.com (mail-wr1-f45.google.com. [209.85.221.45]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-a67e6f03094sm18121866b.30.2024.05.30.14.40.32 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 30 May 2024 14:40:32 -0700 (PDT) Received: by mail-wr1-f45.google.com with SMTP id ffacd0b85a97d-35dbfe31905so1483087f8f.2 for ; Thu, 30 May 2024 14:40:32 -0700 (PDT) X-Received: by 2002:a05:600c:3b0d:b0:41b:fc3a:f1ef with SMTP id 5b1f17b1804b1-4212e0b08f7mr295625e9.33.1717105232438; Thu, 30 May 2024 14:40:32 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Steve Midgley Date: Thu, 30 May 2024 14:40:19 -0700 X-Gmail-Original-Message-ID: Message-ID: Subject: Re: Pgadmin 4 cannot add or modify line in a view To: intmail01 Cc: pgsql-sql@lists.postgresql.org Content-Type: multipart/alternative; boundary="0000000000006bf2b80619b2b702" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000006bf2b80619b2b702 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thu, May 30, 2024 at 7:25=E2=80=AFAM intmail01 wro= te: > Hi, > I tried to modify and add manuallly a line in a view with pgadmin4 but th= e > interface doesnt allow it because cells are locked and no empty line to a= dd > 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. > > This group supports the postgres sql language. I think some people here might use pgadmin4 (I don't), but I think you'd be better served by the pgadmin support list (and docs !). Steve --0000000000006bf2b80619b2b702 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


=
On Thu, May 30, 2024 at 7:25=E2=80=AF= AM intmail01 <intmail01@gmail.com= > wrote:
=
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.

This group = supports the postgres sql=C2=A0language. I think some people here might use= pgadmin4 (I don't), but I think you'd be better served by the pgad= min support list (and= docs!).=C2=A0

--0000000000006bf2b80619b2b702--