pgsql-sql since 2022-04-14 00:00

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next

April 14, 2022

Thread Author Time
Understanding SQL queries João Paulo Almeida 09:10

April 19, 2022

Thread Author Time
Create index on user defined type aditya desai 16:27
Re: Create index on user defined type Christophe Pettus 16:29
Re: Create index on user defined type aditya desai 17:03
Re: Create index on user defined type Rob Sargent 18:18

April 24, 2022

Thread Author Time
Re: Create index on user defined type 📎 Samed YILDIRIM 10:43

April 27, 2022

Thread Author Time
parallel-processing multiple similar query tasks - any example? Shaozhong SHI 23:33

April 28, 2022

Thread Author Time
How to use password in psql command line? Shaozhong SHI 09:10
Aw: How to use password in psql command line? Karsten Hilbert 09:38
Has anyone tried to run lots of postgres commands in parallel in this way? Shaozhong SHI 09:57
xargs psql Shaozhong SHI 11:32
AW: xargs psql Marc Mamin 13:10
Re: xargs psql Rob Sargent 13:59
Re: xargs psql Shaozhong SHI 14:05
Re: xargs psql Rob Sargent 14:53
Re: parallel-processing multiple similar query tasks - any example? Steve Midgley 17:14
Re: parallel-processing multiple similar query tasks - any example? Shaozhong SHI 17:46
Re: parallel-processing multiple similar query tasks - any example? Erik Brandsberg 18:22

April 29, 2022

Thread Author Time
Re: How to use password in psql command line? 📎 Samed YILDIRIM 07:18
Re: Has anyone tried to run lots of postgres commands in parallel in this way? 📎 Samed YILDIRIM 07:20
Re: Has anyone tried to run lots of postgres commands in parallel in this way? Erik Brandsberg 19:16

May 7, 2022

Thread Author Time
Ignore error and carry on Shaozhong SHI 10:56
Recursive query - ERROR: invalid memory alloc request size 1073741824 Shaozhong SHI 13:23
Re: Recursive query - ERROR: invalid memory alloc request size 1073741824 Rob Sargent 13:53
Re: Ignore error and carry on David G. Johnston 14:38
Re: Recursive query - ERROR: invalid memory alloc request size 1073741824 Tom Lane 15:19

May 8, 2022

Thread Author Time
Re: Recursive query - ERROR: invalid memory alloc request size 1073741824 Simon Riggs 19:15

May 10, 2022

Thread Author Time
Set timeout just on a query? Shaozhong SHI 00:58
Set timeout just on a query? Shaozhong SHI 00:59
Re: Set timeout just on a query? Christophe Pettus 01:00
Re: Set timeout just on a query? Bharath Rupireddy 03:56

May 23, 2022

Thread Author Time
Count child objects for each line of a table: LEFT JOIN, LATERAL JOIN or subqueries ? kimaidou 11:55
Re: Count child objects for each line of a table: LEFT JOIN, LATERAL JOIN or subqueries ? Frank Streitzig 13:14
Re: Count child objects for each line of a table: LEFT JOIN, LATERAL JOIN or subqueries ? kimaidou 14:15
Re: Count child objects for each line of a table: LEFT JOIN, LATERAL JOIN or subqueries ? kimaidou 14:20
Re: Count child objects for each line of a table: LEFT JOIN, LATERAL JOIN or subqueries ? kimaidou 14:22
Re: Count child objects for each line of a table: LEFT JOIN, LATERAL JOIN or subqueries ? kimaidou 14:33
Re: Count child objects for each line of a table: LEFT JOIN, LATERAL JOIN or subqueries ? Frank Streitzig 20:39

May 25, 2022

Thread Author Time
Using Transaction with if-else in prepared statement Hui Jackson 11:12
Re: Using Transaction with if-else in prepared statement Steve Midgley 18:03
Re: Using Transaction with if-else in prepared statement hubert depesz lubaczewski 23:35

May 26, 2022

Thread Author Time
Re: Using Transaction with if-else in prepared statement Hui Jackson 10:00

June 5, 2022

Thread Author Time
Strange behavior of transcations Hui Jackson 11:10
Re: Strange behavior of transcations David G. Johnston 14:29
Re: Strange behavior of transcations Erik Brandsberg 14:37

June 7, 2022

Thread Author Time
losing my mind about sytnax error in window clause Rein Petersen 23:03
Re: losing my mind about sytnax error in window clause Tom Lane 23:40
Re: losing my mind about sytnax error in window clause Rob Sargent 23:45
Re: losing my mind about sytnax error in window clause Bob Edwards 23:46

