Reply to list also.
Ccing list.
On 2/1/24 09:11, Johnathan Tiamoh wrote:
No. I have done any of this in the present cluster, I'm facing this issue.
Do you have some sort of replication or backup system running on this
cluster?
--
Adrian Klaver
adrian.kla...@aklaver.com
On 2/1/24 06:10, Johnathan Tiamoh wrote:
I haven't had difficulties in this cluster recently.
However I upgraded it from version 9.5 to 14.10 about 3 weeks ago.
Have you being doing any of the things that got you in trouble in this
thread:
https://www.postgresql.org/message-id/CACoPQdbEo
I haven't had difficulties in this cluster recently.
However I upgraded it from version 9.5 to 14.10 about 3 weeks ago.
On Thu, Feb 1, 2024 at 9:06 AM Jehan-Guillaume de Rorthais
wrote:
> On Thu, 1 Feb 2024 08:28:45 -0500
> Johnathan Tiamoh wrote:
>
> > Thank you Laurenz!
> >
> > Is there
On Thu, 1 Feb 2024 08:28:45 -0500
Johnathan Tiamoh wrote:
> Thank you Laurenz!
>
> Is there a way of preventing this from happening ?
This could either come from a hardware issue, or easily from your own actions
or procedures.
Did you have some difficulties with your instance lately? exception
Thank you Laurenz!
Is there a way of preventing this from happening ?
On Thu, Feb 1, 2024 at 2:36 AM Laurenz Albe
wrote:
> On Thu, 2024-02-01 at 00:48 -0500, Johnathan Tiamoh wrote:
> > I am having the following issue below. Please, I need help to fix it.
> >
> > ERROR: could not access stat
On Thu, 2024-02-01 at 00:48 -0500, Johnathan Tiamoh wrote:
> I am having the following issue below. Please, I need help to fix it.
>
> ERROR: could not access status of transaction 756525298
> Could not open file "pg_xact/02C8": No such file or directory.
That is data corruption, and you shoul
## m...@ft-c.de (m...@ft-c.de):
> /usr/local/bin/postgres -V
> ld-elf.so.1: Shared object "libicui18n.so.70" not found, required by
> "postgres"
You screwd up your upgrades: that postgres binary was built against
ICU 70, but as hou have shown you have ICU 71 installed:
> find / -name "*libicui*"
On Fri, 2022-07-08 at 12:47 +0200, m...@ft-c.de wrote:
> there is a postgresql bug
An error need not be a bug.
> /usr/local/bin/postgres -V
> ld-elf.so.1: Shared object "libicui18n.so.70" not found, required by
> "postgres"
>
> Installed Version:
> postgresql14-server-14.1
>
> find / -name "*li
On Wed, 23 Mar 2022 at 04:03, PALAYRET Jacques
wrote:
> For example, in Oracle it is not possible to have a SELECT statement without
> a FROM clause (using DUAL table), so maybe " ambiguous " columns are not
> handled in the same way.
But if your original complaint, the column was not ambiguous
;PostgreSQL mailing lists"
Envoyé: Mardi 22 Mars 2022 14:04:32
Objet: Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or
Subqueries in the FROM Clause
On Tuesday, March 22, 2022, PALAYRET Jacques < [
mailto:jacques.palay...@meteo.fr | jacques.palay...@meteo.fr ] > wr
On Tuesday, March 22, 2022, PALAYRET Jacques
wrote:
>
> According to me, there is only one condition in the main statement (SELECT
> w.id, w.name, w.elev FROM weather_stations ...)
> and it is : elev > 151 (correlation ou not correlation).
> In others words : for each line of table weather_statio
nks again.
Regards
De: "Torsten Förtsch"
À: "PALAYRET Jacques"
Cc: "PostgreSQL mailing lists"
Envoyé: Mardi 22 Mars 2022 11:16:19
Objet: Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or
Subqueries in the FROM Clause
This is what happens:
WITH ele
On Tuesday, March 22, 2022, Torsten Förtsch wrote:
>
>
> Note the use of aliases, w and x. You are using a correlated subquery.
>
Yep. There is an FAQ entry if you’d like a bit more exposition.
https://wiki.postgresql.org/wiki/FAQ#Why_doesn.27t_PostgreSQL_report_a_column_not_found_error_when_us
Hi,
Le mar. 22 mars 2022 à 10:46, PALAYRET Jacques
a écrit :
> Hello,
>
> # Let's consider a table defined as follows :
> CREATE TABLE weather_stations(
> id integer,
> name varchar(30),
> elev integer
> ) ;
>
> # After loading, the content :
> id| name | elev
> -
This is what happens:
WITH elev_Tlse_Blagnac AS (
SELECT elev FROM weather_stations WHERE id=31069001
)
SELECT w.id, w.name, w.elev
FROM weather_stations AS w
WHERE elev > (SELECT x.elev
FROM elev_Tlse_Blagnac AS x
WHERE w.id BETWEEN 3100 and 3199);
id
15 matches
Mail list logo
