On 2023-09-03 20:19:44 -0400, Amn Ojee Uw wrote:
> I see now, any suggestions as work around in JDBC?
Implement the functionality in Java.
You could do it directly:
execute
SELECT 'CREATE DATABASE jme_test_database' WHERE NOT EXISTS (SELECT FROM
pg_database WHERE datname = 'jme_test_dat
Hello,
I already installed your extension. As of now, I'm having issues in
creating the oracle_fdw. Please advise. Thanks!
postgres=# create extension oracle_fdw;
ERROR: query plan with multiple segworker groups is not supported
HINT: likely caused by a function that reads or modifies data in a
Erik Wienhold writes:
> Anyway, I prepared a patch for the docs.
I think the last hunk of this is plenty sufficient, and the earlier
ones just add noise.
regards, tom lane
On 30/08/2023 03:21 CEST Laurenz Albe wrote:
> I am somewhat surprised too, but it has been like that since commit 8ae0d476a9
> in 2005.
Yeah, unlikely to find out why after 18 years.
> The code is pretty clear about that:
>
> if (superuser == TRI_YES)
> {
> /* Not much point in
I see now, any suggestions as work around in JDBC?
Thanks!!
On 9/3/23 8:12 p.m., David G. Johnston wrote:
On Sunday, September 3, 2023, Amn Ojee Uw wrote:
Are you saying that JDBC cannot handle or process \gexec, since it
is PG-15 exclusive?
psql is a client application present in a
On Sunday, September 3, 2023, Amn Ojee Uw wrote:
>
> Are you saying that JDBC cannot handle or process \gexec, since it is
> PG-15 exclusive?
>
psql is a client application present in all versions of PostgreSQL. It has
a bunch of features related to executing SQL queries. The stuff that it is
d
On 9/3/23 15:25, Amn Ojee Uw wrote:
PD:
Are you saying that JDBC cannot handle or process \gexec, since it is
PG-15 exclusive?
I am saying \gexec is a command unique to the client program psql, it
has no meaning outside of the program. In other words it is not an SQL
command and JDBC wi
On Sun, Sep 3, 2023, 16:25 Amn Ojee Uw wrote:
> Are you saying that JDBC cannot handle or process \gexec, since it is
> PG-15 exclusive?
>
JDBC cannot handle our process \gexec since it is _psql_ exclusive. It's a
command interpreted and evaluated by that client specifically, not by the
Postgres
Thanks Adrian, I did read the link you suggested.
I was had at the Introduction title, since it makes this mention
"/Alternatively, input can be from a file or from command line
arguments./" since the input would be from the back end of the database,
as I am using Java DBC to access the databas
On 9/3/23 09:00, Amn Ojee Uw wrote:
Hello!
This issue really puzzles me beyond intrigue.
Why would this schema:
*SELECT 'CREATE DATABASE jme_test_database' WHERE NOT EXISTS (SELECT
FROM pg_database WHERE datname = 'jme_test_database')\gexec*
work when entered at the psql prompt, but not when p
Hello!
This issue really puzzles me beyond intrigue.
Why would this schema:
*SELECT 'CREATE DATABASE jme_test_database' WHERE NOT EXISTS (SELECT
FROM pg_database WHERE datname = 'jme_test_database')\gexec*
work when entered at the psql prompt, but not when passed as a parameter
in a JDBC metho
Thank you so much for the clarification.
Actually team have used similar partitioning strategy on integer columns in
past. So they are inclined towards that. I will still, double check with
others if any business restrictions exists. But as you already mentioned,
it's not good in terms of data qua
Have your friends also mentioned how it is going to help to convert date
field to integer !???
On Sun, Sep 3, 2023 at 3:51 AM Erik Wienhold wrote:
> On 03/09/2023 00:35 CEST veem v wrote:
>
> > We are trying to create a monthly range partition table , partitioned on
> > column PART_DATE. This w
13 matches
Mail list logo