June 8, 2022

Thread Author Time
Re: losing my mind about sytnax error in window clause Rein Petersen 00:14
Re: losing my mind about sytnax error in window clause Ben Tilly 00:48
Electricity bill Theodore M Rolle, Jr. 01:39
Re: Electricity bill Jonathan Katz 01:42
Re: Electricity bill David G. Johnston 01:47
Fwd: Electricity bill Theodore M Rolle, Jr. 01:48
Re: Electricity bill Joe Conway 14:15

June 9, 2022

Thread Author Time
A function to find errors in groups in a table Shaozhong SHI 13:37
A function to find errors in groups in a table Shaozhong SHI 13:37
Re: A function to find errors in groups in a table Steve Midgley 19:16
Re: A function to find errors in groups in a table Shaozhong SHI 23:13
Re: A function to find errors in groups in a table Steve Midgley 23:25

July 23, 2022

Thread Author Time
What seed does random() use if setseed() is not called first? 📎 Carl Sopchak 21:18
Re: What seed does random() use if setseed() is not called first? Tom Lane 21:47
Re: What seed does random() use if setseed() is not called first? 📎 Carl Sopchak 21:55
Re: What seed does random() use if setseed() is not called first? Tom Lane 22:06
Re: What seed does random() use if setseed() is not called first? Carl Sopchak 22:09

Aug. 5, 2022

Thread Author Time
JDBC Driver for postgres 9.6 aditya desai 13:00
Re: JDBC Driver for postgres 9.6 Steve Midgley 13:03
Re: JDBC Driver for postgres 9.6 aditya desai 13:12
Re: JDBC Driver for postgres 9.6 Karsten Hilbert 13:15

Aug. 7, 2022

Thread Author Time
Possible bug (or at least unexpected behavior) Adam Mackler 20:06
Re: Possible bug (or at least unexpected behavior) Tom Lane 23:31

Aug. 8, 2022

Thread Author Time
select items based on 2 columns Shaozhong SHI 08:24
Re: select items based on 2 columns Frank Streitzig 09:32
Re: select items based on 2 columns Pierre Chevalier 16:17
Re: select items based on 2 columns 📎 Carl Sopchak 16:30

Aug. 9, 2022

Thread Author Time
Re: Possible bug (or at least unexpected behavior) 📎 Tom Lane 21:10
Alternative to "AT TIME ZONE" that is less of a foot-gun? John Ericson 21:31

Aug. 22, 2022

Thread Author Time
Most efficient way to select events from users having common subscriptions Brice André 06:52

Aug. 30, 2022

Thread Author Time
execution id Voillequin, Jean-Marc 16:22
Re: execution id David G. Johnston 16:26
RE: execution id Voillequin, Jean-Marc 16:32
Re: execution id hubert depesz lubaczewski 16:55

Sept. 15, 2022

Thread Author Time
ON CONFLICT clause NOT working on Partition Table PostgreSQL 12 Inzamam Shafiq 17:31
Re: ON CONFLICT clause NOT working on Partition Table PostgreSQL 12 Steve Midgley 23:09

Sept. 16, 2022

Thread Author Time
Re: ON CONFLICT clause NOT working on Partition Table PostgreSQL 12 Inzamam Shafiq 05:49
Re: ON CONFLICT clause NOT working on Partition Table PostgreSQL 12 Tom Lane 06:41
Re: ON CONFLICT clause NOT working on Partition Table PostgreSQL 12 Inzamam Shafiq 07:51

Sept. 20, 2022

Thread Author Time
Re: ON CONFLICT clause NOT working on Partition Table PostgreSQL 12 Inzamam Shafiq 09:29
Re: ON CONFLICT clause NOT working on Partition Table PostgreSQL 12 David Rowley 09:46

Sept. 22, 2022

Thread Author Time
Re: ON CONFLICT clause NOT working on Partition Table PostgreSQL 12 Geri Wright 10:39

Sept. 23, 2022

Thread Author Time
Delete from locking ordering differences Peter Hendriks 07:31
Re: Delete from locking ordering differences Rob Sargent 16:04

Sept. 29, 2022

Thread Author Time
Re: Delete from locking ordering differences Peter Hendriks 13:51
[Bug][Ver 11]: Generic query plan selected is worse than custom query plan Malay Keshav 18:33
Re: [Bug][Ver 11]: Generic query plan selected is worse than custom query plan Tom Lane 19:58

