Re: timestamp with time zone ~> GMT

2025-02-03 Thread Dave Cramer
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;

Re: Monetary Data Types Improvement

2024-03-20 Thread 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

Re: The pg_stop_backup will return one row with three values.

2021-12-20 Thread Dave Cramer
On Mon, 20 Dec 2021 at 08:12, Julien Rouhaud wrote: > On Mon, Dec 20, 2021 at 8:19 PM Dave Cramer > wrote: > > > > On Mon, 20 Dec 2021 at 07:03, Laurenz Albe > wrote: > >> > >> On Sun, 2021-12-19 at 21:08 +, PG Doc comments form wrote: > >

Re: The pg_stop_backup will return one row with three values.

2021-12-20 Thread Dave Cramer
On Mon, 20 Dec 2021 at 07:03, Laurenz Albe wrote: > On Sun, 2021-12-19 at 21:08 +, PG Doc comments form wrote: > > Page: https://www.postgresql.org/docs/14/continuous-archiving.html > > Description: > > > > It appears that this may be out of date. > > > > pg_stop_backup > > >

Re: Background worker docs,

2021-08-27 Thread Dave Cramer
On Fri, 27 Aug 2021 at 10:15, Tom Lane wrote: > Daniel Gustafsson writes: > > On 27 Aug 2021, at 15:52, Dave Cramer wrote: > >> In my mind "in the event that it crashes" made it clear > > > That, or “if it crashes” gets my vote.

Re: Background worker docs,

2021-08-27 Thread Dave Cramer
On Fri, 27 Aug 2021 at 09:50, Tom Lane wrote: > Dave Cramer writes: > >> - postgres should wait before restarting the > >> process, in > >> + postgres should wait before restarting the > >> process in > > > As a native English speaker, I was l

Re: Background worker docs,

2021-08-27 Thread Dave Cramer
On Fri, 27 Aug 2021 at 09:24, Daniel Gustafsson wrote: > > On 27 Aug 2021, at 15:17, Dave Cramer wrote: > > > > Why is the last comma there ? > > > > "bgw_restart_time is the interval, in seconds, that postgres should wait > before restarting the process, i

Background worker docs,

2021-08-27 Thread Dave Cramer
can be any positive value, or BGW_NEVER_RESTART, indicating not to restart the process in case of a crash. Dave Cramer

Re: Use of the word master

2021-08-06 Thread Dave Cramer
On Thu, 5 Aug 2021 at 19:19, Jonathan S. Katz wrote: > On 8/5/21 2:26 PM, Dave Cramer wrote: > > PostgreSQL: Documentation: 13: 30.1. Publication > > < > https://www.postgresql.org/docs/current/logical-replication-publication.html > > > > > > > > &q

Use of the word master

2021-08-05 Thread Dave Cramer
PostgreSQL: Documentation: 13: 30.1. Publication <https://www.postgresql.org/docs/current/logical-replication-publication.html> "A *publication* can be defined on any physical replication master." I would propose "any physical replication primary" Dave Cramer

Re: psql's commit df9f599b is not documented

2021-08-03 Thread Dave Cramer
e-versa. > I would agree. If it's worth coding it's worth documenting. Unless of course the intention is that this is temporary. I would also argue that putting them in the release notes is not enough. Am I expected to go through the release notes after I don't find it in the documentation ? Do we have other undocumented features ? Dave Cramer > > > >

Re: Git is not an acronym

2021-06-10 Thread Dave Cramer
On Thu, 10 Jun 2021 at 09:04, Jonathan S. Katz wrote: > On 6/10/21 7:40 AM, Daniel Gustafsson wrote: > > Commit 651377933e031 cleaned up references to CVS replacing them with > Git. > > Replacing CVS with Git in acronyms.sgml seems a bit incorrect though as > Git > > isn't an acronym (but CVS is,

Re: Default value for the defaultAutoCommit property

2021-06-03 Thread Dave Cramer
Good catch. Thanks, I will fix that. Dave Cramer www.postgres.rocks On Thu, 3 Jun 2021 at 03:49, Celinio Fer wrote: > Hi, > I wonder if the documentation for the JDBC PostgreSQL driver is up to date > : > https://jdbc.postgresql.org/documentation/head/ds-cpds.html#ds-cpds-p

Re: SELECT last_value FROM sequence_name;

2021-04-12 Thread Dave Cramer
incremented since the last use ? The correct way to use a sequence is to increment it and then use currval or the like Dave Cramer www.postgres.rocks

Re: Procedures

2020-08-06 Thread Dave Cramer
ocs/12/plpgsql-transactions.html > > Is this what you think needs improving? > > Neither of those places mention that procedures cannot be called inside a transaction. So ya I think there there is some room for improvement Dave Cramer www.postgres.rocks

Re: Please add a link to [BRIN] physical block ranges of a table

2020-06-25 Thread Dave Cramer
On Thu, 25 Jun 2020 at 10:10, Bruce Momjian wrote: > On Wed, Jun 24, 2020 at 05:13:05PM +, PG Doc comments form wrote: > > The following documentation comment has been logged on the website: > > > > Page: https://www.postgresql.org/docs/12/indexes-types.html > > Description: > > > > Can you p

This is not true or at the very least confusing

2020-05-08 Thread Dave Cramer
section 25.3.3.1 in section 25.2. I also think that the discussion about frozen snapshots is ill advised. If I were doing it I would use pg_start_backup before using any file system snapshot. Regards, Dave Cramer

Re: Improve This Sentence?

2020-04-13 Thread Dave Cramer
On Sun, 12 Apr 2020 at 20:57, Michael Paquier wrote: > On Fri, Apr 10, 2020 at 06:32:05PM +, PG Doc comments form wrote: > > On Linux and POSIX platforms checkpoint_flush_after allows to force the > OS > > that pages written by the checkpoint should be flushed to disk after a > > configurable

Re: char 0x00

2020-03-28 Thread Dave Cramer
We don't have to make it consumable. If we can use his code and reproduce it in the JDBC driver that is enough. Dave Cramer On Sat, 28 Mar 2020 at 11:31, Brett Okken wrote: > Dave, any thoughts on best way to reproduce Vladimir’s described workflow > in a way that is consum

Re: documenting divergence from the SQL spec

2020-02-14 Thread Dave Cramer
On Fri, 14 Feb 2020 at 11:26, Tom Lane wrote: > Dave Cramer writes: > > We have a section in the main docs for conformance > > https://www.postgresql.org/docs/12/features.html > > And then this > https://wiki.postgresql.org/wiki/PostgreSQL_vs_SQL_Standard for > > d

documenting divergence from the SQL spec

2020-02-14 Thread Dave Cramer
ughts ? Dave Cramer www.postgres.rocks

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

2019-09-24 Thread Dave Cramer
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