pgsql-sql since 2022-02-20 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

Feb. 20, 2022

Thread Author Time
Re: Turn a json column into a table David G. Johnston 00:18
Re: Turn a json column into a table Shaozhong SHI 00:58
Re: Turn a json column into a table David G. Johnston 01:08
Re: Turn a json column into a table Shaozhong SHI 03:31
Aw: Re: Turn a json column into a table Karsten Hilbert 09:07

Feb. 21, 2022

Thread Author Time
automatic scan a table, report on data formats in columns Shaozhong SHI 10:06
Re: automatic scan a table, report on data formats in columns Jian He 12:45
Re: automatic scan a table, report on data formats in columns David G. Johnston 16:27
Re: automatic scan a table, report on data formats in columns Steve Midgley 16:59
Re: automatic scan a table, report on data formats in columns Shaozhong SHI 19:54

Feb. 23, 2022

Thread Author Time
PSQL: "\set ECHO all" doesn't work with "\o" Alberto Benini 18:18
Re: PSQL: "\set ECHO all" doesn't work with "\o" David G. Johnston 18:27

Feb. 27, 2022

Thread Author Time
Is there any function for calculating angle between 2 line segments in 3D? Shaozhong SHI 10:39
Array_reverse Shaozhong SHI 16:53
Re: Array_reverse Pavel Stehule 16:59

March 1, 2022

Thread Author Time
NORM(NO ORM) transform two one-many relationships into a single json. 📎 Jian He 13:58
Global setting for ORDER BY ... NULLS FIRST / LAST Sebastien Flaesch 14:16
Re: Global setting for ORDER BY ... NULLS FIRST / LAST David G. Johnston 14:41
Re: Global setting for ORDER BY ... NULLS FIRST / LAST Tom Lane 15:02
pg_stat_progress_copy not working as intended asalias mark 17:55

March 2, 2022

Thread Author Time
Re: pg_stat_progress_copy not working as intended Ian Lawrence Barwick 00:17
Re: pg_stat_progress_copy not working as intended asalias mark 09:48
Re: Global setting for ORDER BY ... NULLS FIRST / LAST Sebastien Flaesch 12:23

March 3, 2022

Thread Author Time
Bug in tables column data in postgres database Sarita Sharma 16:45
AW: Bug in tables column data in postgres database 17:10
Re: Bug in tables column data in postgres database Christophe Pettus 17:18
Re: Bug in tables column data in postgres database 📎 MichaelDBA Vitale 17:24
RE: Bug in tables column data in postgres database Voillequin, Jean-Marc 18:06
Re: Bug in tables column data in postgres database Sarita Sharma 18:41
Re: Bug in tables column data in postgres database Rob Sargent 19:24
Re: Bug in tables column data in postgres database David G. Johnston 19:27
Re: Bug in tables column data in postgres database Steve Midgley 20:03

March 4, 2022

Thread Author Time
Re: Bug in tables column data in postgres database Sarita Sharma 14:04
Re: Bug in tables column data in postgres database Erik Brandsberg 14:33
Re: Bug in tables column data in postgres database Tom Lane 14:43
Re: Bug in tables column data in postgres database Steve Midgley 14:52
unique index with several columns Voillequin, Jean-Marc 15:06
limits on the number of concurrent DBMS sessions per account Kevin Tu 15:07
RE: unique index with several columns Voillequin, Jean-Marc 15:09
Re: limits on the number of concurrent DBMS sessions per account Tom Lane 15:11
Re: limits on the number of concurrent DBMS sessions per account Kevin Tu 15:29
Re: unique index with several columns David G. Johnston 15:32
AW: unique index with several columns Marc Mamin 15:32
RE: unique index with several columns Voillequin, Jean-Marc 16:11
Re: unique index with several columns Alexey M Boltenkov 18:26
Re: unique index with several columns Tom Lane 18:32
RE: unique index with several columns Klaus Kaisersberger 18:57
Re: unique index with several columns David G. Johnston 19:06
RE: unique index with several columns Klaus Kaisersberger 19:18
RE: unique index with several columns Klaus Kaisersberger 20:02
Re: unique index with several columns Alexey M Boltenkov 20:47

March 5, 2022

Thread Author Time
Re: Bug in tables column data in postgres database Sarita Sharma 08:04
Re: Bug in tables column data in postgres database David G. Johnston 08:15
Re: Bug in tables column data in postgres database Sarita Sharma 08:29
Re: Bug in tables column data in postgres database Thomas Kellerer 08:40
Re: Bug in tables column data in postgres database David G. Johnston 08:51
Re: Bug in tables column data in postgres database mgbii bax 10:10
Re: Bug in tables column data in postgres database Sarita Sharma 10:28
Re: Bug in tables column data in postgres database David G. Johnston 15:27
Re: Bug in tables column data in postgres database Sarita Sharma 15:56
Re: Bug in tables column data in postgres database David G. Johnston 16:07

March 6, 2022

Thread Author Time
Re: Bug in tables column data in postgres database Sándor Daku 10:08
Re: Bug in tables column data in postgres database [email protected] 12:23
Re: Bug in tables column data in postgres database Sarita Sharma 13:49

March 7, 2022

Thread Author Time
ERROR: extra data after last expected column Scott Macri 01:59
Re: ERROR: extra data after last expected column Sándor Daku 09:08
Re: ERROR: extra data after last expected column Rob Sargent 09:57
Best practice for naming temp table trigger functions Sebastien Flaesch 18:19
Re: ERROR: extra data after last expected column scott macri 23:33
Re: ERROR: extra data after last expected column Steve Midgley 23:54
Re: ERROR: extra data after last expected column Steve Midgley 23:56
Re: ERROR: extra data after last expected column Rob Sargent 23:57