Oct. 13, 2022

Thread Author Time
Can we generate a series of tables in a loop and then use another loop to union all? Shaozhong SHI 15:44
Re: Can we generate a series of tables in a loop and then use another loop to union all? Frank Gard 16:50
How to union all tables in a schema into one whole table? Shaozhong SHI 17:02
Aw: How to union all tables in a schema into one whole table? 📎 Karsten Hilbert 17:06
Re: How to union all tables in a schema into one whole table? Frank Gard 17:17

Oct. 14, 2022

Thread Author Time
Append a list of tables to an empty table to form a whole table Shaozhong SHI 06:00
Re: Append a list of tables to an empty table to form a whole table Frank Gard 07:13
Re: Append a list of tables to an empty table to form a whole table Frank Gard 08:50

Oct. 15, 2022

Thread Author Time
How to do things like \timing on in a do loop? Shaozhong SHI 19:32
Re: How to do things like \timing on in a do loop? Erik Brandsberg 20:04

Oct. 16, 2022

Thread Author Time
Re: How to do things like \timing on in a do loop? hubert depesz lubaczewski 09:21

Oct. 24, 2022

Thread Author Time
select only 1 pair Shaozhong SHI 14:44
AW: select only 1 pair 14:51
RE: select only 1 pair Voillequin, Jean-Marc 14:59
Re: select only 1 pair William Alves Da Silva 15:01
Re: select only 1 pair Frank Streitzig 15:01
Re: select only 1 pair Thomas Kellerer 15:08
Re: select only 1 pair Steve Midgley 15:57

Oct. 31, 2022

Thread Author Time
access sub elements using any() Rob Sargent 17:04
Re: access sub elements using any() Torsten Grust 22:36
Re: access sub elements using any() Rob Sargent 22:40

Nov. 1, 2022

Thread Author Time
Re: access sub elements using any() Tom Lane 00:50

Nov. 27, 2022

Thread Author Time
[QUESTION] Window function with partition by and order by Ankit Kumar Pandey 16:08
Re: [QUESTION] Window function with partition by and order by William Alves Da Silva 16:21
Re: [QUESTION] Window function with partition by and order by Samed YILDIRIM 16:23
Re: [QUESTION] Window function with partition by and order by Tom Lane 16:28
Re: [QUESTION] Window function with partition by and order by Ankit Kumar Pandey 16:54
Re: [QUESTION] Window function with partition by and order by Ankit Kumar Pandey 16:54
Re: [QUESTION] Window function with partition by and order by Ankit Kumar Pandey 16:55

Dec. 9, 2022

Thread Author Time
Change detection Shaozhong SHI 12:55
AW: Change detection 13:02
Re: Change detection Marcos Pegoraro 13:06
Re: Change detection Shaozhong SHI 13:14
Re: Change detection Shaozhong SHI 14:15
Re: Change detection Marcos Pegoraro 17:00
Re: Change detection Shaozhong SHI 19:32
Re: Change detection Rob Sargent 19:38

Dec. 12, 2022

Thread Author Time
PARALLEL CTAS Shane Borden 16:16
Re: PARALLEL CTAS Erik Brandsberg 16:55
Re: PARALLEL CTAS Shane Borden 17:13
Re: PARALLEL CTAS Rob Sargent 17:25
Re: PARALLEL CTAS Shane Borden 17:36
Re: PARALLEL CTAS Steve Midgley 18:19
Re: PARALLEL CTAS Tom Lane 18:52
Tom changed his job role many times Shaozhong SHI 22:43

Dec. 13, 2022

Thread Author Time
Re: Tom changed his job role many times David Rowley 01:01
Re: Tom changed his job role many times Shaozhong SHI 20:33

Dec. 14, 2022

Thread Author Time
Postgresql long transaction support Kirmo Uusitalo 11:54
Re: Postgresql long transaction support Samed YILDIRIM 12:02
Re: Postgresql long transaction support Kirmo Uusitalo 12:45
Re: Postgresql long transaction support Steve Midgley 19:59
Re: Postgresql long transaction support Tom Lane 21:13

Jan. 7, 2023

Thread Author Time
Order By weirdness? 📎 Carl Sopchak 20:35
Re: Order By weirdness? Erik Brandsberg 20:38
Re: Order By weirdness? 📎 Carl Sopchak 20:45
Re: Order By weirdness? Samed YILDIRIM 21:01

