On Fri, 11 Apr 2025 at 09:39, Fujii Masao
wrote:
>
>
> On 2025/04/11 18:27, Dave Cramer wrote:
> >
> >
> > On Fri, 11 Apr 2025 at 05:05, Fujii Masao <mailto:masao.fu...@oss.nttdata.com>> wrote:
> >
> >
> >
> > On 2025/0
On Fri, 11 Apr 2025 at 05:05, Fujii Masao
wrote:
>
>
> On 2025/04/11 5:17, Dave Cramer wrote:
> > No, you are correct.
> >
> > See new patch
>
> Thanks for updating the patch!
>
> - Identifies the message as a protocol version negotiation
> +
On Thu, 10 Apr 2025 at 12:17, Fujii Masao
wrote:
>
>
> On 2025/04/11 0:49, Dave Cramer wrote:
> >
> >
> > On Thu, 10 Apr 2025 at 11:17, Fujii Masao <mailto:masao.fu...@oss.nttdata.com>> wrote:
> >
> >
> >
> > On 2025/04/10 23:40,
;t what it returns. It actually returns the entire newest
protocol that it supports. Attached is a patch to fix the docs.
Dave Cramer
protocol.patch
Description: Binary data
On Thu, 10 Apr 2025 at 11:17, Fujii Masao
wrote:
>
>
> On 2025/04/10 23:40, Dave Cramer wrote:
> >
> > On Thu, 10 Apr 2025 at 09:54, Fujii Masao <mailto:masao.fu...@oss.nttdata.com>> wrote:
> >
> >
> >
> > On 202
On Thu, 10 Apr 2025 at 09:54, Fujii Masao
wrote:
>
>
> On 2025/04/10 18:52, Dave Cramer wrote:
> > Greetings,
> >
> > The current docs say that if a client asks for a protocol that the
> backend doesn't support, it will return the newest minor version.
> h
Dave Cramer
www.postgres.rocks
On Tue, 11 Mar 2025 at 12:23, Frits Hoogland
wrote:
> The usecase that I think might be useful is to have a database client send
> metadata along with a query.
> This partially is possible today by setting application_name, but that is
> a separate
On Tue, 8 Oct 2024 at 20:17, Thomas Munro wrote:
> On Wed, Oct 9, 2024 at 12:58 PM Dave Cramer
> wrote:
> > ..\src\include/port/atomics/arch-x86.h:39: warning:
> "pg_memory_barrier_impl" redefined
>
> It shouldn't be including that. Does the patch here he
On Mon, 3 Feb 2025 at 11:21, Álvaro Herrera wrote:
> On 2025-Feb-03, Robert Treat wrote:
>
> > This does seem to come up often enough that it probably is worth being
> > a bit more explicit about how this works; attached patch attempts
> > that.
>
> LGTM.
>
> > Note, I dropped the bit about GMT;
Greetings,
Previously we have replaced the use of literal characters with pqMsg*. Not
sure how this one escaped detection.
Patch attached.
Dave Cramer
0001-use-pqMsg_Query-instead-of-Q.patch
Description: Binary data
On Sun, 29 Sept 2024 at 06:31, Dave Cramer
wrote:
>
> On Sat, 28 Sept 2024 at 20:03, Thomas Munro
> wrote:
>
>> On Tue, Feb 13, 2024 at 10:01 AM Dave Cramer
>> wrote:
>> > > postgres.exe!dsa_free(dsa_area * area, unsigned __int64 dp) Line 869 C
>
On Sat, 28 Sept 2024 at 20:03, Thomas Munro wrote:
> On Tue, Feb 13, 2024 at 10:01 AM Dave Cramer
> wrote:
> > > postgres.exe!dsa_free(dsa_area * area, unsigned __int64 dp) Line 869 C
> > postgres.exe!resize(dshash_table * hash_table, unsigned __int64
> n
On Tue, 24 Sept 2024 at 14:31, Dave Cramer
wrote:
>
>
> On Tue, 13 Feb 2024 at 16:28, Dave Cramer
> wrote:
>
>>
>>
>>
>> On Tue, 13 Feb 2024 at 12:52, Andres Freund wrote:
>>
>>> Hi,
>>>
>>> On 2024-02-13 12:49:33 -0500, D
On Tue, 13 Feb 2024 at 16:28, Dave Cramer wrote:
>
>
>
> On Tue, 13 Feb 2024 at 12:52, Andres Freund wrote:
>
>> Hi,
>>
>> On 2024-02-13 12:49:33 -0500, Dave Cramer wrote:
>> > > I think I might have been on to something - if my human emulation of a
On Fri, 16 Aug 2024 at 15:54, Heikki Linnakangas wrote:
> On 16/08/2024 22:45, Dave Cramer wrote:
> > On Fri, 16 Aug 2024 at 15:26, Heikki Linnakangas > <mailto:hlinn...@iki.fi>> wrote:
> >
> > On 16/08/2024 21:01, Robert Haas wrote:
> > > On F
On Fri, 16 Aug 2024 at 15:26, Heikki Linnakangas wrote:
> On 16/08/2024 21:01, Robert Haas wrote:
> > On Fri, Aug 16, 2024 at 1:44 PM Jacob Champion
> > wrote:
> >>
> https://github.com/psycopg/psycopg2/blob/658afe4cd90d3e167d7c98d22824a8d6ec895b1c/tests/test_async.py#L89
> >>
> https://github.c
On Sat, 27 Jul 2024 at 19:06, Tatsuo Ishii wrote:
> > Yes, sorry, I should have said one can not create a with hold portal
> using
> > the BIND command
>
> Ok.
>
> It would be possible to add a new parameter to the BIND command to
> create such a portal. But it needs some changes to the existing
Dave Cramer
On Sat, 27 Jul 2024 at 01:55, Tatsuo Ishii wrote:
> > So while the API's are "virtually" identical AFAICT there is no way to
> > create a "WITH HOLD" portal ?
>
> I am not sure if I fully understand your question but I think you ca
On Thu, 25 Jul 2024 at 17:52, Dave Cramer wrote:
>
>
> On Thu, 25 Jul 2024 at 16:19, David G. Johnston <
> david.g.johns...@gmail.com> wrote:
>
>> On Thursday, July 25, 2024, Dave Cramer wrote:
>>
>> May not make a difference but…
>>
>>
&g
On Thu, 25 Jul 2024 at 16:19, David G. Johnston
wrote:
> On Thursday, July 25, 2024, Dave Cramer wrote:
>
> May not make a difference but…
>
>
>> 2024-07-25 15:55:39 FINEST org.postgresql.core.v3.QueryExecutorImpl
>> sendSimpleQuery FE=> SimpleQuery(query=&q
Hi Tom,
On Wed, 8 Nov 2023 at 06:02, Dave Cramer wrote:
>
> Dave Cramer
>
>
> On Tue, 7 Nov 2023 at 10:26, Tom Lane wrote:
>
>> Dave Cramer writes:
>> > If we use a Portal it is possible to open the portal and do a describe
>> and
>> > then
On Wed, 10 Jul 2024 at 11:04, David G. Johnston
wrote:
> On Wednesday, July 10, 2024, Dave Cramer wrote:
>
>> Greetings,
>>
>> There are suggestions that you can use extended query to fetch from a
>> cursor, however I don't see how you can bind valu
Greetings,
There are suggestions that you can use extended query to fetch from a
cursor, however I don't see how you can bind values to the cursor ?
PostgreSQL: Documentation: 16: FETCH
<https://www.postgresql.org/docs/16/sql-fetch.html>
Is this possible?
Dave Cramer
On Tue, 25 Jun 2024 at 09:37, Vladimir Sitnikov
wrote:
> I reviewed the documentation for "direct ALPN connections' ', and it looks
> like it could be improved.
> Here's the link:
> https://www.postgresql.org/docs/17/protocol-flow.html#PROTOCOL-FLOW-SSL
>
> The currently suggested values for "ssl
do
lsn=0/428
This starts in version 16, versions up to and including 15 do not impose
the wait.
Dave Cramer
On Sat, 25 May 2024 at 06:40, Jelte Fennema-Nio wrote:
> On Thu, 23 May 2024 at 20:12, Tom Lane wrote:
> >
> > Jelte Fennema-Nio writes:
> > > On Fri, 17 May 2024 at 21:24, Robert Haas
> wrote:
> > >> Perhaps these are all minority positions, but I can't tell you what
> > >> everyone thinks, o
On Thu, 9 May 2024 at 15:39, Robert Haas wrote:
> On Thu, May 9, 2024 at 3:33 PM Dave Cramer wrote:
> > On Thu, 9 May 2024 at 15:19, Robert Haas wrote:
> >> On Thu, May 9, 2024 at 3:14 PM Andres Freund
> wrote:
> >> > ISTM that you could just as well query t
On Thu, 9 May 2024 at 15:19, Robert Haas wrote:
> On Thu, May 9, 2024 at 3:14 PM Andres Freund wrote:
> > ISTM that you could just as well query the information you'd like after
> > connecting. And that's going to be a lot more flexible than having to
> have
> > precisely the right information i
Dave Cramer
On Thu, 9 May 2024 at 12:22, Robert Haas wrote:
> On Thu, May 9, 2024 at 8:06 AM Dave Cramer wrote:
> > The JDBC driver is currently keeping a per connection cache of types in
> the driver. We are seeing cases where the number of columns is quite high.
> In o
com/pgjdbc/pgjdbc/issues/3241> 2.6 Million columns.
If we knew that we were connecting to the same database we could use a
single cache across connections.
I think we would require a server/database identifier in the startup
message.
Dave Cramer
Greetings,
I've been asked by the debezium developers if it is possible to include
xid8 in the logical replication protocol. Are there any previous threads on
this topic?
Any reason why we wouldn't include the epoch ?
Dave Cramer
On Mon, 15 Apr 2024 at 15:38, Jelte Fennema-Nio wrote:
> On Mon, 15 Apr 2024 at 19:43, Robert Haas wrote:
> >
> > On Sat, Apr 6, 2024 at 6:14 PM Jelte Fennema-Nio wrote:
> > > I think for clients/drivers, the work would generally be pretty
> > > minimal. For almost all proposed changes, clients
>
>
> Plus, you've got all of the consequences for non-core drivers, which
> have to both add support for the new wire protocol - if they don't
> want to seem outdated and eventually obsolete - and also test that
> they're still compatible with all supported server versions.
> Connection poolers ha
On Fri, 5 Apr 2024 at 12:09, Jelte Fennema-Nio wrote:
> On Fri, 5 Apr 2024 at 16:02, Robert Haas wrote:
> > Often?
> >
> > I kind of hope that the protocol starts to evolve a bit more than it
> > has, but I don't want a continuous stream of changes. That will be
> > very hard to test and verify
On Thu, 4 Apr 2024 at 12:45, Jelte Fennema-Nio wrote:
> On Thu, 4 Apr 2024 at 14:50, Peter Eisentraut
> wrote:
> > It appears there are several different perspectives about this. My
> > intuition was that a protocol version change indicates something that we
> > eventually want all client libra
Dave Cramer
On Wed, 27 Mar 2024 at 17:57, David Rowley wrote:
> On Thu, 28 Mar 2024 at 10:33, Dave Cramer wrote:
> > There is a report on the pgjdbc github JDBC Driver shows erratic
> behavior when filtering on CURRENT_DATE · pgjdbc/pgjdbc · Discussion #3184 (
> github.com)
&
00..18.08
rows=238 width=0) (actual time=0.035..0.035 rows=356 loops=1)
Index Cond: (p.mutation >= ((CURRENT_DATE -
`1971-12-31`::date) - 29))
Planning Time: 0.379 ms
Execution Time: 5.443 ms
<https://github.com/pgjdbc/pgjdbc/discussions/3184>
Dave Cramer
Andres,
On Thu, 21 Mar 2024 at 12:51, Andres Freund wrote:
> Hi,
>
> On 2024-03-21 07:11:23 -0400, Dave Cramer wrote:
> > It seems that attempting to cross-compile on an ARM machine might be
> asking
> > too much as the use cases are pretty limited.
>
> It for sur
On Thu, 21 Mar 2024 at 03:56, Peter Eisentraut wrote:
> On 20.03.24 22:49, Dave Cramer wrote:
> >
> >
> >
> > On Wed, 20 Mar 2024 at 17:11, Andres Freund > <mailto:and...@anarazel.de>> wrote:
> >
> > Hi,
> >
> > On 2024-0
instructions ?
Dave Cramer
On Wed, 20 Mar 2024 at 10:59, Erik Wienhold wrote:
> On 2024-03-18 23:24 +0100, David Rowley wrote:
> > My vote would go to adding a deprecation notice to that section of the
> > docs. There's some talk [1] about how we discourage the usage of the
> > money type and that goes on to discuss the p
>
>
>>
>> FWIW, I'd like to think that we could improve the situation, requiring
>> a mix of calling pgstat_report_query_id() while feeding on some query
>> IDs retrieved from CachedPlanSource->query_list. I have not in
>> details looked at how much could be achieved, TBH.
>>
>
This just cropped u
Hi Tatsuo,
Actually no need, I figured it out.
I don't have a solution yet though.
Dave Cramer
www.postgres.rocks
On Thu, 15 Feb 2024 at 19:43, Tatsuo Ishii wrote:
> > Can you ask the OP what they are doing in the startup. I'm trying to
> > replicate their situation.
&
On Wed, 14 Feb 2024 at 17:55, Tatsuo Ishii wrote:
> >>> From [1] I think the JDBC driver sends something like below if
> >>> autosave=always option is specified.
> >>>
> >>> "BEGIN READ ONLY" Parse/Bind/Eexecute (in the extended query protocol)
> >>> "SAVEPOINT PGJDBC_AUTOSAVE" (in the simple que
On Tue, 13 Feb 2024 at 12:52, Andres Freund wrote:
> Hi,
>
> On 2024-02-13 12:49:33 -0500, Dave Cramer wrote:
> > > I think I might have been on to something - if my human emulation of a
> > > preprocessor isn't wrong, we'd end up with
> > >
&g
Dave Cramer
www.postgres.rocks
On Mon, 12 Feb 2024 at 16:19, Andres Freund wrote:
> Hi,
>
> On 2024-02-12 12:50:12 -0800, Andres Freund wrote:
> > On 2024-02-12 13:28:40 -0500, Andrew Dunstan wrote:
> > I wonder if this indicates that we are either missing memory barriers
HI Tatsuo,
On Mon, 29 Jan 2024 at 20:15, Tatsuo Ishii wrote:
> Hello Dave,
>
> > Tatsuo Ishii writes:
> >> Below is outputs from "pgproto" command coming with Pgpool-II.
> >> (Lines starting "FE" represents a message from frontend to backend.
> >> Lines starting "BE" represents a message from
On Mon, 12 Feb 2024 at 15:50, Andres Freund wrote:
> Hi,
>
> On 2024-02-12 13:28:40 -0500, Andrew Dunstan wrote:
> > On 2024-02-12 Mo 11:44, Dave Cramer wrote:
> > > OK, so I have managed to get a debugger attached to postgres.exe when
> it
> > > faults a
Dave Cramer
www.postgres.rocks
On Mon, 12 Feb 2024 at 09:19, Andrew Dunstan wrote:
>
> On 2024-02-12 Mo 08:51, Dave Cramer wrote:
>
>
>
> On Sat, 10 Feb 2024 at 13:28, Andrew Dunstan wrote:
>
>>
>> On 2024-02-10 Sa 12:20, Dave Cramer wrote:
>>
>&g
On Sat, 10 Feb 2024 at 13:28, Andrew Dunstan wrote:
>
> On 2024-02-10 Sa 12:20, Dave Cramer wrote:
>
>
>
> On Sat, 10 Feb 2024 at 11:19, Andrew Dunstan wrote:
>
>>
>> On 2024-02-09 Fr 14:23, Dave Cramer wrote:
>>
>>
>> Dave Cramer
>> www.
On Sat, 10 Feb 2024 at 11:19, Andrew Dunstan wrote:
>
> On 2024-02-09 Fr 14:23, Dave Cramer wrote:
>
>
> Dave Cramer
> www.postgres.rocks
>
>
> On Fri, 9 Feb 2024 at 07:18, Dave Cramer
> wrote:
>
>>
>>
>>
>>
>> On Fri, 9 Feb 2024 a
On Fri, 9 Feb 2024 at 14:36, Andres Freund wrote:
> Hi,
>
> On 2024-02-09 14:23:46 -0500, Dave Cramer wrote:
> > > interestingly meson test does not produce any error
> > > The buildfarm produces the following error for me:
> > >
> > > -SELECT r
Dave Cramer
www.postgres.rocks
On Fri, 9 Feb 2024 at 07:18, Dave Cramer wrote:
>
>
>
>
> On Fri, 9 Feb 2024 at 00:26, Michael Paquier wrote:
>
>> On Tue, Feb 06, 2024 at 07:01:49AM -0500, Dave Cramer wrote:
>> > Thanks, this patch works and
>> > test
On Fri, 9 Feb 2024 at 00:26, Michael Paquier wrote:
> On Tue, Feb 06, 2024 at 07:01:49AM -0500, Dave Cramer wrote:
> > Thanks, this patch works and
> > testing with meson passes.
>
> Only with the version posted at [1]? Interesting, that's the same
> contents as
On Wed, 31 Jan 2024 at 10:21, Andrew Dunstan wrote:
>
> On 2024-01-30 Tu 17:54, Dave Cramer wrote:
>
>
>
>
> On Tue, Jan 30, 2024 at 4:56 PM Andrew Dunstan
> wrote:
>
>>
>> On 2024-01-30 Tu 09:50, Dave Cramer wrote:
>>
>>
>>
>> On
On Mon, 29 Jan 2024 at 20:15, Tatsuo Ishii wrote:
> Hello Dave,
>
> > Tatsuo Ishii writes:
> >> Below is outputs from "pgproto" command coming with Pgpool-II.
> >> (Lines starting "FE" represents a message from frontend to backend.
> >> Lines starting "BE" represents a message from backend to fr
On Tue, Jan 30, 2024 at 4:56 PM Andrew Dunstan wrote:
>
> On 2024-01-30 Tu 09:50, Dave Cramer wrote:
>
>
>
> On Tue, 30 Jan 2024 at 08:38, Andrew Dunstan wrote:
>
>>
>> On 2024-01-29 Mo 11:20, Dave Cramer wrote:
>>
>>
>> Dave Cramer
>>
On Tue, 30 Jan 2024 at 08:38, Andrew Dunstan wrote:
>
> On 2024-01-29 Mo 11:20, Dave Cramer wrote:
>
>
> Dave Cramer
> www.postgres.rocks
>
>
> On Mon, 29 Jan 2024 at 11:16, Andrew Dunstan wrote:
>
>>
>> On 2024-01-26 Fr 09:18, Dave Cramer wrote:
>&g
Dave Cramer
www.postgres.rocks
On Mon, 29 Jan 2024 at 11:16, Andrew Dunstan wrote:
>
> On 2024-01-26 Fr 09:18, Dave Cramer wrote:
>
>
>
> On Fri, 26 Jan 2024 at 07:36, Andrew Dunstan wrote:
>
>>
>> On 2024-01-25 Th 20:32, Michael Paquier wrote:
>> >
On Fri, 26 Jan 2024 at 07:36, Andrew Dunstan wrote:
>
> On 2024-01-25 Th 20:32, Michael Paquier wrote:
> > On Thu, Jan 25, 2024 at 04:52:30PM -0500, Dave Cramer wrote:
> >> On Thu, 25 Jan 2024 at 16:32, Andrew Dunstan
> wrote:
> >>> On 2024-01-25 Th 16:17, Da
On Thu, 25 Jan 2024 at 16:32, Andrew Dunstan wrote:
>
> On 2024-01-25 Th 16:17, Dave Cramer wrote:
>
>
>
> On Thu, 25 Jan 2024 at 16:04, Anthony Roberts
> wrote:
>
>> Hi David,
>>
>> Unix "file" or "dumpbin /headers" in vcvarsall are
On Thu, 25 Jan 2024 at 16:04, Anthony Roberts
wrote:
> Hi David,
>
> Unix "file" or "dumpbin /headers" in vcvarsall are your best bets.
>
> Thanks,
> Anthony
>
So there is another way, select the file in Windows Explorer and right
click, in the compatibility tab if the "Windows on ARM" is greye
On Thu, 25 Jan 2024 at 12:30, Andrew Dunstan wrote:
>
> On 2024-01-24 We 19:02, Michael Paquier wrote:
>
> On Wed, Jan 24, 2024 at 06:45:21AM -0500, Dave Cramer wrote:
>
> I managed to get it to build the vcvarsall arch needs to be x64. I need to
> add some options, but the
On Thu, 25 Jan 2024 at 14:31, Andrew Dunstan wrote:
>
> On 2024-01-25 Th 08:45, Dave Cramer wrote:
>
>
>
>
>
> I tried running my buildfarm using my git repo and my branch, but get the
> following error
> Status Line: 492 bad branch parameter
> Content:
> bad
On Thu, 25 Jan 2024 at 12:30, Andrew Dunstan wrote:
>
> On 2024-01-24 We 19:02, Michael Paquier wrote:
>
> On Wed, Jan 24, 2024 at 06:45:21AM -0500, Dave Cramer wrote:
>
> I managed to get it to build the vcvarsall arch needs to be x64. I need to
> add some options, but the
On Thu, 25 Jan 2024 at 08:31, Dave Cramer wrote:
>
>
> On Wed, 24 Jan 2024 at 19:03, Michael Paquier wrote:
>
>> On Wed, Jan 24, 2024 at 06:45:21AM -0500, Dave Cramer wrote:
>> > I managed to get it to build the vcvarsall arch needs to be x64. I need
>> to
>
On Wed, 24 Jan 2024 at 19:03, Michael Paquier wrote:
> On Wed, Jan 24, 2024 at 06:45:21AM -0500, Dave Cramer wrote:
> > I managed to get it to build the vcvarsall arch needs to be x64. I need
> to
> > add some options, but the patch above needs to be applied to build it.
>
On Tue, 23 Jan 2024 at 18:32, Michael Paquier wrote:
> On Tue, Jan 23, 2024 at 04:13:05PM -0500, Dave Cramer wrote:
> > On Tue, 23 Jan 2024 at 08:46, Dave Cramer
> wrote:
> >> The attached patch works with v17. I will work on getting a buildfarm
> >> animal up sho
On Tue, 23 Jan 2024 at 08:46, Dave Cramer wrote:
>
>
> On Tue, 19 Sept 2023 at 23:48, Michael Paquier
> wrote:
>
>> On Tue, Sep 19, 2023 at 01:35:17PM +0100, Anthony Roberts wrote:
>> > Was there an explicit request for something there? I was under the
>>
On Tue, 19 Sept 2023 at 23:48, Michael Paquier wrote:
> On Tue, Sep 19, 2023 at 01:35:17PM +0100, Anthony Roberts wrote:
> > Was there an explicit request for something there? I was under the
> > impression that this was all just suggestion/theory at the moment.
>
> Yes. The addition of a buildf
use (1) you have
> to be using libpq in order to make use of this
JDBC has it as of yesterday. I would imagine other clients will implement
it.
Dave Cramer
>
>
On Wed, 27 Dec 2023 at 16:10, Tom Lane wrote:
> Joe Conway writes:
> > On 12/27/23 15:39, Peter Eisentraut wrote:
> >> On 23.12.23 16:13, Joe Conway wrote:
> >>> The attached patch set moves the guts of \password from psql into the
> >>> libpq client side -- PQchangePassword() (patch 0001).
>
>
Dave Cramer
www.postgres.rocks
On Sat, 23 Dec 2023 at 11:00, Tom Lane wrote:
> Joe Conway writes:
> > The attached patch set moves the guts of \password from psql into the
> > libpq client side -- PQchangePassword() (patch 0001).
>
> Haven't really read the patch, ju
On Thu, 7 Dec 2023 at 08:47, David G. Johnston
wrote:
> On Thursday, December 7, 2023, Daniel Verite
> wrote:
>
>> Joe Conway wrote:
>>
>> > The attached should fix the CopyOut response to say one column. I.e. it
>> > ought to look something like:
>>
>> Spending more time with the doc I
On Thu, 7 Dec 2023 at 14:34, Andres Freund wrote:
> Hi,
>
> On 2023-12-07 14:16:52 -0500, Dave Cramer wrote:
> > On Thu, 7 Dec 2023 at 13:53, Andres Freund wrote:
> >
> > > Hi,
> > >
> > > On 2023-12-07 12:54:27 -0500, Dave Cramer wrote:
&
On Thu, 7 Dec 2023 at 13:53, Andres Freund wrote:
> Hi,
>
> On 2023-12-07 12:54:27 -0500, Dave Cramer wrote:
> > state-exec: run failed: cannot create new executor meta: cannot get
> > matching bin by path: no matching binary by path
> >
> "C:\\Users\\Adminis
se contact support for assistance.
anyone seen this or have a fix ?
Dave Cramer
On Mon, 13 Nov 2023 at 20:56, Andres Freund wrote:
> Hi,
>
> On 2023-11-12 11:41:15 -0500, Dave Cramer wrote:
> > On Sun, 12 Nov 2023 at 07:57, Dave Cramer wrote:
> > > I am getting the following error
> > > building on HEAD
> > >
> > > Li
On Sun, 12 Nov 2023 at 07:57, Dave Cramer wrote:
> Greetings,
>
> I am getting the following error
> building on HEAD
>
> Library crypto found: YES
> Checking for function "CRYPTO_new_ex_data" with dependencies -lssl,
> -lcrypto: NO
>
So this is the error y
Greetings,
I am getting the following error
building on HEAD
Library crypto found: YES
Checking for function "CRYPTO_new_ex_data" with dependencies -lssl,
-lcrypto: NO
I have openssl 1.1.1 installed
Dave Cramer
src/main/java/MushroomAPIs line 47 Java Problem
>>> Point cannot be resolved to a type ProcAddMushrooms.java
>>> /KatseAPIs/src/main/java/MushroomAPIs line 83 Java Problem
>>> Point cannot be resolved to a type Utils.java
>>> /KatseAPIs/src/main/java/MushroomAPIs line
On Mon, 6 Nov 2023 at 09:59, Jose Osinde wrote:
>
> Dear all,
>
> I'm running a query from Java on a postgres database:
>
> Java version: 17
> JDBC version: 42.4.2
> Postgres version: 13.1
>
> In parallel I'm testing the same queries from pgAdmin 4 version 6.13
>
> The tables I'm using contains
Dave Cramer
On Tue, 7 Nov 2023 at 10:26, Tom Lane wrote:
> Dave Cramer writes:
> > If we use a Portal it is possible to open the portal and do a describe
> and
> > then Fetch N records.
>
> > Using a Cursor we open the cursor. Is there a corresponding describe
ot; and we get the fields and the
rows. This seems overly verbose.
Dave Cramer
On Sat, 21 Oct 2023 at 05:50, Justin Clift wrote:
> On 2023-10-19 04:45, Abelardo Erazo Lopez wrote:
> > Hi, Everyone
> >
> > I have an Oracle database Oracle 19c and I need to access a PostgreSQL
> > database 15.4 that resides on a different server. I see that one
> > alternative is to use ODBC
es\bin\zic.exe"
Apparently 32 bit dlls are required. If there is an easier way to get
libpq.dll and the include files for building I'm all ears.
Dave Cramer
On Tue, 10 Oct 2023 at 10:25, Robert Haas wrote:
> On Mon, Oct 9, 2023 at 4:25 PM Jeff Davis wrote:
> > Another thing to consider is that using a GUC for binary formats is a
> > protocol change in a way that client_encoding is not. The existing
> > documentation for the protocol already specifie
On Mon, 9 Oct 2023 at 17:11, Jelte Fennema wrote:
> On Mon, 9 Oct 2023 at 21:08, Dave Cramer wrote:
> > So if we use . would it be possible to have something like
> which represents a set of well known types?
> > My goal here is to reduce the overhead of naming all the
On Mon, 9 Oct 2023 at 15:00, Robert Haas wrote:
> On Mon, Oct 9, 2023 at 11:09 AM Jelte Fennema wrote:
> > Since the protocol already returns OIDs in the ParameterDescription
> > and RowDescription messages I don't see why using OIDs for this GUC
> > would cause any additional problems.
>
> ...b
Greetings,
Before 16 if I created an array type in schema1 it would be named
schema1._array_type
if I created the same type in schema 2 it would have been named
schema2.__array_type
Can someone point me to where the code was changed ?
Thanks,
Dave Cramer
On Wed, 4 Oct 2023 at 10:17, Peter Eisentraut wrote:
> On 31.07.23 18:27, Dave Cramer wrote:
> > On Mon, 10 Jul 2023 at 03:56, Daniel Gustafsson > <mailto:dan...@yesql.se>> wrote:
> >
> > > On 25 Apr 2023, at 16:47, Dave Cramer >
Again, can you please post the solution so others can learn as well ?
Dave Cramer
www.postgres.rocks
On Sat, 30 Sept 2023 at 06:49, Raivo Rebane wrote:
> Thanks for very much for help.
> It seems that I can do the test project for new job.
> In future I use help of chat.gpt
&g
On Fri, 29 Sept 2023 at 14:22, Raivo Rebane wrote:
> Thanks,
>
> there was really JDK 17 in use.
> I changed it to Java 1.8
> PS C:\Program Files\Apache Software Foundation\Tomcat 9.0\bin> java
> -version
> java version "1.8.0_381"
> Java(TM) SE Runtime Environment (build 1.8.0_381-b09)
> Java Ho
Dave Cramer
www.postgres.rocks
On Fri, 29 Sept 2023 at 06:19, Raivo Rebane wrote:
> Hi,
>
> The code is :
> package MushroomAPIs;
>
> import java.io.IOException;
> import javax.servlet.ServletException;
> import javax.servlet.annotation.WebServlet;
> import jav
The latest version of postgis-jdbc is Maven Repository: net.postgis »
postgis-jdbc » 2021.1.0 (mvnrepository.com)
<https://mvnrepository.com/artifact/net.postgis/postgis-jdbc/2021.1.0>
Dave Cramer
www.postgres.rocks
On Thu, 28 Sept 2023 at 14:51, Raivo Rebane wrote:
> Hi,
>
> T
Please put this project on github so we can see it.
Thanks
Dave Cramer
www.postgres.rocks
On Thu, 28 Sept 2023 at 11:53, Raivo Rebane wrote:
> Or may be I am using wrong version of Java - java version "17.0.8"
> 2023-07-18 LTS
>
> Raivo
>
> On Thu, Sep 28, 2023 at
Dave Cramer
www.postgres.rocks
On Thu, 28 Sept 2023 at 02:18, Raivo Rebane wrote:
> Hi,
>
> I made a new Java application Eclipse Dynamic WEB application and want to
> use Postgres - PostgreSQL 10.14 on x86_64-pc-linux-gnu, compiled by gcc
> (Ubuntu 9.3.0-10ubuntu2) 9.3.0, 64-
lob/5709a20fbef453749d2394e11502527e4a3ab5bb/pgjdbc/src/main/java/org/postgresql/util/PGobject.java#L19>
I suggest at this point you provide a test project on github that you can
share.
There is something wrong with the classpath
Dave Cramer
www.postgres.rocks
On Wed, 27 Sept 2023 at 01:52,
You should probably be using the latest version of postgis-jdbc
Maven Repository: net.postgis » postgis-jdbc » 2021.1.0 (mvnrepository.com)
<https://mvnrepository.com/artifact/net.postgis/postgis-jdbc/2021.1.0>
Dave Cramer
www.postgres.rocks
On Mon, 25 Sept 2023 at 08:43, Raivo Rebane
It must be a dependency to something. postgis ?
Dave Cramer
www.postgres.rocks
On Mon, 25 Sept 2023 at 09:25, Raivo Rebane wrote:
> Hi,
> postgresql-8.3-603.jdbc4.jar is added by maven maven install. How to
> avoid it ?
>
1 - 100 of 1041 matches
Mail list logo
