Re: JDBC + PG-15 but not psql

2023-08-22 Thread Amn Ojee Uw
Yes your are right! I don't know why it was part of the requirement to add a JDBC line to explicitly set the behaviour of autocommint to *true*, when it was the default value. Perhaps it has to do with "just making sure it is" sort of thing. Thanks Dave, I'll let the my group know. On 8/22/23

Re: JDBC + PG-15 but not psql

2023-08-22 Thread Dave Cramer
Hi Amn, What I don't understand is the requirement to set autocommit to true since this is the default ? Either way this is expected behaviour as psql also has autocommit true by default. Thanks, Dave Cramer On Mon, 21 Aug 2023 at 20:57, Amn Ojee Uw wrote: > Thanks Dave for your interest.

Re: JDBC + PG-15 but not psql

2023-08-21 Thread Amn Ojee Uw
Thanks Dave for your interest. InĀ  the OP I started by explaining the difficulties when trying to create a tabelspace using JDBC; please note that when using the PG-15 prompt I did not have the problem. Well, it turns out that while developing the request for help (writing the email), I realiz

Re: JDBC + PG-15 but not psql

2023-08-21 Thread Dave Cramer
Hi Amn, Can you help me understand this issue better? I don't see anywhere in the code where you are attempting to create a tablespace ? Dave Cramer On Sun, 20 Aug 2023 at 11:17, Amn Ojee Uw wrote: > Hello. > > I have searched the net in an attempt to find if others have had and > resolved

JDBC + PG-15 but not psql

2023-08-20 Thread Amn Ojee Uw
Hello. I have searched the net in an attempt to find if others have had and resolved this challenge, but most of the sites talk about how, when using the psql, this error arises. In my case, the error arises only when access PG-15 using JDBC. JDBC connects to the database, but when trying to e