Feb. 9, 2023

Thread Author Time
How to ensure a log-entry is created based on state of data in other tables Andreas Joseph Krogh 07:23
Re: How to ensure a log-entry is created based on state of data in other tables Steve Midgley 15:08
Re: How to ensure a log-entry is created based on state of data in other tables Andreas Joseph Krogh 16:33
Re: How to ensure a log-entry is created based on state of data in other tables Steve Midgley 16:37
Re: How to ensure a log-entry is created based on state of data in other tables David G. Johnston 16:44
Re: How to ensure a log-entry is created based on state of data in other tables Rob Sargent 16:44
Re: How to ensure a log-entry is created based on state of data in other tables Andreas Joseph Krogh 16:59

Feb. 23, 2023

Thread Author Time
Could not serialize access due to read/write dependencies among transactions michele curioni 21:18
Re: Could not serialize access due to read/write dependencies among transactions Tom Lane 22:10

Feb. 25, 2023

Thread Author Time
Take the data from table and rotate the member on every 7th day or starting day of the week and continue for whole week continue till the date range nikhil raj 20:35
Take the data from table and rotate the member on every 7th day or starting day of the week and continue for whole week continue till the date range. nikhil raj 21:04
Re: Take the data from table and rotate the member on every 7th day or starting day of the week and continue for whole week continue till the date range Steve Midgley 21:56

Feb. 27, 2023

Thread Author Time
Re: Take the data from table and rotate the member on every 7th day or starting day of the week and continue for whole week continue till the date range nikhil raj 19:45

April 11, 2023

Thread Author Time
Looking for an efficient way to replace efficient NOT IN when landling very large data Shaozhong SHI 09:27
Re: Looking for an efficient way to replace efficient NOT IN when landling very large data David Rowley 09:33
Re: Looking for an efficient way to replace efficient NOT IN when landling very large data Shaozhong SHI 09:44

April 20, 2023

Thread Author Time
PostgreSQL Objects design kunwar singh 16:01
Re: PostgreSQL Objects design Steve Midgley 16:25
PostgreSQL Objects design Wetmore, Matthew (CTR) 18:40

June 22, 2023

Thread Author Time
Strange update behaviour ProfiVPS Support 21:49
Re: Strange update behaviour Tom Lane 22:11
Re: Strange update behaviour ProfiVPS Support 23:07

June 23, 2023

Thread Author Time
Re: Strange update behaviour Tom Lane 01:56
Re: Strange update behaviour ProfiVPS Support 06:56

June 26, 2023

Thread Author Time
Window functions: frame-adhering aggregate without ORDER BY clause Romain Carl 11:44
Re: Window functions: frame-adhering aggregate without ORDER BY clause Tom Lane 13:54
Re: Window functions: frame-adhering aggregate without ORDER BY clause Romain Carl 15:14
Re: Window functions: frame-adhering aggregate without ORDER BY clause Erik Brandsberg 16:21

July 4, 2023

Thread Author Time
How come column is locked? Shaozhong SHI 14:34
Re: How come column is locked? William Alves Da Silva 14:40
Re: How come column is locked? Thomas Kellerer 14:43
Re: How come column is locked? Tom Lane 14:47
Working around insert into a_table from select things from a_function Shaozhong SHI 16:58
Aw: Working around insert into a_table from select things from a_function Karsten Hilbert 17:09
Re: How come column is locked? Thomas Kellerer 18:39
Re: How come column is locked? Rob Sargent 23:27
Re: Working around insert into a_table from select things from a_function Rob Sargent 23:28

July 6, 2023

Thread Author Time
How to select the last value/row? Shaozhong SHI 15:46
Re: How to select the last value/row? David G. Johnston 15:51
Re: How to select the last value/row? Shaozhong SHI 16:02
Re: How to select the last value/row? David G. Johnston 16:09
Re: How to select the last value/row? Tom Lane 16:12
How do Exception, do nothing and carry on Shaozhong SHI 21:47
Re: How do Exception, do nothing and carry on David G. Johnston 21:54

July 8, 2023

Thread Author Time
How to remove duplicates in an array and maintain the order? Shaozhong SHI 15:30
Re: How to remove duplicates in an array and maintain the order? David G. Johnston 15:36
Re: How to remove duplicates in an array and maintain the order? Marcos Pegoraro 15:50
Re: How to remove duplicates in an array and maintain the order? Thomas Kellerer 16:19

Browse Archives

Prev | Next