Re: Error on failed COMMIT

more convenient if PostgreSQL reported those errors in a > somewhat different way. I think that's a fair criticism, but I don't > think it's a sufficient reason to change the behavior. > I think the fact that this is a violation of the SQL SPEC lends considerable credence to the argument for changing the behaviour. Since this can lead to losing a transaction I think there is even more reason to look at changing the behaviour. Dave Cramer www.postgres.rocks

Re: Error on failed COMMIT

On Sun, 23 Feb 2020 at 00:41, Shay Rojansky wrote: > > > On Fri, 14 Feb 2020 at 14:37, Robert Haas wrote: >> >>> On Fri, Feb 14, 2020 at 2:08 PM Dave Cramer >>> wrote: >>> > Well now you are asking the driver to re-interpret the results in a >&g

Re: Error on failed COMMIT

On Mon, 17 Feb 2020 at 13:02, Haumacher, Bernhard wrote: > Am 14.02.2020 um 20:36 schrieb Robert Haas: > > On Fri, Feb 14, 2020 at 2:08 PM Dave Cramer > wrote: > >> Well now you are asking the driver to re-interpret the results in a > different way than the server w

Re: New messages from Priscilla Ip

Hi, Feel free to send out the email blast. There are a number of other channels. postgres slack, postgres mailing lists, @PostgreSQL Hackers , twitter with Postgres tag Cheers, Dave Cramer On Sat, 15 Feb 2020 at 19:44, 'Meetup Messages' via Meetup < mee...@postgresql.us>

Re: Error on failed COMMIT

On Fri, 14 Feb 2020 at 15:19, Alvaro Herrera wrote: > On 2020-Feb-14, Dave Cramer wrote: > > > I offered to make the behaviour in the JDBC driver dependent on a > > configuration parameter > > Do you mean "if con.commit() results in a rollback, then an exception is &

Re: Error on failed COMMIT

On Fri, 14 Feb 2020 at 15:07, Tom Lane wrote: > Dave Cramer writes: > > On Fri, 14 Feb 2020 at 14:37, Robert Haas wrote: > >> I'm not trying to deny that you might find some other server behavior > >> more convenient. You might. And, to Vik's original point, it m

Re: Error on failed COMMIT

On Fri, 14 Feb 2020 at 14:37, Robert Haas wrote: > On Fri, Feb 14, 2020 at 2:08 PM Dave Cramer > wrote: > > Well now you are asking the driver to re-interpret the results in a > different way than the server which is not what we tend to do. > > > > The server throws

Re: Error on failed COMMIT

On Fri, 14 Feb 2020 at 13:29, Robert Haas wrote: > On Fri, Feb 14, 2020 at 1:04 PM Dave Cramer > wrote: > > Thing is that con.commit() DOESN'T return a status code, nor does it > throw an exception as we silently ROLLBACK here. > > Why not? There's nothing keeping the dri

Re: Error on failed COMMIT

ransaction failed we seem to do different things In Tom's example we do issue a warning and say there is no transaction running. I would guess we silently rolled back earlier. In my example we don't issue the warning we just roll back. I do agree with Tom that changing this behaviour at this point would make things worse for more people than it would help so I am not advocating throwing an error here. I would however advocate for consistently doing the same thing with failed transactions Dave Cramer www.postgres.rocks

documenting divergence from the SQL spec

? Dave Cramer www.postgres.rocks

Re: Error on failed COMMIT

On Tue, 11 Feb 2020 at 17:35, Tom Lane wrote: > Vik Fearing writes: > > There is a current discussion off-list about what should happen when a > > COMMIT is issued for a transaction that cannot be committed for whatever > > reason. PostgreSQL returns ROLLBACK as command tag but otherwise >

Re: [hibernate-dev] api/doc suggestions

