pgsql-sql before 2022-06-09 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. 16, 2022

Thread	Author	Time
Is there a way to automatically scan a table and determine the format of data	Shaozhong SHI	01:27
Try catch error, return data	Shaozhong SHI	02:13
Is there a way to automatically scan a table and determine the format of data	Shaozhong SHI	02:13
Re: Try catch error, return data	Skylar Thompson	03:08
Re: Try catch error, return data	Karsten Hilbert	10:01
Re: Is there a way to automatically scan a table and determine the format of data	Karsten Hilbert	10:03

Feb. 17, 2022

Thread	Author	Time
Advancing the capability of Postgres and PostGIS	Shaozhong SHI	22:38

Feb. 19, 2022

Thread	Author	Time
Re: Re: Turn a json column into a table	Shaozhong SHI	22:03
Re: Re: Re: Turn a json column into a table	Shaozhong SHI	22:40
Re: Turn a json column into a table	Rob Sargent	22:46
Re: Turn a json column into a table	Shaozhong SHI	23:22
Re: Turn a json column into a table	Shaozhong SHI	23:54

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

Browse Archives

Prev | Next