On 3/30/24 03:14, Bandi, Venkataramana - Dell Team wrote:
Hi,
Clarifying the problem statement again, Multiple requests are getting to our
application server and using hibernate framework to persist the data into
Postgres SQL DB but for one of the request, it is also similar request like
Hi,
Clarifying the problem statement again, Multiple requests are getting to our
application server and using hibernate framework to persist the data into
Postgres SQL DB but for one of the request, it is also similar request like
other requests and there are no differences b/w these requests
That log snippet shows two different PIDs. Check the logs to see the
complete path that process 1876 took after it did the insert at 2024-02-19
15:21:54.850 +08
Make sure you are not using prepared transactions. This should return 0:
select current_setting('max_prepared_transactions');
Cheers,
On 3/27/24 04:29, Bandi, Venkataramana - Dell Team wrote:
Hi,
As l already mentioned, for this specific node also data is persisting but
sometimes(randomly) data is not persisting.
How do you know which data is not persisting?
As you mentioned our application doesn't have any restrictions
Dell Team
; Alampalli, Kishore
Subject: RE: Query on Postgres SQL transaction
Hi Adrian,
I will check with the customer on below info for that node and will share you.
For instance different OS or OS version, different encoding, different location
on the network, different data it is working
Hi Adrian,
I will check with the customer on below info for that node and will share you.
For instance different OS or OS version, different encoding, different location
on the network, different data it is working, etc.
As I already mentioned we have enabled Postgres SQL debug logs to trace
Sabino
Mullane
Cc: pgsql-general@lists.postgresql.org; Kishore, Nanda - Dell Team
; Alampalli, Kishore
Subject: Re: Query on Postgres SQL transaction
[EXTERNAL EMAIL]
On 3/19/24 02:18, Bandi, Venkataramana - Dell Team wrote:
Hi Greg,
We are using hibernate framework to persist the data into
, Nanda - Dell Team
; Alampalli, Kishore
Subject: Re: Query on Postgres SQL transaction
[EXTERNAL EMAIL]
On 3/19/24 02:18, Bandi, Venkataramana - Dell Team wrote:
> Hi Greg,
>
> We are using hibernate framework to persist the data into Postgres SQL
> DB and data is persisting an
On 3/19/24 02:18, Bandi, Venkataramana - Dell Team wrote:
Hi Greg,
We are using hibernate framework to persist the data into Postgres SQL
DB and data is persisting and committing for all the clients but one of
the client data is not inserted into DB.
What is different about that client
Hi Greg,
We are using hibernate framework to persist the data into Postgres SQL DB and
data is persisting and committing for all the clients but one of the client
data is not inserted into DB.
Not getting any error/exception for this case. Could you please let us know how
we can trace out this
That's a very vague question, but you can trace exactly what is happening
by issuing
SET log_statement = 'all';
Ideally at the session level by your application, but can also set it at
the database and user level. If all else fails, set it globally (i.e.
postgresql.conf). Turn it off again as soo
On 3/14/24 11:04 PM, Bandi, Venkataramana - Dell Team wrote:
Hi Team,
We are using JPA entities to persists the records into Postgres SQL DB
and its working for all the nodes but one of the node data is not
persisting and it’s not giving any DB related errors/exception. We
just want to
Hi Team,
We are using JPA entities to persists the records into Postgres SQL DB and its
working for all the nodes but one of the node data is not persisting and it's
not giving any DB related errors/exception. We just want to trace out this
scenario on transaction level whether transacti
On 1/16/24 10:04 PM, arun chirappurath wrote:
Architect is pressing for a native procedure to data load.
It's possible to write a loader in pl/pgsql but it would be easily twice
as complex as where you got on your first attempt. It would also never
perform anywhere near as well as a dedicated
Hi Jim,
Thank you so much for the kind review.
Architect is pressing for a native procedure to data load.
I shall Google ans try to find more suitable one than writing one by myself.
Thanks again,
Arun
On Wed, 17 Jan, 2024, 01:58 Jim Nasby, wrote:
> On 1/16/24 6:34 AM, arun chirappurath wr
On 1/16/24 6:34 AM, arun chirappurath wrote:
I am trying to load data from the temp table to the main table and catch
the exceptions inside another table.
I don't have a specific answer, but do have a few comments:
- There are much easier ways to do this kind of data load. Search for
"postgre
"*invalid input syntax for type boolean: "15"*"
That is the problem. You can't insert 15 into a column of type "boolean".
On Tue, Jan 16, 2024 at 7:35 AM arun chirappurath
wrote:
> Dear all,
>
> I am an accidental postgres DBA and learning things every day. Apologies
> for my questions if not
On 1/16/24 06:00, Raul Giucich wrote:
Hi Arun, can you share the sql used for this insert. Visually it seems
some character are affecting the data.
Best regards,
Raul
Raul, the OP attached the sq.
Hi Arun, can you share the sql used for this insert. Visually it seems some
character are affecting the data.
Best regards,
Raul
El mar, 16 ene 2024 a la(s) 9:35 a.m., arun chirappurath (
arunsnm...@gmail.com) escribió:
> Dear all,
>
> I am an accidental postgres DBA and learning things every day
Dear all,
I am an accidental postgres DBA and learning things every day. Apologies
for my questions if not properly drafted.
I am trying to load data from the temp table to the main table and catch
the exceptions inside another table.
temp table is cast with the main table data type and trying t
On Wed, Jul 19, 2023, 22:40 Anthony Apollis
wrote:
> Hi
>
> What list can i post sql related errors etc?
>
This is a good place to start, but you may want to review
https://wiki.postgresql.org/wiki/Guide_to_reporting_problems to make it
easier to get help if you're not already familiar with it.
Hi
What list can i post sql related errors etc?
> On Sep 5, 2022, at 23:10, Karthik K L V wrote:
> The above query fails with the below exception when the value of ?1 resolves
> to null.
> org.postgresql.util.PSQLException: ERROR: operator does not exist: character
> varying = bytea
> Hint: No operator matches the given name and argument
On 9/6/22 02:10, Karthik K L V wrote:
We are migrating from Oracle 12C to Aurora Postgres 13 and running
into query failures when the bind value of a Text datatype resolves to nul
Oracle is actually in the wrong here. Nothing should be equal to null,
ever. There is also different behavior with
> org.postgresql.util.PSQLException: ERROR: operator does not exist: character
> varying = bytea
This has been discussed on Stack Overflow[0].
The answer with the highest approval suggests to use coalesce[1]:
```
Select * from A where middle_name = coalesce(?1)
```
Lutz
[0] https://stackover
Hi Team,
We are migrating from Oracle 12C to Aurora Postgres 13 and running into
query failures when the bind value of a Text datatype resolves to null.
The same query works fine in Oracle without any issues. We use
SpringDataJPA and Hibernate framework to connect and execute queries and
the appl
On Thu, Jan 13, 2022 at 4:32 PM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Thu, Jan 13, 2022 at 8:55 AM Shaozhong SHI
> wrote:
>
>>
>> How to create an event trigger in Postgres? When a user finished loading
>> a new table on to it, the trigger can start off an script 10 minutes
On Thu, Jan 13, 2022 at 8:55 AM Shaozhong SHI
wrote:
> That looks interesting. Is there an excellent example to do the following?
>
> How to create an event trigger in Postgres? When a user finished loading
> a new table on to it, the trigger can start off an script 10 minutes after
> the event
Hi, Jay,
That looks interesting. Is there an excellent example to do the following?
How to create an event trigger in Postgres? When a user finished loading a
new table on to it, the trigger can start off an script 10 minutes after
the event?
Regards,
David
On Thu, 13 Jan 2022 at 10:50, Jaya
When a user load a new table in the Postgres System? Can a script
> automatically detect it and run?
>
> Are you looking for Even triggers?
https://www.postgresql.org/docs/current/event-triggers.html
Regards,
Jay
When a user load a new table in the Postgres System? Can a script
automatically detect it and run?
Regards,
David
31 matches
Mail list logo