ess session is marked as > deprecated with [no alternative nor actual > docs/info]( > https://github.com/hibernate/hibernate-orm/blob/master/hibernate-core/src/main/java/org/hibernate/StatelessSession.java#L169 > ). > > on Ses

Question about selecting text

Hello, When I get an email or am looking at something and want to select some text, such as a block of text or perhaps an email address, is it doable if I wasn't the one to originate it? For example, someone sent me an email the other day, and there were some things I wanted to select from it,

Re: [GTALUG] I believe Amazon is leaking delivery information.

On Thu, 16 Jan 2020 at 14:28, Alvin Starr via talk wrote: > On 1/16/20 2:13 PM, David Thornton via talk wrote: > > It it possible that an advertisement can "know" the page it was > deployed in? > > Or even just some properties of the page it was displayed in? > > Via this means an advertiser

Re: [GTALUG] ***UNCHECKED*** Re: I believe Amazon is leaking delivery information.

On Sun, 2 Feb 2020 at 11:17, Alvin Starr wrote: > On 2/2/20 6:11 AM, Dave Cramer wrote: > > > > > Reviving this thread from the dead. > > Is it possible you have a smart doorbell. Apparently they are sending data. > > https://www.eff.org/deeplinks/2020/01/ring-d

Re: Binary support for pgoutput plugin

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, >

Re: [hibernate-dev] 6.0 - HQL literals

Dave Cramer On Mon, 13 Jan 2020 at 11:10, Yoann Rodiere wrote: > Hi, > > As far as I know there wasn't any specific time-related problem with the > org.postgresql:postrgresql driver. I'm not sure we run tests against > pgjdbc, that might be something to consider. > Please

Re: [hibernate-dev] 6.0 - HQL literals

mode. Thanks, Dave Cramer On Sun, 12 Jan 2020 at 23:36, Steve Ebersole wrote: > Hi Dave. > > Same - I was swamped with stuff at the end of last week. > > Yes, from what I was reading postgres is a bit strange in storing temporal > values. Not unique to postgres -

Re: [hibernate-dev] 6.0 - HQL literals

Hi, As one of the maintainers of the postgres jdbc driver I am interested in this discussion. Postgres only stores date/times in UTC. Everything else is a translation. The driver uses the client's timezone for all dates/times (for better or worse) If there is anything I can do to help make things

A little more about my iPhone voice and clarity

I realize that I probably didn't explain my question very well. When I reset my phone to factory settings, I went back into VoiceOver and chose the Ava voice, which is one I'd used for a while. However, she sounds kind of muffled or maybe compact instead of as clear as she once did. Is there an

iPhone voice sounds funny

Hello, I recently had to take my phone back to factory settings. I didn't delete my data, but all of the settings went back and I'm having to re-do them. Right now, my VoiceOver voice sounds funny. It doesn't sound clear the way it used to, and I chose the voice I was using before. Is there

Bug#686141: patch to add stdin support to galax-run

The following patch adds support for reading from standard input when - is given as an argument. diff -ur a/galax-1.1/toplevel/galax-run.ml b/galax-1.1/toplevel/galax-run.ml --- a/galax-1.1/toplevel/galax-run.ml 2007-10-26 08:49:33.0 -0700 +++ b/galax-1.1/toplevel/galax-run.ml

Bug#686141: patch to add stdin support to galax-run

The following patch adds support for reading from standard input when - is given as an argument. diff -ur a/galax-1.1/toplevel/galax-run.ml b/galax-1.1/toplevel/galax-run.ml --- a/galax-1.1/toplevel/galax-run.ml 2007-10-26 08:49:33.0 -0700 +++ b/galax-1.1/toplevel/galax-run.ml

Re: let's make the list of reportable GUCs configurable (was Re: Add %r substitution for psql prompts to show recovery status)

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

Re: Libpq support to connect to standby server as priority

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

[ccp4bb] ftp://strucbio.biologie.uni-konstanz.de/pub down?

Dear collegues, I am trying to install xdsgui, however, I cannot access any files on the ftp server ftp://strucbio.biologie.uni-konstanz.de/pub. https://www.isitdownrightnow.com/ suggests, that it is not just me, but the server is really down. Does anyone have information about whether or when

Bug#944277: actually a bug in camlp5

This is probably caused by a bug in camlp5, caught by a stricter dynamic linker in OCaml 4.08. It is fixed in camlp5 7.10. See https://github.com/camlp5/camlp5/pull/46

Bug#944277: actually a bug in camlp5

This is probably caused by a bug in camlp5, caught by a stricter dynamic linker in OCaml 4.08. It is fixed in camlp5 7.10. See https://github.com/camlp5/camlp5/pull/46

Bug#944277: actually a bug in camlp5

This is probably caused by a bug in camlp5, caught by a stricter dynamic linker in OCaml 4.08. It is fixed in camlp5 7.10. See https://github.com/camlp5/camlp5/pull/46

Re: How is this possible "publication does not exist"

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','publication_names','dbz_publication'); > ERRO

How is this possible "publication does not exist"

does not exist CONTEXT: slot "debezium", output plugin "pgoutput", in the change callback, associated LSN 0/307D8E8 Dave Cramer

Bug#922692: patch

The following patch allows it to build. diff -ur a/galax-1.1/base/gmisc.ml b/galax-1.1/base/gmisc.ml --- a/galax-1.1/base/gmisc.ml 2007-02-28 10:48:06.0 -0800 +++ b/galax-1.1/base/gmisc.ml 2019-12-17 15:40:56.975372234 -0800 @@ -80,7 +80,7 @@ | Some x -> get_them

Bug#922692: patch

The following patch allows it to build. diff -ur a/galax-1.1/base/gmisc.ml b/galax-1.1/base/gmisc.ml --- a/galax-1.1/base/gmisc.ml 2007-02-28 10:48:06.0 -0800 +++ b/galax-1.1/base/gmisc.ml 2019-12-17 15:40:56.975372234 -0800 @@ -80,7 +80,7 @@ | Some x -> get_them

Bug#922692: patch

The following patch allows it to build. diff -ur a/galax-1.1/base/gmisc.ml b/galax-1.1/base/gmisc.ml --- a/galax-1.1/base/gmisc.ml 2007-02-28 10:48:06.0 -0800 +++ b/galax-1.1/base/gmisc.ml 2019-12-17 15:40:56.975372234 -0800 @@ -80,7 +80,7 @@ | Some x -> get_them

Re: client auth docs seem to have devolved

> 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

Re: client auth docs seem to have devolved

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

client auth docs seem to have devolved

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

Re: Binary support for pgoutput plugin

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

Bug#945246: fails to build from source, attempts to install file in / rather than debian/tmp/

Package: liquidsoap Version: 1.4.0-1 While building the package, I received this error: /usr/bin/install -c -m 644 scripts/bash-completion /usr/share/bash-completion/completions/liquidsoap /usr/bin/install: cannot create regular file '/usr/share/bash-completion/completions/liquidsoap':

Bug#945246: fails to build from source, attempts to install file in / rather than debian/tmp/

Package: liquidsoap Version: 1.4.0-1 While building the package, I received this error: /usr/bin/install -c -m 644 scripts/bash-completion /usr/share/bash-completion/completions/liquidsoap /usr/bin/install: cannot create regular file '/usr/share/bash-completion/completions/liquidsoap':

Bug#944593: patch for pxp ftbfs

The following patch fixes this problem. diff --git a/src/pxp-engine/pxp_lexing.mli b/src/pxp-engine/pxp_lexing.mli index 5dc3497..ffa6e34 100644 --- a/src/pxp-engine/pxp_lexing.mli +++ b/src/pxp-engine/pxp_lexing.mli @@ -10,11 +10,11 @@ type lexbuf = Lexing.lexbuf -val from_channel :

Bug#944593: patch for pxp ftbfs

The following patch fixes this problem. diff --git a/src/pxp-engine/pxp_lexing.mli b/src/pxp-engine/pxp_lexing.mli index 5dc3497..ffa6e34 100644 --- a/src/pxp-engine/pxp_lexing.mli +++ b/src/pxp-engine/pxp_lexing.mli @@ -10,11 +10,11 @@ type lexbuf = Lexing.lexbuf -val from_channel :

Bug#944593: patch for pxp ftbfs

The following patch fixes this problem. diff --git a/src/pxp-engine/pxp_lexing.mli b/src/pxp-engine/pxp_lexing.mli index 5dc3497..ffa6e34 100644 --- a/src/pxp-engine/pxp_lexing.mli +++ b/src/pxp-engine/pxp_lexing.mli @@ -10,11 +10,11 @@ type lexbuf = Lexing.lexbuf -val from_channel :

Re: jexec as user?

On Tue, 19 Nov 2019, mike tancsa wrote: On 11/19/2019 8:09 AM, Christos Chatzaras wrote: On 19 Nov 2019, at 15:02, mike tancsa wrote: On 11/19/2019 6:42 AM, Ronald Klop wrote: Hi, Is it possible to jexec into a jail as a regular user. Or to enable that somewhere? Or is the way to do such a

Re: Binary support for pgoutput plugin

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. (Doing

Re: Binary support for pgoutput plugin

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 com

Re: Binary support for pgoutput plugin

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

Re: Binary support for pgoutput plugin

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/

Re: let's make the list of reportable GUCs configurable (was Re: Add %r substitution for psql prompts to show recovery status)

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_strncas

Re: Binary support for pgoutput plugin

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 decla

Re: Binary support for pgoutput plugin

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. > > > I sti

Re: Automatically parsing in-line composite types

; > am assuming is available to PostreSQL internally? > > > Reading the RowDescription is the only way I am aware of. Dave Cramer da...@postgresintl.com www.postgresintl.com

[docbook-apps] saxon6:output for running DocBook 1.0 xslts using Saxon 9.9

I just stumbled on this (haven't tried it out yet though). It could be I'm the last to hear about it, but I thought I'd post it just in case. If you wanted to use your existing customization layer with Calabash, for example, now you can :-)

Sounds for different email accounts

Hello, I didn't mean for my phone to update to the new IOS, but it did, so I'm getting used to it. However, I need some help with something. I had a different notification sound for my default email account than for my other. With the update, that changed, and now the emails have the same

[CODE4LIB] registration now open: Fantastic Futures conference on AI in LAMs: December 4-6, 2019

Registration is now open for Fantastic Futures 2019, the 2nd International Conference on AI for Libraries, Archives, and Museums. Join us December 4-6 at Stanford University for three days of study and community building. This conference is a forum for

Re: [swinog] SBB partially reachable via IPv6

sbb.ch > verify return:1 > --- > Certificate chain > 0 s:jurisdictionC = CH, jurisdictionST = Bern, serialNumber = > CHE-102.909.703, businessCategory = Private Organization, C = CH, ST = Bern, > L = Bern, O = Schweizerische Bundesbahnen SBB, OU = IT, CN = www.sbb.ch >i

Re: let's make the list of reportable GUCs configurable (was Re: Add %r substitution for psql prompts to show recovery status)

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

Re: let's make the list of reportable GUCs configurable (was Re: Add %r substitution for psql prompts to show recovery status)

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

Re: let's make the list of reportable GUCs configurable (was Re: Add %r substitution for psql prompts to show recovery status)

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 this

Re: let's make the list of reportable GUCs configurable (was Re: Add %r substitution for psql prompts to show recovery status)

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: >&

Re: let's make the list of reportable GUCs configurable (was Re: Add %r substitution for psql prompts to show recovery status)

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 I

Re: I'm surprised to see the word master here

Ya, I was under that impression as well. Dave Cramer On Tue, 24 Sep 2019 at 18:18, Renee wrote: > I was under the impression that both terms were being deprecated. Is that > only the case when they appear in tandem? > > > On Sep 24, 2019, at 6:05 PM, Peter Eisentraut &l

good Linux terminal emulator for screen?

Can anyone recommend a terminal emulator for Linux which a) provides 256 colors b) can be configured not to scroll when I drag select some text and head "north" of the top of the terminal emulator? I have tried the st terminal emulator , but would prefer something more

pg_upgrade issues

? I realize oids are not guaranteed to be unique, but this seems to be quite a coincidence. Dave Cramer

Monitoring steps with iPhone or Apple watch?

Hello. I've been asked if I wanted to join a group of people who will begin monitoring their steps on a daily basis. A goal will be set and I guess we'll keep track of and report our steps weekly. People told me I can do this using either my iPhone or Apple Watch. I'd love to know what I need to

Re: Procedure support improvements

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()

[CODE4LIB] Fwd: [arclight-community] Announcing the ArcLight Phase II work cycle kickoff

d product owner), Chris Powell (Michigan), Josh Schneider (Stanford) * Steering/Advisory Group: Esmé Cowles (Princeton), Tom Cramer (Stanford), Michelle Dalmau (Indiana), Jon Dunn (Indiana), Jim Halliday (Indiana), Will Sexton (Duke), John Weise (Michigan) All best, Mark Mark A. MATIENZO

