On 2023-10-14 00:01 +0200, David G. Johnston write:
> On Fri, Oct 13, 2023 at 2:53 PM Greig Wise wrote:
>
> > Hello. I have run into an issue when using the copy command on tables
> > with json columns where Postgres seems to improperly escape backslashes
> > under certain conditions thus creati
On Fri, Oct 13, 2023 at 01:39:17PM +0200, Luca Ferrari wrote:
> at least, as it is shown by `psql -E`.
> I wonder why this information has been removed, I'm not able to find
> this in the documentation.
Release notes show:
https://why-upgrade.depesz.com/show?from=15.4&to=16&keywords=%5Cdu
> Add
Greig Wise writes:
> Hello. I have run into an issue when using the copy command on tables
> with json columns where Postgres seems to improperly escape backslashes
> under certain conditions thus creating invalid JSON.
AFAICS this is COPY's normal behavior: it doubles backslashes in
the default
On Fri, Oct 13, 2023 at 2:53 PM Greig Wise wrote:
> Hello. I have run into an issue when using the copy command on tables
> with json columns where Postgres seems to improperly escape backslashes
> under certain conditions thus creating invalid JSON. Here is an example I
> have of the behavior:
Hello. I have run into an issue when using the copy command on tables with
json columns where Postgres seems to improperly escape backslashes under
certain conditions thus creating invalid JSON. Here is an example I have of
the behavior:
create table test_json(json_data json);
insert into tes
Hi,
On 13.10.2023 16:06, Ian Lawrence Barwick wrote:
2023年10月13日(金) 20:47 Luca Ferrari :
Hi all,
in version 16 psql does not show anymore the "member of" group
information when showing users with \du.
FWIW the explanation is in commit 0a1d2a7df8:
https://git.postgresql.org/gitweb/?p=pos
--- Original Message ---
On Friday, October 13th, 2023 at 14:10, Jehan-Guillaume de Rorthais
wrote:
> But really, double check first why a simple primary-standby architecture
> doesn't
> meet your needs. The simpler the architecture is, the better. Even from the
> application point of
Ian Lawrence Barwick writes:
> and also noted in the release notes:
>
> https://www.postgresql.org/docs/16/release-16.html#RELEASE-16-PSQL
FWIW, I noticed a small typo in the relevant entry: s/informaion/information/
ciao, lele.
--
nickname: Lele Gaifax | Dire che Emacs è "conveniente" è com
For the same reason that you can use python or perl in postgresql. It's just
another language.
I have .net code running on several sql servers and to change the database to
postgresql I have to reprogram them.
On Thursday, October 12, 2023 at 09:44:08 AM GMT-4, Laurenz Albe
wrote:
On Thu, 2
On Fri, Oct 13, 2023 at 3:04 PM hubert depesz lubaczewski
wrote:
>
> On Fri, Oct 13, 2023 at 01:39:17PM +0200, Luca Ferrari wrote:
> > at least, as it is shown by `psql -E`.
> > I wonder why this information has been removed, I'm not able to find
> > this in the documentation.
>
> Release notes sh
On Fri, 13 Oct 2023 12:02:53 +
Jason Grammenos wrote:
> Thank you for the feedback,
>
> I have used pacemaker for other purposes previously so am a little familiar
> with it.
So you might be familiar with shared-storage cluster, that are the simpler one
you could deploy (baring you have a
2023年10月13日(金) 20:47 Luca Ferrari :
>
> Hi all,
> in version 16 psql does not show anymore the "member of" group
> information when showing users with \du.
>
> The query (still working fine) in previous versions was:
>
> SELECT r.rolname, r.rolsuper, r.rolinherit,
> r.rolcreaterole, r.rolcreatedb,
Thank you for the feedback,
I have used pacemaker for other purposes previously so am a little familiar
with it. It appears that in this scenario pacemaker is being used to manage a
floating ip as well as deal with split brain scenarios. What isn’t clear is how
effective master-> master replica
Hi all,
in version 16 psql does not show anymore the "member of" group
information when showing users with \du.
The query (still working fine) in previous versions was:
SELECT r.rolname, r.rolsuper, r.rolinherit,
r.rolcreaterole, r.rolcreatedb, r.rolcanlogin,
r.rolconnlimit, r.rolvaliduntil,
A
14 matches
Mail list logo
