Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nPr3x-0005b1-3v for pgsql-sql@arkaria.postgresql.org; Thu, 03 Mar 2022 19:24:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nPr3v-00027u-Ox for pgsql-sql@arkaria.postgresql.org; Thu, 03 Mar 2022 19:24:31 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nPr3v-00027A-ED for pgsql-sql@lists.postgresql.org; Thu, 03 Mar 2022 19:24:31 +0000 Received: from mail-pl1-x632.google.com ([2607:f8b0:4864:20::632]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nPr3t-0006PH-BJ for pgsql-sql@lists.postgresql.org; Thu, 03 Mar 2022 19:24:30 +0000 Received: by mail-pl1-x632.google.com with SMTP id e13so5611416plh.3 for ; Thu, 03 Mar 2022 11:24:29 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=message-id:date:mime-version:user-agent:subject:content-language:to :references:from:in-reply-to:content-transfer-encoding; bh=Qia9zpj5sAV6PIrLlVn5KLw1XqWZI3uzxdSq7pngGFo=; b=O5Vnw5SSlaY5buwzvHqFwKDetSZUUK67uA93cVVA0k1110gIb+PW/xdZjMJ1CRI64i gtiVKTbjwDmAIshRNZkno4Yi8s9C+gjvSJ0uJJfuzx7m54hJX1DO6UB+kKxLJp/RTagw HAChRa/BO2MYspmEawNjoIktEeFDpKvrl4vLeLZh2MRR6DhDbpfxf13yKpJa+SmGFyWz ntYuoJdDQmIg1qYh8ANt72VqFnOR7lmlzB8iG0JzDpT9kL9pZdMqH1ZYRViRLWOuh9CW y5ovyCQBO1whREi1JPKZoakp5eEjcK9FAr6zjLGvxkxYoC5NFCpaFh1Y9+U9jlHurs1A 5+qQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:message-id:date:mime-version:user-agent:subject :content-language:to:references:from:in-reply-to :content-transfer-encoding; bh=Qia9zpj5sAV6PIrLlVn5KLw1XqWZI3uzxdSq7pngGFo=; b=M/ZHvZk5IelcBSGYYEDbP5vGwjCfsTBFICCFAqlV52s4r/NxML7hGf5XbgeYGuDU9d 2rSiH8gWqhardgzYRH4w+WVAELlYcxII57Zt+YiThlHAUuErsbz5QYT9ir6ZtgPsck8d zyZxDKvSD3iwSerY65v/fx3EoFotjxFz4OQf3+bKVdK0FVZ+FpOP9XcuuEtsY20BU3e/ 9igg9bYFvuIsy8HOWgYVxuqFOjAfJMBGWBAdWPfRHy0WvZX1Vh4cWgDkcOkuRrvm6b6G rN5o7WcTf7Yk4xAMH3U55oIF2mr1x/GmnE1WrJ3ofEdw6ki1UGNE9GxrFGieIMN73O24 ypww== X-Gm-Message-State: AOAM533PEKI1FodE+J/A8o2oL6c6Hmi1HDDLaVC6SkljOB142UOBvwve rDt6wOQqrxXCg7aYFmxYI9GUzwBNtj8= X-Google-Smtp-Source: ABdhPJyhSTXdBQCkwusynQjqg0QVxI3VrpZZF/07t9GViMbItwroyGdQUA5uU/u2jXL9piQGEjgVUw== X-Received: by 2002:a17:902:a9c3:b0:14d:c5cc:d26c with SMTP id b3-20020a170902a9c300b0014dc5ccd26cmr37756191plr.18.1646335468068; Thu, 03 Mar 2022 11:24:28 -0800 (PST) Received: from [10.128.71.194] ([155.98.131.2]) by smtp.gmail.com with ESMTPSA id 23-20020a17090a0d5700b001bc3c650e01sm9273888pju.1.2022.03.03.11.24.24 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 03 Mar 2022 11:24:24 -0800 (PST) Message-ID: <3e0811bc-b9cd-b7ce-2ba5-21f81a6eba33@gmail.com> Date: Thu, 3 Mar 2022 12:24:23 -0700 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.6.1 Subject: Re: Bug in tables column data in postgres database Content-Language: en-CA To: pgsql-sql@lists.postgresql.org References: From: Rob Sargent In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 3/3/22 11:41, Sarita Sharma wrote: > Dear Sir, > I am working as a Java developer and for backend database I am using > postgres database. I am generating this tables using entity classes of > Java and Jpa configuration to handling database connectivity and table > creation. > I am finding this toggling issue on my day to day work activity . I am > still working with same situation. And I only have to correct data > whenever its value  keeps changing automatically. > Please take my concern . > > It's pretty safe to say the problem is in your Java code but you haven't shown any constructive yet so no one can help you. This isn't really a java discussion list but there are people here who use the language and may be able to help.  You might also try a JPA list. You might try capturing the sql generated from your JPA code as that (sql) is where this list truly shines.