I could if someone wants to commit to reviewing it.
I've updated it a number of times but it seems nobody wants to review it.
Dave Cramer
www.postgres.rocks
On Thu, 7 Jan 2021 at 09:27, Masahiko Sawada wrote:
> Hi Dave,
>
> On Tue, Dec 1, 2020 at 6:49 PM Georgios Koko
ack to
> expecting the community to maintain things for the benefit of
> third-party forks.
>
if this proposal brought us the ability stream results that would be a huge
plus!
Dave Cramer
www.postgres.rocks
>
>
Yes, when did it become a good idea to put a connection pooler in the
backend???
Dave Cramer
www.postgres.rocks
For my patch https://commitfest.postgresql.org/30/2522/
When I run
make -j4 all contrib && make check-world
locally
I see 2 errors.
When cf-bot runs this it sees
35 out of 93 failed.
How can I see the same errors?
Dave Cramer
On Sun., Nov. 1, 2020, 1:41 p.m. Thomas Munro,
wrote:
> On Mon, Nov 2, 2020 at 1:58 AM Dave Cramer wrote:
> > For my patch https://commitfest.postgresql.org/30/2522/
> >
> > When I run
> >
> > make -j4 all contrib && make check-world
> > locally
&
On Sun, 1 Nov 2020 at 13:46, Dave Cramer wrote:
>
>
> On Sun., Nov. 1, 2020, 1:41 p.m. Thomas Munro,
> wrote:
>
>> On Mon, Nov 2, 2020 at 1:58 AM Dave Cramer wrote:
>> > For my patch https://commitfest.postgresql.org/30/2522/
>> >
>> > When I
On Sun, 1 Nov 2020 at 18:15, Tom Lane wrote:
> Dave Cramer writes:
> > OK, checked and I definitely have the changes. I don't think the
> isolation
> > test is running. Is there some configuration that enables it?
>
> No, top-level "check-world" shou
On Mon, 2 Nov 2020 at 14:47, Andres Freund wrote:
> Hi,
>
> On 2020-11-02 11:18:03 -0500, Dave Cramer wrote:
> > On Sun, 1 Nov 2020 at 18:15, Tom Lane wrote:
> >
> > > Dave Cramer writes:
> > > > OK, checked and I definitely have the changes. I don&#
tch needs a rebase as it visibly fails to apply,
> per the CF bot.
> --
> Michael
>
Where are you with this? Are you able to work on it ?
Dave Cramer
for looking at this.
What else does it need to get it in shape to apply?
Dave Cramer
www.postgres.rocks
On Tue, 3 Nov 2020 at 08:42, Alvaro Herrera wrote:
> Hi Dave,
>
> On 2020-Nov-03, Dave Cramer wrote:
>
> > On Mon, 2 Nov 2020 at 10:57, Alvaro Herrera
> wrote:
> >
> > > On 2020-Nov-02, Alvaro Herrera wrote:
> > >
> > > > In v23 I&
On Wed, 4 Nov 2020 at 10:50, Shay Rojansky wrote:
> Hi all.
>
> Back in 2016 I started a thread about making cancellations safer[1], I'd
> like to try to pick this up again. Here a summary of the previous
> conversation:
>
> The main ask here is to allow clients to specify which command to cancel
On Wed, 30 Sep 2020 at 18:14, Andrew Dunstan
wrote:
>
> On 8/4/20 12:19 PM, Dave Cramer wrote:
> > Attached is the rebased patch for consideration.
> >
> >
>
>
> It's a bit sad this has been hanging around so long without attention.
>
>
> The prev
On Mon, 9 Nov 2020 at 16:26, Dave Cramer wrote:
>
>
> On Wed, 30 Sep 2020 at 18:14, Andrew Dunstan <
> andrew.duns...@2ndquadrant.com> wrote:
>
>>
>> On 8/4/20 12:19 PM, Dave Cramer wrote:
>> > Attached is the rebased patch for consideration.
>&
async drivers that would also benefit
from not having to keep state in the session.
Regards,
Dave Cramer
www.postgres.rocks
On Tue, 10 Nov 2020 at 11:53, Dave Cramer wrote:
>
>
> On Mon, 9 Nov 2020 at 16:26, Dave Cramer
> wrote:
>
>>
>>
>> On Wed, 30 Sep 2020 at
Apologies, I should have checked again to make sure the patch applied.
This one does and passes tests.
Dave Cramer
www.postgres.rocks
On Mon, 25 Jan 2021 at 09:09, Dave Cramer wrote:
> Rebased against head
>
> Here's my summary of the long thread above.
>
> This change is
On Tue, 26 Jan 2021 at 06:59, Masahiko Sawada wrote:
> On Tue, Jan 26, 2021 at 7:06 PM Laurenz Albe
> wrote:
> >
> > On Mon, 2021-01-25 at 11:29 -0500, Dave Cramer wrote:
> > > Rebased against head
> > >
> > > Here's my summary of the long t
On Tue, 26 Jan 2021 at 05:05, Laurenz Albe wrote:
> On Mon, 2021-01-25 at 11:29 -0500, Dave Cramer wrote:
> > Rebased against head
> >
> > Here's my summary of the long thread above.
> >
> > This change is in keeping with the SQL spec.
> >
> > T
On Tue, 26 Jan 2021 at 12:20, Laurenz Albe wrote:
> On Tue, 2021-01-26 at 11:09 -0500, Dave Cramer wrote:
> > On Tue, 26 Jan 2021 at 05:05, Laurenz Albe
> wrote:
> >
> > > I wonder about the introduction of the new USER_ERROR level:
> > >
> > > #def
On Tue, 26 Jan 2021 at 12:46, Laurenz Albe wrote:
> On Tue, 2021-01-26 at 12:25 -0500, Dave Cramer wrote:
> > > After thinking some more about it, I think that COMMIT AND CHAIN would
> have
> > > to change behavior: if COMMIT throws an error (because the transaction
>
On Thu, 25 Mar 2021 at 12:04, David Steele wrote:
> On 1/26/21 1:02 PM, Dave Cramer wrote:
> > On Tue, 26 Jan 2021 at 12:46, Laurenz Albe > <mailto:laurenz.a...@cybertec.at>> wrote:
> >
> > I see your point from the view of the JDBC driver.
> >
> &g
at might be attributed to this?
Dave Cramer
On Sat, 10 Apr 2021 at 20:24, Tom Lane wrote:
> Dave Cramer writes:
> > One of our tests purposely throws an error which returns
> > "ERROR: R interpreter parse error" on linux
> > and
> > "WARNING: R interpreter parse error" on windows.
>
On Sat, 10 Apr 2021 at 20:34, Tom Lane wrote:
> Dave Cramer writes:
> > On Sat, 10 Apr 2021 at 20:24, Tom Lane wrote:
> >> That's quite bizarre. What is the actual error level according to
> >> the source code, and where is the error being thrown exactly?
>
On Sat, 10 Apr 2021 at 20:56, Tomas Vondra
wrote:
> On 4/11/21 2:38 AM, Dave Cramer wrote:
> >
> >
> >
> >
> > On Sat, 10 Apr 2021 at 20:34, Tom Lane > <mailto:t...@sss.pgh.pa.us>> wrote:
> >
> > Dave Cramer mailto:davecra...@gmail.co
ybe like the attached?
>
+1 from me.
I especially like the changes to the comments as it's more apparent what
they should be used for.
Dave Cramer
>
> regards, tom lane
>
>
facility
that is not easily replicated.
Thoughts ?
Dave Cramer
Attached is the rebased patch for consideration.
Dave Cramer
www.postgres.rocks
>
>
0001-Throw-error-and-rollback-on-a-failed-transaction-ins.patch
Description: Binary data
d the data one by one.
>
> The above user case looks reasonable to me IMO, I would say it is kind of
> "tech debt"
> in postgres. To support this completely, looks we have to decouple the
> snapshot/locking
> management with transaction? If so, it looks like a huge change. I wonder
> if anybody
> tried to resolve this issue and where do we get to that point?
>
> --
> Best Regards
> Andy Fan
>
I think if you set the fetch size the driver will use a named cursor and
this should work
Dave Cramer
www.postgres.rocks
On Wed, 12 Aug 2020 at 08:14, Andy Fan wrote:
>
>
> On Wed, Aug 12, 2020 at 8:11 PM Andy Fan wrote:
>
>>
>>
>> On Wed, Aug 12, 2020 at 5:54 PM Dave Cramer
>> wrote:
>>
>>>
>>>
>>>
>>> On Tue, 11 Aug 2020 at 22:33,
On Fri, 15 Oct 2021 at 09:29, Gilles Darold wrote:
> Le 15/10/2021 à 14:24, Aleksander Alekseev a écrit :
> > Hi Gilles,
> >
> >> If we really want SELECT * to be reserved to DBA then why not removing
> the
> >> star from PG unless you have the admin privilege?
> > Respectfully, I perceive this a
reading and querying json on the command line is simple and user friendly,
> and using json for logging capture and aggregation is widely supporting and
> embraced.
>
Exactly what are you logging here ??? Why would I need to see a
multi-dimensional array in the log ?
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On Thu, Apr 19, 2018, 9:24 AM Konstantin Knizhnik, <
k.knizh...@postgrespro.ru> wrote:
>
>
> On 19.04.2018 07:46, Tsunakawa, Takayuki wrote:
> > From: Konstantin Knizhnik [mailto:k.knizh...@postgrespro.ru]
> > Oracle, for example, you can create dedicated and non-dedicated backends.
> >> I wonder
7;t happen ? I realize
oids are not guaranteed to be unique, but this seems to be quite a
coincidence.
Dave Cramer
On Tue, 8 Oct 2019 at 11:57, Craig Ringer wrote:
> On Thu, 11 Jul 2019 at 04:34, Tom Lane wrote:
>
>> Robert Haas writes:
>> > On Wed, Jul 10, 2019 at 9:59 AM Dave Cramer wrote:
>> >> I'm still a bit conflicted about what to do with search_path as
On Wed, 9 Oct 2019 at 08:15, Dave Cramer wrote:
>
>
> On Tue, 8 Oct 2019 at 11:57, Craig Ringer wrote:
>
>> On Thu, 11 Jul 2019 at 04:34, Tom Lane wrote:
>>
>>> Robert Haas writes:
>>> > On Wed, Jul 10, 2019 at 9:59 AM Dave Cramer wrote:
>&
On Thu, 10 Oct 2019 at 12:05, Andres Freund wrote:
> Hi,
>
> On 2019-10-09 16:29:07 -0400, Dave Cramer wrote:
> > I've added functionality into libpq to be able to set this STARTUP
> > parameter as well as changed it to _pq_.report.
> > Still need to document th
On Fri, 11 Oct 2019 at 16:41, Chapman Flack wrote:
> On 10/11/19 4:30 PM, Robert Haas wrote:
>
> > But, if it does need to be changed, it seems like a terrible idea to
> > allow it to be done via SQL. Otherwise, the user can break the driver
> > by using SQL to set the list to something that the
On Sat, 12 Oct 2019 at 05:05, Tom Lane wrote:
> Andres Freund writes:
> > On 2019-10-11 16:30:17 -0400, Robert Haas wrote:
> >> But, if it does need to be changed, it seems like a terrible idea to
> >> allow it to be done via SQL. Otherwise, the user can break the driver
> >> by using SQL to set
r to the secondary instance, but instead allow it to process user
queries throughout the maintenance."
see this for the thread.
https://www.postgresql.org/message-id/VI1PR05MB5295AE43EF9525EACC9E57ECBC750%40VI1PR05MB5295.eurprd05.prod.outlook.com
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
Responses inline. I just picked up this thread so please bear with me.
On Fri, 26 Jul 2019 at 16:24, Tomas Vondra
wrote:
> Hi Konstantin,
>
> I've started reviewing this patch and experimenting with it, so let me
> share some initial thoughts.
>
>
> 1) not handling session state (yet)
>
> I unde
On Mon, 26 Aug 2019 at 14:14, Tom Lane wrote:
> Laurenz Albe writes:
> > Dave Cramer wrote:
> > test=> BEGIN;
> > BEGIN
> > test=> CALL testproc();
> > ERROR: invalid transaction termination
> > CONTEXT: PL/pgSQL function testproc() line 1 at COMMI
On Sun, 27 Oct 2019 at 11:00, Dmitry Dolgov <9erthali...@gmail.com> wrote:
> > On Mon, Jun 17, 2019 at 10:29:26AM -0400, Dave Cramer wrote:
> > > Which is what I have done. Thanks
> > >
> > > I've attached both patches for comments.
> > >
On Sun, 3 Nov 2019 at 21:47, Thomas Munro wrote:
> On Thu, Oct 31, 2019 at 3:03 AM Dave Cramer wrote:
> > Ok, I've rebased and reverted logicalrep_read_insert
>
> Hi Dave,
>
> From the code style police (actually just from cfbot, which is set up
> to complain about
On Sun, 3 Nov 2019 at 19:40, Thomas Munro wrote:
> On Wed, Oct 16, 2019 at 6:49 PM Dave Cramer wrote:
> > Here's an updated patch that addresses some of Andres' concerns
> specifically does not use strtok.
>
> Hi Dave,
>
> I think you need to s/strncasecmp/pg_
On Fri, 8 Nov 2019 at 11:20, Dmitry Dolgov <9erthali...@gmail.com> wrote:
> > On Tue, Nov 05, 2019 at 07:16:10AM -0500, Dave Cramer wrote:
> >
> > See attached
>
> --- a/src/backend/replication/logical/worker.c
> +++ b/src/backend/replication/logical/
On Mon, 11 Nov 2019 at 12:04, Alvaro Herrera
wrote:
> On 2019-Nov-11, Dave Cramer wrote:
>
> > Previously someone mentioned that we need to confirm whether the two
> > servers are compatible for binary or not.
> >
> > Checking to make sure the two servers have th
On Mon, 11 Nov 2019 at 12:07, Dave Cramer wrote:
>
>
> On Mon, 11 Nov 2019 at 12:04, Alvaro Herrera
> wrote:
>
>> On 2019-Nov-11, Dave Cramer wrote:
>>
>> > Previously someone mentioned that we need to confirm whether the two
>> > servers are compat
On Mon, 11 Nov 2019 at 15:17, Alvaro Herrera
wrote:
> On 2019-Nov-11, Dave Cramer wrote:
>
> > Following 2 patches address Dmitry's concern and check for compatibility.
>
> Please resend the whole patchset, so that the patch tester can verify
> the series. (
Rebased against head
Dave Cramer
On Sat, 30 Nov 2019 at 20:48, Michael Paquier wrote:
> Hi,
>
> On Mon, Nov 11, 2019 at 03:24:59PM -0500, Dave Cramer wrote:
> > Attached,
>
> The latest patch set does not apply correctly. Could you send a
> rebase please? I am mov
While following an old link to
https://www.postgresql.org/docs/10/auth-methods.html
I see a list of links to authentication methods. However:
When I hit the current version
https://www.postgresql.org/docs/current/auth-methods.html
There are absolutely no links...
Dave Cramer
On Tue, 17 Dec 2019 at 06:53, Magnus Hagander wrote:
> On Tue, Dec 17, 2019 at 12:43 PM Dave Cramer wrote:
>
>> While following an old link to
>> https://www.postgresql.org/docs/10/auth-methods.html
>>
>> I see a list of links to authentication methods. However
> Then, URLs pointing to that page (such as Dave evidently has bookmarked)
> would break entirely, which doesn't seem like an improvement.
>
it was linked to in a bug report.
Dave Cramer
x27;publication_names','dbz_publication');
ERROR: publication "dbz_publication" does not exist
CONTEXT: slot "debezium", output plugin "pgoutput", in the change
callback, associated LSN 0/307D8E8
Dave Cramer
On Thu, 19 Dec 2019 at 11:59, Dave Cramer wrote:
> The publication exists but for some reason the function can't find it
>
> SELECT * FROM pg_logical_slot_get_binary_changes('debezium', NULL,
> NULL,'proto_version','1','publicat
On Thu, 26 Dec 2019 at 15:07, Alvaro Herrera
wrote:
> On 2019-Oct-01, Greg Nancarrow wrote:
>
> > On Wed, Sep 11, 2019 at 10:17 AM Alvaro Herrera from 2ndQuadrant
> > wrote:
> > >
> > > Oh, oops. Here they are then.
> >
> > With the permission of the original patch author, Haribabu Kommi, I’ve
>
ose two things, then it's possible
> to create a sandbox which the end client cannot escape but which the
> pooler can escape easily.
>
So where are we on this patch ? AFAICT using _pq is a protocol level option.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On Mon, 2 Dec 2019 at 14:35, Dave Cramer wrote:
> Rebased against head
>
> Dave Cramer
>
>
> On Sat, 30 Nov 2019 at 20:48, Michael Paquier wrote:
>
>> Hi,
>>
>> On Mon, Nov 11, 2019 at 03:24:59PM -0500, Dave Cramer wrote:
>> > Attached,
>
s JDBC, and apparently they
> already have working patches for SCRAM.
>
We have more than patches this is already in the driver.
What do you mean by "massive-adoption exception"
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
>
>
include SCRAM support. 18.10 ships JDBC w/SCRAM support.
>
> On Debian, stretch is on 9.4. buster has 11 packaged, and JDBC is
> shipping with SCRAM support.
>
>
Honestly what JDBC driver XYZ distro ships with is a red herring. Any
reasonably complex java program is going to use maven and pull it's
dependencies.
That said from a driver developer, I support pushing this decision off to
PG13
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
>
>
On Mon, 8 Apr 2019 at 16:07, Alvaro Herrera
wrote:
> On 2019-Apr-08, Dave Cramer wrote:
>
> > > IIUC the vast majority of clients already support SCRAM auth. So the
> > > vast majority of PG users can take advantage of the additional
> security.
> > > I think
mentioned any reasonably complex
Java app is going to ensure it has the correct versions for their app using
Maven.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
>
On Mon, 8 Apr 2019 at 16:38, Tom Lane wrote:
> Dave Cramer writes:
> >> If someone installs a postgres RPM/DEB from postgresql.org, they could
> >> also install postgresql-jdbc, right ?
>
> > I would guess there might be some distro specific java apps that might
&
On Fri, 24 May 2019 at 07:48, Joe Conway wrote:
> On 5/23/19 10:30 PM, Stephen Frost wrote:
> > Greetings,
> >
> > * Tom Lane (t...@sss.pgh.pa.us) wrote:
> >> "Jonathan S. Katz" writes:
> >> > For now I have left in the password based method to be scram-sha-256
> as
> >> > I am optimistic about
delete |
pubtruncate
-+--+--+---+---+---+-
(0 rows)
Dave Cramer
On Sun, 26 May 2019 at 01:40, Jaime Casanova
wrote:
> On Sat, 25 May 2019 at 08:35, Dave Cramer wrote:
> >
> > How do I get rid of this slot ?
> >
> > select pg_drop_replication_slot('mysub');
> > ERROR: replication slot "mysub" is a
Thanks,
>>
>>
>> Álvaro
>>
>>
>> --
>>
>> Alvaro Hernandez
>>
>>
>> ---
>> OnGres
>>
>>
I believe there is a valid reason for providing a reasonably feature
complete plugin in core. S
Is there a reason why pgoutput sends data in text format? Seems to me that
sending data in binary would provide a considerable performance improvement.
Dave Cramer
Tom points out as being relevant to this discussion ISTM that this is
becoming a half baked "feature" that is being cobbled together instead of
being designed. Admittedly biased but I agree with Vladimir that libpq did
not implement the above feature using the same name and semantics. This
just serves to confuse the users.
Just my 2c worth
Dave Cramer
eature in that particular case.
>
>
And to enforce Robert's argument even further almost every pool
implementation I am aware of
has a keep alive query. So why not use the opportunity to check to see if
is a primary or standby at the same time
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
>
>
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
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, 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 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 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 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 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 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 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
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 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
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 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 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 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
D's per session
<https://www.postgresql.org/message-id/CADK3HHJxQ8ydLj98u7M0NGFh3x%3DrgoG9MVx8T6AanMbor2HTzw%40mail.gmail.com>
[2] PostgreSQL: default result formats setting
<https://www.postgresql.org/message-id/40cbb35d-774f-23ed-3079-03f938aacdae%402ndquadrant.com>
Dave Cramer
Dave Cramer
On Sat, 4 Mar 2023 at 11:35, Jeff Davis wrote:
> On Thu, 2023-03-02 at 09:13 -0500, Dave Cramer wrote:
> > I'd like to open up this discussion again so that we can
> > move forward. I prefer the GUC as it is relatively simple and as
> > Peter mentioned it
On Sat, 4 Mar 2023 at 19:06, Tom Lane wrote:
> Jeff Davis writes:
> > On Sat, 2023-03-04 at 18:04 -0500, Dave Cramer wrote:
> >> Most of the clients know how to decode the builtin types. I'm not
> >> sure there is a use case for binary encode types that the
Dave Cramer
On Sat, 4 Mar 2023 at 19:39, Dave Cramer wrote:
>
>
> On Sat, 4 Mar 2023 at 19:06, Tom Lane wrote:
>
>> Jeff Davis writes:
>> > On Sat, 2023-03-04 at 18:04 -0500, Dave Cramer wrote:
>> >> Most of the clients know how to decode the builtin t
+Paul Ramsey
On Mon, 20 Mar 2023 at 13:05, Jeff Davis wrote:
> On Mon, 2023-03-13 at 16:33 -0400, Dave Cramer wrote:
> > Attached is a preliminary patch that takes a list of OID's. I'd like
> > to know if this is going in the right direction.
>
>
Thanks for the
On Mon, 20 Mar 2023 at 19:10, Merlin Moncure wrote:
>
>
> On Mon, Mar 13, 2023 at 3:33 PM Dave Cramer wrote:
>
>>
>> Dave Cramer
>>
>>
>> On Sat, 4 Mar 2023 at 19:39, Dave Cramer wrote:
>>
>>>
>>>
>>> On Sat, 4 Mar
Dave Cramer
On Mon, 20 Mar 2023 at 15:09, Tom Lane wrote:
> Dave Cramer writes:
> > On Mon, 20 Mar 2023 at 13:05, Jeff Davis wrote:
> >> 2. Easy to confuse psql:
> >>
> >> CREATE TABLE a(d date, t timestamptz);
> >> SET format_binary=&#x
On Mon, 20 Mar 2023 at 15:09, Jeff Davis wrote:
> On Mon, 2023-03-20 at 14:36 -0400, Dave Cramer wrote:
> > Thanks for the review. I'm curious what system you are running on as
> > I don't see any of these errors.
>
> Are asserts enabled?
>
> > Well I&
On Tue, 21 Mar 2023 at 07:35, Merlin Moncure wrote:
>
>
> On Mon, Mar 20, 2023 at 7:11 PM Dave Cramer wrote:
>
>>
>>
>>
>> On Mon, 20 Mar 2023 at 19:10, Merlin Moncure wrote:
>>
>>>
>>>
>>> On Mon, Mar 13, 2023 at 3:33 PM D
On Tue, 21 Mar 2023 at 11:52, Jeff Davis wrote:
> On Mon, 2023-03-20 at 20:18 -0400, Dave Cramer wrote:
> > For JAVA pools it's probably OK, but for pools like pgbouncer we have
> > no control of who is going to get the connection next.
>
> Can pgbouncer use dif
If there's some extension that offers type "mytype", and perhaps allows
it to be installed in any schema, then it seems that the client library
would know how to parse all instances of "mytype" regardless of the
schema or search_path.
I may be overthinking this.
Dave Cra
server in advance.
The protocol extension design has the drawback that it can only be set at
startup.
What if we were to allow changes to the setting after startup if the client
passed the cancel key as a unique identifier that only the driver would
know?
Dave Cramer
>
>
On Wed, 22 Mar 2023 at 15:23, Jeff Davis wrote:
> On Wed, 2023-03-22 at 14:42 -0400, Tom Lane wrote:
> > This isn't going to help much unless we change the wire protocol
> > so that RowDescription messages carry these UUIDs instead of
> > (or in addition to?) the OIDs of the column datatypes. Wh
1 - 100 of 417 matches
Mail list logo
