ALTER SYSTEM between upgrades

2020-07-13 Thread Bruce Momjian
On Tue, Jul 7, 2020 at 04:18:21PM -0400, Alvaro Herrera wrote: > On 2020-Jul-07, Amit Kapila wrote: > > > I don't think this is true. We seem to have introduced three new guc > > variables in a 9.3.3 minor release. > > Yeah, backporting GUCs is not a big deal. Sure, the GUC won't appear in >

Re: TIMESTAMP

2020-07-13 Thread Tom Lane
J Lumby writes: > I am curious about the syntactic nature of the expression : > TIMESTAMP '2020-07-13' > in this expression, is the token TIMESTAMP a function, typecast,  or other? > I don't see a description of it as a function and there are no > parentheses in this example. This construct is

TIMESTAMP

2020-07-13 Thread J Lumby
I am curious about the syntactic nature of the expression : TIMESTAMP '2020-07-13' in this expression,  is the token TIMESTAMP a function, typecast,  or other? I don't see a description of it as a function and there are no parentheses in this example. But this expression also doesn't seem

Re: docs: psql and variable interpolation

2020-07-13 Thread David G. Johnston
On Monday, July 13, 2020, Philippe Beaudoin wrote: > > The first sentence of this SQL interpolation chapter says "A key feature > of psql variables is that you can substitute (“interpolate”) them into > regular SQL statements, as well as the arguments of meta-commands." But > nothing in this

Re: docs: psql and variable interpolation

2020-07-13 Thread Pavel Stehule
po 13. 7. 2020 v 15:09 odesílatel Philippe Beaudoin < philippe.beaud...@dalibo.com> napsal: > Hi all, > > I recently used the nice variable capabilities in psql, after having read > the "SQL Interpolation" chapter in the psql page ( > https://www.postgresql.org/docs/12/app-psql.html). > > But I

docs: psql and variable interpolation

2020-07-13 Thread Philippe Beaudoin
Hi all, I recently used the nice variable capabilities in psql, after having read the "SQL Interpolation" chapter in the psql page (https://www.postgresql.org/docs/12/app-psql.html). But I spent a lot of time trying to understand why using a variable in a \copy command failed ... until a

Re: Additional Chapter for Tutorial

2020-07-13 Thread Daniel Gustafsson
> On 13 Jul 2020, at 14:20, Naresh gandi wrote: (please avoid top-posting) > Which version is this application for? > > I tried for v12 and v13 Beta, both failed. Unless being a bugfix, all patches are only considered against the main development branch in Git. As this is new material, it

Re: Additional Chapter for Tutorial

2020-07-13 Thread Naresh gandi
Which version is this application for? I tried for v12 and v13 Beta, both failed. Regards, Naresh G On Mon, Jul 13, 2020 at 11:45 AM Jürgen Purtz wrote: > > On 12.07.20 22:45, Daniel Gustafsson wrote: > > This patch no longer applies, due to conflicts in start.sgml, can you > please > >

Re: initdb - creating clusters

2020-07-13 Thread Daniel Gustafsson
> On 12 Jul 2020, at 00:24, Tom Lane wrote: > > Daniel Gustafsson writes: >>> On 11 Jul 2020, at 23:36, Tom Lane wrote: >>> + For example, there may be special scripts for creating a database >>> + cluster. There almost certainly will be a mechanism for starting >>> + the server, > >>

Re: Additional Chapter for Tutorial

2020-07-13 Thread Jürgen Purtz
On 12.07.20 22:45, Daniel Gustafsson wrote: This patch no longer applies, due to conflicts in start.sgml, can you please submit a rebased version? ok. but I need some days.  juergen