Re: Chapter 43.8. "Transaction Management" fails to state two critical restrictions

2019-09-30 Thread Bryn Llewellyn
Hello, Bruce. (We met at the OUGN conference last March on the Oslo-Kiel ferry.) Thanks for your reply. 1. About AUTOCOMMIT It’s very hard to get a clear account of what AUTOCOMMIT really is. So consider the example from the docs section that I cited, and run these psql commands at its

Re: Proposal to improve the content in subsection 8.16.6. "Composite Type Input and Output Syntax"

2020-04-06 Thread Bryn Llewellyn
Tom Lane wrote:...It's already an example, so I don't see this as an improvementThe proposed additional text is flat-out wrong.What actually happens here is that text between quotes is consideredquoted (so that, for example, commas within it are not field separators),but

Re: COPY statement: no list of the allowed values for "format_name"

2020-10-30 Thread Bryn Llewellyn
PG Doc comments form wrote: Look at the account of the COPY statement, here: https://www.postgresql.org/docs/11/sql-copy.html and see this: « [ [ WITH ] ( option [, ...] ) ] » It goes on to say this: « where option can be one of: FORMAT

Where is the syntax "<-08>+08" documented—comes from "select current_setting('timezone')"

2021-05-13 Thread Bryn Llewellyn
Summary: Where in the PG docs can I find a self-contained expository essay that explains everything that I need to know in order to understand what's going on in the examples that I show below, and to allow me always confidently to predict the results? Notice that "show datestyle" gives me the

Re: Where is the syntax "<-08>+08" documented—comes from "select current_setting('timezone')"

2021-05-13 Thread Bryn Llewellyn
> david.g.johns...@gmail.com wrote: > > On Thu, May 13, 2021 at 12:38 PM Bryn Llewellyn <mailto:b...@yugabyte.com>> wrote: > « POSIX has positive signs west of Greenwich, but many people expect positive > signs east of Greenwich. » > > Is there a setting that

Re: typo in doc for "Miscellaneous Coding Conventions"

2021-05-18 Thread Bryn Llewellyn
t...@sss.pgh.pa.us wrote: > PG Doc comments form writes: > >> small fix in description at [1] as follows > >> -If that were not done interrupted code that's currently inspecting errno >> might see the wrong value. >> +If that was not done interrupted code that's currently inspecting errno >>

Where are the legal values for LC_TIME listed?

2021-05-17 Thread Bryn Llewellyn
It’s easy to guess values for, say, countries in Europe: This: create function to_char_demo() returns table(z text) language plpgsql as $body$ declare -- Counted from midnight 1-Jan-1970 UTC. secs constant double precision not null := 94996756799.456789; t constant timestamp

Re: Where are the legal values for LC_TIME listed?

2021-05-17 Thread Bryn Llewellyn
t...@sss.pgh.pa.us wrote: > Bryn wrote: > >> It’s easy to guess values for, say, countries in Europe: > > On Unix-ish systems, "locale -a" should provide the set of available values. > We don't attempt to document this because it's so installation-dependent. > >> But what do I use for, say,