Re: [Pdns-users] Zone Transfers

  >> stanf...@tech.vi <mailto:stanf...@tech.vi> ~ http://www.tech.vi >> <http://www.tech.vi/> ~ 786-269-5718 >> >> VI Technical Services, LLC ~ 9160 Estate Thomas ~  >> Suite 195 ~ St. Thomas, VI, 00802 >> >> >> On Mon, Aug 5, 2019 at 8:53 AM Matth

Re: [Pdns-users] Zone Transfers

> https://mailman.powerdns.com/mailman/listinfo/pdns-users >> >> Frank Louwers >> PowerDNS Certified Consultant @ Kiwazo.be <http://Kiwazo.be> >> >> >> >> >> >> ___ >> Pd

Re: Built-in connection pooler

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

[CODE4LIB] Blacklight-LD working meeting: call for expressions of interest to participate

d are keen to advance library discovery with linked open data, with Blacklight as the reference platform. Interested parties can express interest in participating here: https://forms.gle/q7u2KY7eZg3ZHzvZ7 The form will be open through August 5, 2019; responses to EOIs will be returned the week of August

[CODE4LIB] Save the Date - PASIG Madrid, May 19-21, 2020

Assistant in Digitalizing Area STEERING COMMITTEE / COMITE DIRECTIVO: Natalie Baur, El Colegio de México Tom Cramer, Stanford University Ben Fino-Radin, Small Data Industries Neil Jefferies, University of Oxford Thomas Ledoux, Bibliotheque Nationale de France Sarah Mason, Artefactual Systems Becky

