Re: Problem with CAST-ing - am I missing something?

On 10/25/23 17:26, Christophe Pettus wrote: On Oct 25, 2023, at 17:21, Pól Ua Laoínecháin wrote: SELECT (ts, te)::TSTZRANGE FROM test; That syntax doesn't mean what you probably think it does. (ts, te) defines a record type with two fields. PostgreSQL constructs that, and then attempts

Re: Problem with CAST-ing - am I missing something?

> On Oct 25, 2023, at 17:21, Pól Ua Laoínecháin wrote: > > SELECT (ts, te)::TSTZRANGE FROM test; That syntax doesn't mean what you probably think it does. (ts, te) defines a record type with two fields. PostgreSQL constructs that, and then attempts to apply the cast. There's no conversio

Re: Problem with CAST-ing - am I missing something?

Sorry folks - fiddle is here: https://dbfiddle.uk/bT4idNK6 Rgs, Pól...

Re: setting up streaming replication, part 2

Hi, Le mer. 25 oct. 2023 à 02:29, Brad White a écrit : > I have the replication server set up and the streaming is working. > The latest data show up, as desired. > > 3 minor issues. > > 1) I also have the WAL files being copied to a common location from the > primary server with > archive

Re: purpose of an entry in pg_hba.conf file

On Wed, Oct 25, 2023 at 5:11 PM Atul Kumar wrote: > Hi, > > As you know already, pg_hba.conf file always has the below entry after > successful installation of postgres. > > hostall all 127.0.0.1/32trust > > > Please let me know what is the exact purpose o

Problem with CAST-ing - am I missing something?

Hi all, One of the things I really like about PostgreSQL is that it normally does what I expect it to do - very little cognitive dissonance. But I'm puzzled by something I came across this evening - took me ages to figure it out! I have a table (sample) as follows (code on fiddle:): CREATE TABLE

purpose of an entry in pg_hba.conf file

Hi, As you know already, pg_hba.conf file always has the below entry after successful installation of postgres. hostall all 127.0.0.1/32trust Please let me know what is the exact purpose of this entry and what would be the impact of removing it on other

Re: REINDEX in tables

On Wed, Oct 25, 2023 at 11:33:11AM +0200, Andreas Kretschmer wrote: > Am 25.10.23 um 11:24 schrieb Matthias Apitz: >> We have a client who run REINDEX in certain tables of the database of >> our application (on Linux with PostgreSQL 13.x): >> >> REINDEX TABLE CONCURRENTLY d83last; >> REINDEX TABLE

Re: Question about the new PostgreSQL 16 availability on Ubuntu

Thank you :) I have found the same link and responded to the last email with it :) Thank you so very much :) Kind regards On Wed, 25 Oct 2023 at 18:50, Adrian Klaver wrote: > On 10/25/23 04:04, Momchil Milev wrote: > > Hello, > > > > I am trying to install PostgreSQL 16 on Ubuntu 18 and added

Re: setting up streaming replication, part 2

From: Ron Sent: Wednesday, October 25, 2023 4:35:59 AM To: pgsql-generallists.postgresql.org Subject: Re: setting up streaming replication, part 2 On 10/24/23 23:47, Brad White wrote: On Tue, Oct 24, 2023, 9:02 PM Ron mailto:ronljohnso...@gmail.com>> wrote: On 10/24/23 19:29, Brad White wrote:

Re: Very newbie question

Hi, El mié, 25 oct 2023 16:58, Олег Самойлов escribió: > Okey, I see no one was be able to solve this problem. But I could. May be > for someone this will be useful too. There is solution. > > Original query was: > > > 23 окт. 2023 г., в 18:13, Олег Самойлов написал(а): > > > > SELECT id/10

Re: Question about the new PostgreSQL 16 availability on Ubuntu

On 10/25/23 04:04, Momchil Milev wrote: Hello, I am trying to install PostgreSQL 16 on Ubuntu 18 and added your repository *deb https://apt.postgresql.org/pub/repos/apt bionic-pgdg main* but it seems that version 16 is not available. Tle latest avail

Re: Question about the new PostgreSQL 16 availability on Ubuntu

On 25/10/2023 16:47, John W Higgins wrote: As to the wiki (and/or any other references), small number of people, doing way too many things - some stuff doesn't get updated as quickly as one would like. ...not to mention that they are volunteers, doing it gratis in their own limited free time,

Re: Question about the new PostgreSQL 16 availability on Ubuntu