March 8, 2022

Thread Author Time
Re: ERROR: extra data after last expected column Scott Macri 01:40
Re: ERROR: extra data after last expected column Ron 01:42
Re: ERROR: extra data after last expected column Scott Macri 01:51
Re: ERROR: extra data after last expected column Rob Sargent 02:40
Re: ERROR: extra data after last expected column scott macri 03:47
Re: Best practice for naming temp table trigger functions Sebastien Flaesch 15:38
Re: Best practice for naming temp table trigger functions David G. Johnston 16:16
RE: unique index with several columns Voillequin, Jean-Marc 16:59
Re: Best practice for naming temp table trigger functions Sebastien Flaesch 17:24

March 9, 2022

Thread Author Time
Re: Best practice for naming temp table trigger functions Sebastien Flaesch 08:26

March 16, 2022

Thread Author Time
Apparently table locks are the key issue to see red flags Shaozhong SHI 20:14
Apparently table locks are the key issue to see red flags Shaozhong SHI 20:15
Re: Apparently table locks are the key issue to see red flags Ron 20:21
Re: Apparently table locks are the key issue to see red flags Adrian Klaver 20:23
How to explicitly lock and unlock tables in pgsql? Shaozhong SHI 20:30
How to explicitly lock and unlock tables in pgsql? Shaozhong SHI 20:30
Apparently table locks are the key issue to see red flags Shaozhong SHI 20:32
Re: How to explicitly lock and unlock tables in pgsql? Fabrízio de Royes Mello 20:35
How to explicitly state unlock in sql? Shaozhong SHI 20:56
Re: How to explicitly state unlock in sql? Rob Sargent 21:03
Re: How to explicitly state unlock in sql? Tom Lane 21:06

March 17, 2022

Thread Author Time
Re: How to explicitly lock and unlock tables in pgsql? Laurenz Albe 07:51
Re: Apparently table locks are the key issue to see red flags Jayson Hreczuck 13:21

March 18, 2022

Thread Author Time
PostgreSQL trigger on user logon Kevin Tu 14:46
Re: How to explicitly lock and unlock tables in pgsql? Merlin Moncure 16:38
Re: PostgreSQL trigger on user logon Steve Midgley 19:58
Re: How to explicitly lock and unlock tables in pgsql? Laurenz Albe 22:48

March 25, 2022

Thread Author Time
the order of operator computation Jian He 04:46
Re: the order of operator computation Tom Lane 05:32

April 2, 2022

Thread Author Time
How long does iteration over 4-5 million rows usually take? Shaozhong SHI 01:34
How long does iteration over 4-5 million rows usually take? Shaozhong SHI 01:35
Re: How long does iteration over 4-5 million rows usually take? Adrian Klaver 01:47
Re: How long does iteration over 4-5 million rows usually take? Ron 02:18
Re: How long does iteration over 4-5 million rows usually take? Rob Sargent 13:21
Aw: Re: How long does iteration over 4-5 million rows usually take? Karsten Hilbert 13:46
Re: Re: How long does iteration over 4-5 million rows usually take? Shaozhong SHI 14:16
Re: Re: How long does iteration over 4-5 million rows usually take? Benedict Holland 14:34
Re: How long does iteration over 4-5 million rows usually take? Steve Midgley 16:38

April 4, 2022

Thread Author Time
How to just get the last in a recursive query Shaozhong SHI 22:14
Re: How to just get the last in a recursive query Rob Sargent 22:16
Re: How to just get the last in a recursive query Shaozhong SHI 23:21
Re: How to just get the last in a recursive query Rob Sargent 23:24
Re: How to just get the last in a recursive query David G. Johnston 23:32

April 5, 2022

Thread Author Time
Re: How to just get the last in a recursive query Steve Midgley 00:00
Re: How to just get the last in a recursive query David G. Johnston 00:50
RE: How to just get the last in a recursive query Tchouante, Merlin 13:03
Histogram question. Jian He 14:34
Re: Histogram question. Steve Midgley 15:14

April 6, 2022

Thread Author Time
Does postgresql know the check condition is valid or not. or can check deduce from multiple conditions Jian He 04:07
Re: Does postgresql know the check condition is valid or not. or can check deduce from multiple conditions Tom Lane 04:10
Re: Does postgresql know the check condition is valid or not. or can check deduce from multiple conditions David G. Johnston 04:33

April 8, 2022

Thread Author Time
Long running processes and commit writing to disk Shaozhong SHI 16:39
Long running processes and commit writing to disk Shaozhong SHI 16:39
RE: Long running processes and commit writing to disk Mike Sofen 16:52
Re: Long running processes and commit writing to disk Rob Sargent 17:05
Re: Long running processes and commit writing to disk Ron 18:01

April 10, 2022

Thread Author Time
How best to do parallel query given tens of thousands of iteration of a loop of recursive queries? Shaozhong SHI 13:50
Re: How best to do parallel query given tens of thousands of iteration of a loop of recursive queries? Steve Midgley 16:03
Re: How best to do parallel query given tens of thousands of iteration of a loop of recursive queries? David G. Johnston 16:13

April 12, 2022

Thread Author Time
enable/disable instead of trigger Voillequin, Jean-Marc 13:12

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

Browse Archives

Prev | Next