Re: let's make the list of reportable GUCs configurable (was Re: Add %r substitution for psql prompts to show recovery status)

On Thu, 11 Jul 2019 at 15:07, Robert Haas wrote: > On Thu, Jul 11, 2019 at 2:29 PM Dave Cramer wrote: > > So if I understand this correctly if user bob has altered his search > path and there is a security-definer function called owned by him then > > the search pa

Re: let's make the list of reportable GUCs configurable (was Re: Add %r substitution for psql prompts to show recovery status)

On Wed, 10 Jul 2019 at 16:22, Robert Haas wrote: > 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 I do > believe this is potentially a security issue. > > It may be that we always want to report that and p

Re: let's make the list of reportable GUCs configurable (was Re: Add %r substitution for psql prompts to show recovery status)

t > > the list to see if a newly-defined variable should be marked GUC_REPORT. > This suggests creating a list in guc.c instead. I'm unclear as to the visibility of variables in there How do I make this list visible only to the session ? Dave Cramer da...@postgresintl.com www.postgresintl.com > >

Re: let's make the list of reportable GUCs configurable (was Re: Add %r substitution for psql prompts to show recovery status)

On Thu, 11 Jul 2019 at 10:06, Robert Haas wrote: > On Thu, Jul 11, 2019 at 8:23 AM Dave Cramer wrote: > > See attached for an initial patch. If this is an acceptable way to go I > will add tests and documentation > > And clean up the code? Doesn't look crazy on a quick glan