On Wed, Oct 25, 2023 at 8:36 AM Momchil Milev wrote: > Hello, > > I am trying to install PostgreSQL 16 on Ubuntu 18 and added your > repository *deb https://apt.postgresql.org/pub/repos/apt > bionic-pgdg main* but it seems > that version 16 is not availa

Question about the new PostgreSQL 16 availability on Ubuntu

Hello, I am trying to install PostgreSQL 16 on Ubuntu 18 and added your repository *deb https://apt.postgresql.org/pub/repos/apt bionic-pgdg main* but it seems that version 16 is not available. Tle latest available version is 15. Is there some problem wit

Re: Very newbie question

Okey, I see no one was be able to solve this problem. But I could. May be for someone this will be useful too. There is solution. Original query was: > 23 окт. 2023 г., в 18:13, Олег Самойлов написал(а): > > SELECT id/1000 as partition > FROM delivery > GROUP BY partition > HAVING ma

Re: REINDEX in tables

On Wed, Oct 25, 2023 at 02:14:49PM +0200, Andreas Kretschmer wrote: > Am 25.10.23 um 14:11 schrieb Laurenz Albe: > > On Wed, 2023-10-25 at 11:59 +0200, Andreas Kretschmer wrote: > > > Am 25.10.23 um 11:57 schrieb Matthias Apitz: > > > > El día miércoles, octubre 25, 2023 a las 11:33:11 +0200, Andre

Re: REINDEX in tables

Am 25.10.23 um 14:11 schrieb Laurenz Albe: On Wed, 2023-10-25 at 11:59 +0200, Andreas Kretschmer wrote: Am 25.10.23 um 11:57 schrieb Matthias Apitz: El día miércoles, octubre 25, 2023 a las 11:33:11 +0200, Andreas Kretschmer escribió: Am 25.10.23 um 11:24 schrieb Matthias Apitz: We have a

Re: REINDEX in tables

On Wed, 2023-10-25 at 11:59 +0200, Andreas Kretschmer wrote: > Am 25.10.23 um 11:57 schrieb Matthias Apitz: > > El día miércoles, octubre 25, 2023 a las 11:33:11 +0200, Andreas Kretschmer > > escribió: > > > Am 25.10.23 um 11:24 schrieb Matthias Apitz: > > > > We have a client who run REINDEX in c

Re: REINDEX in tables

Am 25.10.23 um 11:57 schrieb Matthias Apitz: El día miércoles, octubre 25, 2023 a las 11:33:11 +0200, Andreas Kretschmer escribió: Am 25.10.23 um 11:24 schrieb Matthias Apitz: We have a client who run REINDEX in certain tables of the database of our application (on Linux with PostgreSQL 13

Re: REINDEX in tables

El día miércoles, octubre 25, 2023 a las 11:33:11 +0200, Andreas Kretschmer escribió: > Am 25.10.23 um 11:24 schrieb Matthias Apitz: > > We have a client who run REINDEX in certain tables of the database of > > our application (on Linux with PostgreSQL 13.x): > > > > REINDEX TABLE CONCURRENTLY d

Re: setting up streaming replication, part 2

On 10/24/23 23:47, Brad White wrote: On Tue, Oct 24, 2023, 9:02 PM Ron wrote: On 10/24/23 19:29, Brad White wrote: > I have the replication server set up and the streaming is working. > The latest data show up, as desired. > > 3 minor issues. > > 2) I have the conn

Re: REINDEX in tables

Am 25.10.23 um 11:24 schrieb Matthias Apitz: We have a client who run REINDEX in certain tables of the database of our application (on Linux with PostgreSQL 13.x): REINDEX TABLE CONCURRENTLY d83last; REINDEX TABLE CONCURRENTLY d86plz; REINDEX TABLE CONCURRENTLY ig_memtable; REINDEX TABLE CONC

REINDEX in tables

We have a client who run REINDEX in certain tables of the database of our application (on Linux with PostgreSQL 13.x): REINDEX TABLE CONCURRENTLY d83last; REINDEX TABLE CONCURRENTLY d86plz; REINDEX TABLE CONCURRENTLY ig_memtable; REINDEX TABLE CONCURRENTLY ig_dictionary; REINDEX TABLE CONCURRENTLY

Re: PostgreSQL C++ Interface version 14.9 using static library instead of shared library

Hi, maybe you're not compiling with ssl enabled (using --with-openssl) ? regards, Giovanni Il giorno ven 20 ott 2023 alle ore 12:58 M Tarkeshwar Rao < m.tarkeshwar@ericsson.com> ha scritto: > Hi > > While compiling PostgreSQL C++ Interface version 14.9 . Found that > libpq.so is getting cre