No, the result will be ordered by the window functions order clause so no
additional ordering is nessesary.
You can try this by changing it to OVER(ORDER BY product_name)
KR
Mikael
Från: Durumdara
Skickat: den 10 mars 2023 08:41:06
Till: Gustavsson Mikael
Hi,
Is it something like row_number() you want?
https://www.postgresql.org/docs/current/functions-window.html
KR
Mikael
Från: Durumdara
Skickat: den 10 mars 2023 8:12
Till: Postgres General
Ämne: Onfly, function generated ID for Select Query
Dear Members!
I'm
Hi,
idle_in_transaction_session_timeout came in PG 9.6 if im not mistaken.
KR
Mikael
Från: Atul Kumar
Skickat: den 7 maj 2021 8:34
Till: pgsql-general
Ämne: idle_in_transaction_session_timeout
Hi,
I have postgres 9.5 version running on my machine.
When I am
__
Från: externaly-forwar...@smhi.se för Gustavsson
Mikael
Skickat: den 22 december 2020 09:07:17
Till: Tom Lane
Kopia: Magnus Hagander; Kyotaro Horiguchi; pgsql-gene...@postgresql.org;
Svensson Peter
Ämne: SV: SV: SV: SV: Problem with ssl and psql in Postgresql 13
Hi,
Yes it´
Jul as we say in Sweden.
KR
Mikael Gustavsson, SMHI
Från: Tom Lane
Skickat: den 18 december 2020 21:02:50
Till: Gustavsson Mikael
Kopia: Magnus Hagander; Kyotaro Horiguchi; pgsql-gene...@postgresql.org;
Svensson Peter
Ämne: Re: SV: SV: SV: Problem with ssl and
ver11
Password for user kalle:
psql (13.1, server 11.10)
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256,
compression: off)
Type "help" for help.
postgres=>
KR Mikael Gustavsson, SMHI
________
Från: externaly-forwar...@smhi.se
.so.3 (0x7f8840de3000)
/lib64/ld-linux-x86-64.so.2 (0x7f88437b6000)
libselinux.so.1 => /lib64/libselinux.so.1 (0x7f8840bb9000)
libcrypt.so.1 => /lib64/libcrypt.so.1 (0x7f884099)
libpcre2-8.so.0 => /lib64/libpcre2-8.so.0 (0x7f884070c000)
/Mikael
_
conf entry for host "nn.nnn.n.nnn", user "kalle", database
"postgres", SSL off
/Mikael
____
Från: Magnus Hagander
Skickat: den 17 december 2020 17:03:18
Till: Gustavsson Mikael
Kopia: Tom Lane; Kyotaro Horiguchi; pgsql-gene...@pos
alle", database "postgres", SSL off
FATAL: no pg_hba.conf entry for host "nn.nnn.n.nnn", user "kalle", database
"postgres", SSL off
KR Mikael Gustavsson, SMHI
Från: Magnus Hagander
Skickat: den 17 december 2020 15:52:5
gres", SSL off
KR
Mikael Gustavsson, SMHI
Från: Tom Lane
Skickat: den 17 december 2020 15:20:01
Till: Gustavsson Mikael
Kopia: Kyotaro Horiguchi; pgsql-gene...@postgresql.org; Svensson Peter
Ämne: Re: SV: Problem with ssl and psql in Postgresql 13
Gustavsson Mikael
different
psql-clients.
KR
Från: Kyotaro Horiguchi
Skickat: den 17 december 2020 09:29:38
Till: Gustavsson Mikael
Kopia: pgsql-gene...@postgresql.org; Svensson Peter
Ämne: Re: Problem with ssl and psql in Postgresql 13
Hi.
At Thu, 17 Dec 2020 07:21:08 +, Gustavsson Mikael
w
Hi,
I have used this setup to do something similar.
https://github.com/2ndQuadrant/audit-trigger
KR, Mikael Gustavsson
Från: Ayub M
Skickat: den 15 december 2020 18:13:39
Till: PostgreSQL General
Ämne: postgres auditing truncates and deletes on tables
for
Hi,
We are starting our journey to migrate from Postgresql 11 to Postgresql 13 and
have run into a problem.
The postgresql 13 version of psql don´t seem to work with ssl.
We use the community built rpms on redhat 8.3:
$ rpm -q postgresql11
postgresql11-11.10-1PGDG.rhel8.x86_64
$ rpm -q postgres
Clarification, we upgraded from PG 11.9 to PG 11.10.
KR Mikael Gustavsson
Från: externaly-forwar...@smhi.se för Gustavsson
Mikael
Skickat: den 27 november 2020 16:24:38
Till: Tom Lane
Kopia: pgsql-generallists.postgresql.org; Svensson Peter; Almen Anders
Ämne
Hi.
We installed PG 11.10 last week. So the latest release of PG 11.
KR
Mikael Gustavsson
Från: Tom Lane
Skickat: den 27 november 2020 16:21:33
Till: Gustavsson Mikael
Kopia: pgsql-generallists.postgresql.org; Svensson Peter; Almen Anders
Ämne: Re: Problem
()
;
pg_notification_queue_usage
-
0.245367050170898
(1 row)
If my calculations is correct we will reach 50% on monday.
kr
/Mikael Gustavsson
Från: David G. Johnston
Skickat: den 27 november 2020 15:28
Till: Gustavsson Mikael
Kopia: pgsql
Hi.
After applying the latest patch we have encountered a problem with the
pg_notify queue.
The queue is filling up and starts issuing warnings like
WARNING: NOTIFY queue is 87% full
DETAIL: The server process with PID 2969993 is among those with the oldest
transactions.
NOTIFY queue cannot b
Here is one without syntax error.
select generate_series(1,(select max(id) from theserecords))
EXCEPT
select id from theserecords;
Från: Gustavsson Mikael [mikael.gustavs...@smhi.se]
Skickat: den 22 maj 2019 15:51
Till: Durumdara; Postgres General
Ämne: SV: Which
Hi,
You can use generate_series.
select generate_series(1,select max(id) from theserecords)
EXCEPT
select id from theserecords;
KR
Från: Durumdara [durumd...@gmail.com]
Skickat: den 22 maj 2019 15:43
Till: Postgres General
Ämne: Which records aren't in list? Use
Thanks for fast reply!
I'll forward the answer to my developers.
kr
Mikael Gustavsson
Från: Tom Lane [t...@sss.pgh.pa.us]
Skickat: den 20 mars 2019 17:33
Till: Gustavsson Mikael
Kopia: pgsql-general@lists.postgresql.org
Ämne: Re: to_timestamp fun
Hi,
We recently upgraded from PG9.6 to PG11 and I have some questions regarding the
function to_timestamp.
We have an application that for some reason unknown to me uses timestamps with
hour = 24.
After upgrade we got som problems with this. The solution is to use cast
instead of the function
>From documentation:
"REFRESH MATERIALIZED VIEW completely replaces the contents of a materialized
view. To execute this command you must be the owner of the materialized view."
So it is intended behavior.
https://www.postgresql.org/docs/11/sql-refreshmaterializedview.html
___
KR /Mikael
Från: Achilleas Mantzios [ach...@matrix.gatewaynet.com]
Skickat: den 18 februari 2019 12:31
Till: pgsql-general@lists.postgresql.org
Ämne: Re: Slony and triggers on slavenodes.
On 18/2/19 1:09 μ.μ., Gustavsson Mikael wrote:
Hi,
I have a Postgresql 11 and Slony 2
Hi,
I have a Postgresql 11 and Slony 2.2.7 setup with one master and multiple slave
nodes. On one of the slaves I want a user defined trigger to fire on insert.
The trigger fires a notify function.
Now to the problem.
If I create the trigger it looks like it is enabled on the slave but it do n
24 matches
Mail list logo