Re: let's make the list of reportable GUCs configurable (was Re: Add %r substitution for psql prompts to show recovery status)

On Wed, 10 Jul 2019 at 16: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 I do > believe this is potentially a security issue. > >> It may be

Re: let's make the list of reportable GUCs configurable (was Re: Add %r substitution for psql prompts to show recovery status)

On Wed, 10 Jul 2019 at 09:11, Robert Haas wrote: > On Tue, Jul 9, 2019 at 2:32 PM Dave Cramer wrote: > > So did this die from lack of interest? > > > > I have proposed in another thread adding more GUC REPORT variables, but > I see this as a much better way. >

Re: let's make the list of reportable GUCs configurable (was Re: Add %r substitution for psql prompts to show recovery status)

T variables, but I see this as a much better way. I'm willing to code the patch if we can get some buy in here ? Dave Cramer da...@postgresintl.com www.postgresintl.com

Re: Proposal to add GUC_REPORT to lc_monetary, lc_numeric and search_path

there was a proposal to make reportable GUC's configurable here https://www.postgresql.org/message-id/ca+tgmobsxsy0kfr_vdqqoxjxqafnesfxf_-darne+qhhqcw...@mail.gmail.com I don't really care which one gets implemented, although I think the latter makes more sense. Dave Cramer On Fri, 5 Jul 2019 at 08:05, Shay

