Hello,
for a partitioned table, it should be mentioned in the documentation that
currently the drop will also silently
drop all the partitions underneath.
By the way, it's a pity that "cascade" is not considered to be used in such a
case.
Regards
Gilles
igate what choices they have for backup tools.
Regards
Gilles
- Mail original -
> De: "Stephen Frost"
> À: "gparc"
> Cc: "gparc" , "pgsql-docs"
> Envoyé: Jeudi 8 Février 2024 22:54:29
> Objet: Re: Add a different archive_comman
Thanks Stephen for your detailed reply and broad perspective.
But I see the cp example command used **as is** most of the time.
Regards
Gilles
- Mail original -
> De: "Stephen Frost"
> À: "gparc" , "pgsql-docs"
> Envoyé: Jeudi 8 Février 202
leges
(ie. grant all on database)
to the old owner...and that's what i forgot to do.
So no problem at all and documentation is OK.
Sorry for the noise !
Best regards
Gilles
De: "gparc"
À: "David G. Johnston"
Cc: "Laurenz Albe" , "Daniel Gust
De: "David G. Johnston"
À: "gparc"
Cc: "Laurenz Albe" , "Daniel Gustafsson"
, "pgsql-docs"
Envoyé: Mercredi 24 Janvier 2024 17:50:17
Objet: Re: SQL command : ALTER DATABASE OWNER TO
On Wed, Jan 24, 2024 at 9:23 AM < [ mailto:gp.
De: "David G. Johnston"
À: "Laurenz Albe"
Cc: "gparc" , "Daniel Gustafsson" ,
"pgsql-docs"
Envoyé: Mercredi 24 Janvier 2024 17:36:43
Objet: Re: SQL command : ALTER DATABASE OWNER TO
On Wed, Jan 24, 2024 at 9:13 AM Laurenz Alb
- Mail original -
De: "Laurenz Albe"
À: "gparc" , "Daniel Gustafsson"
Cc: "pgsql-docs"
Envoyé: Mercredi 24 Janvier 2024 16:35:10
Objet: Re: SQL command : ALTER DATABASE OWNER TO
On Wed, 2024-01-24 at 15:40 +0100, gp...@free.fr wrote:
> ma
ginal -
De: "Daniel Gustafsson"
À: "Laurenz Albe"
Cc: "gparc" , "pgsql-docs"
Envoyé: Mercredi 24 Janvier 2024 15:26:22
Objet: Re: SQL command : ALTER DATABASE OWNER TO
> On 24 Jan 2024, at 15:23, Laurenz Albe wrote:
>
> On Wed, 2024-01-24 a
Hello,
as one of my colleagues fell into the same trap
I repeat my request for correction of the documentation on this subject.
Many thanks in advance
Regards
Gilles
- Mail original -
De: "gparc"
À: "pgsql-docs"
Envoyé: Mardi 8 Mars 2022 10:50:38
Objet: SQL comm
Hello,
for this "ALTER DATABASE" form, it should be mentioned that after execution of
the command,
the old database owner loses all his privileges on it (even connection)
although it might
still owns schemas or objects (tables, index,...) inside it.
Thanks in advance to add this important pre
10 matches
Mail list logo