Re: Re: Reviving the "Stopping logical replication protocol" patch from Vladimir Gordichuk

On Mon, 8 Jul 2019 at 06:40, Thomas Munro wrote: > On Thu, Mar 7, 2019 at 8:19 PM David Steele wrote: > > On 2/16/19 10:38 PM, Dave Cramer wrote: > > > Thanks for looking at this. FYI, I did not originally write this, > rather > > > the original author has not r

iPhone and Dish Anywhere App

Hi, I hope someone here uses the Dish Anywhere app on their iPhones and can answer the following questions. Is there a way to transfer recordings of shows directly to the iPhone? I'm going out of town and would love to be able to watch some of these TV shows I've recorded while flying. If not,

Proposal to add GUC_REPORT to lc_monetary, lc_numeric and search_path

these statements fail. This seems like a rather innocuous change as the protocol is not changed, rather the amount of information returned on startup is increased marginally. I've included the authors of the npgsql and the node drivers in the email for their input. Dave Cramer

?Minor Security Issue - DNS, /etc/hosts, freebsd-update, ?pkg

Suspected severity: Low. Systems with inattentive administrators may not receive the latest updates, and no obvious error messages will point out the problem. Situation discovered in: A few older 11.2-RELEASE FreeBSD systems, with /etc/hosts entries like this: 96.47.72.72

Re: Binary support for pgoutput plugin

On Wed, 5 Jun 2019 at 18:50, Andres Freund wrote: > Hi, > > On 2019-06-05 18:47:57 -0400, Dave Cramer wrote: > > So one of the things they would like added is to get not null information > > in the schema record. This is so they can mark the field Optional in > Java.

Re: [swinog] Geldspielgesetz: Zugangssperren Q

Noch besser einen Error 451: Unavailable For Legal Reasons (RFC 7725) Gruss Matthias On 28/06/2019 09:10, xaerni wrote: > Hallo. > Denke nicht  das das geregelt ist. Theoretisch kannst Du ein Error 404 > schicken. > Gruss Xaver > -- Matthias Cramer / mc322-ripe Senior Net

Re: Fix doc bug in logical replication.

On Thu, 27 Jun 2019 at 14:20, Tomas Vondra wrote: > On Thu, Jun 27, 2019 at 01:46:47PM -0400, Dave Cramer wrote: > >On Thu, 27 Jun 2019 at 12:50, Tomas Vondra > >wrote: > > > >> On Sun, Jun 23, 2019 at 10:26:47PM -0400, Robert Treat wrote: > >> >On Sun

Re: Fix doc bug in logical replication.

On Thu, 27 Jun 2019 at 12:50, Tomas Vondra wrote: > On Sun, Jun 23, 2019 at 10:26:47PM -0400, Robert Treat wrote: > >On Sun, Jun 23, 2019 at 1:25 PM Peter Eisentraut > > wrote: > >> > >> On 2019-04-12 19:52, Robert Treat wrote: > >> > It is clear to me that the docs are wrong, but I don't see

Re: Binary support for pgoutput plugin

On Fri, 14 Jun 2019 at 15:42, Dave Cramer wrote: > > Dave Cramer > > > On Fri, 14 Jun 2019 at 14:36, Tomas Vondra > wrote: > >> On Wed, Jun 12, 2019 at 10:35:48AM -0400, Dave Cramer wrote: >> >On Mon, 10 Jun 2019 at 07:49, Petr Jelinek > > >> >

Re: Async client libraries - not worth it?

On Mon, 17 Jun 2019 at 09:43, Rob Nikander wrote: > > > > On Jun 17, 2019, at 3:57 PM, Dave Cramer wrote: > > […] Postgres can pipeline requests if the client is written correctly so > it is conceivable that this would be much faster. > > Can the JDBC driver do this

Re: Async client libraries - not worth it?

On Mon, 17 Jun 2019 at 07:35, Rob Nikander wrote: > > > On Jun 17, 2019, at 1:12 PM, Dave Cramer wrote: > > https://www.techempower.com/benchmarks/#section=data-r17=ph=db > > Seems to be worth it. > > Now it appears that ADBA is going to die on the vine, R2DBC and ver

Re: Async client libraries - not worth it?

t; https://www.techempower.com/benchmarks/#section=data-r17=ph=db Seems to be worth it. Now it appears that ADBA is going to die on the vine, R2DBC and vertx seem to be pretty good Dave Cramer da...@postgresintl.com www.postgresintl.com

Re: Binary support for pgoutput plugin

Dave Cramer On Fri, 14 Jun 2019 at 14:36, Tomas Vondra wrote: > On Wed, Jun 12, 2019 at 10:35:48AM -0400, Dave Cramer wrote: > >On Mon, 10 Jun 2019 at 07:49, Petr Jelinek > >wrote: > > > >> Hi, > >> > >> On 10/06/2019 13:27, Da

Re: Binary support for pgoutput plugin

On Mon, 10 Jun 2019 at 07:49, Petr Jelinek wrote: > Hi, > > On 10/06/2019 13:27, Dave Cramer wrote: > > So back to binary output. > > > > From what I can tell the place to specify binary options would be in the > > create publication and or in replication slot

Re: Binary support for pgoutput plugin

ata in logicalrep_read_tuple but that would require moving a lot of the logic currently in worker.c to proto.c. This seems minimally invasive. and thanks Petr for the tip to use pglogical for ideas. Thanks, Dave Cramer > > 0001-First-pass-at-working-code-without-subscription-opti.patch Descriptio

Re: Binary support for pgoutput plugin

So back to binary output. >From what I can tell the place to specify binary options would be in the create publication and or in replication slots? The challenge as I see it is that the subscriber would have to be able to decode binary output. Any thoughts on how to handle this? At the moment

Re: Binary support for pgoutput plugin

On Sat, 8 Jun 2019 at 20:09, Andres Freund wrote: > Hi, > > On 2019-06-08 19:41:34 -0400, Dave Cramer wrote: > > So the reason we are discussing using pgoutput plugin is because it is > part > > of core and guaranteed to be in cloud providers solutions. > >

Binary support for pgoutput plugin

This should have gone to hackers as well -- Forwarded message - From: Dave Cramer Date: Sat, Jun 8, 2019, 6:41 PM Subject: Re: Binary support for pgoutput plugin To: Tomas Vondra On Sat, Jun 8, 2019, 6:27 PM Tomas Vondra, wrote: > On Fri, Jun 07, 2019 at 06:01:12PM -0

Re: Binary support for pgoutput plugin

Hi, On Wed, 5 Jun 2019 at 18:50, Andres Freund wrote: > Hi, > > On 2019-06-05 18:47:57 -0400, Dave Cramer wrote: > > So one of the things they would like added is to get not null information > > in the schema record. This is so they can mark the field Optional in

Re: Binary support for pgoutput plugin

Hi, On Wed, 5 Jun 2019 at 12:01, Andres Freund wrote: > Hi > > On June 5, 2019 8:51:10 AM PDT, Dave Cramer wrote: > >On Wed, 5 Jun 2019 at 07:21, Dave Cramer wrote: > > > >> Hi, > >> > >> > >> On Wed, 5 Jun 2019 at 07:18, Petr Jelinek

<    1   2   3   4   5   6   7   8   9   10   >