pgsql-sql since 2020-10-10 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

Oct. 10, 2020

Thread	Author	Time
total and partial sums in the same query??	Iuri Sampaio	02:58
Re: total and partial sums in the same query??	David G. Johnston	03:40
Re: total and partial sums in the same query??	Iuri Sampaio	03:42
Re: total and partial sums in the same query??	David G. Johnston	03:58
Re: total and partial sums in the same query??	Iuri Sampaio	15:28
Re: total and partial sums in the same query??	David G. Johnston	17:55

Oct. 17, 2020

Thread	Author	Time
get counts of multiple field values in a jsonb column	Martin Norbäck Olivers	15:00
Re: get counts of multiple field values in a jsonb column	David G. Johnston	15:38
Re: get counts of multiple field values in a jsonb column	Rob Sargent	16:15

Oct. 20, 2020

Thread	Author	Time
Re: get counts of multiple field values in a jsonb column	Simon Riggs	08:56

Oct. 21, 2020

Thread	Author	Time
Best way to change values of a primary key referenced by many tables	Andreas Joseph Krogh	20:27
Re: Best way to change values of a primary key referenced by many tables	David G. Johnston	21:25
Re: Best way to change values of a primary key referenced by many tables	Iuri Sampaio	22:11

Nov. 12, 2020

Thread	Author	Time
Identify columns that need indexes	Yambu	07:50
Re: Identify columns that need indexes	hubert depesz lubaczewski	11:14

Nov. 18, 2020

Thread	Author	Time
Querry correction required	Sachin Kumar	17:43
Re: Querry correction required	Thomas Kellerer	17:49

Nov. 19, 2020

Thread	Author	Time
Get last generated serial sequence and set it up when explicit value is used	Sebastien FLAESCH	19:21
Re: Get last generated serial sequence and set it up when explicit value is used	David G. Johnston	20:04

Nov. 20, 2020

Thread	Author	Time
Re: Get last generated serial sequence and set it up when explicit value is used	Sebastien FLAESCH	08:19
Re: Get last generated serial sequence and set it up when explicit value is used	David G. Johnston	08:49
Re: Get last generated serial sequence and set it up when explicit value is used	Sebastien FLAESCH	10:23
perform setval() fails?	Sebastien FLAESCH	17:00
Re: perform setval() fails?	Christophe Pettus	17:01

Nov. 21, 2020

Thread	Author	Time
Re: Get last generated serial sequence and set it up when explicit value is used	Sebastien FLAESCH	09:26

Nov. 25, 2020

Thread	Author	Time
Re: Get last generated serial sequence and set it up when explicit value is used	Sebastien FLAESCH	11:32

Nov. 26, 2020

Thread	Author	Time
CTE materialized/not materialized	Voillequin, Jean-Marc	15:24

Nov. 27, 2020

Thread	Author	Time
Re: CTE materialized/not materialized	Alvaro Herrera	14:53
RE: CTE materialized/not materialized	Voillequin, Jean-Marc	15:18
Re: CTE materialized/not materialized	Tom Lane	15:35
RE: CTE materialized/not materialized	Voillequin, Jean-Marc	15:58
Re: CTE materialized/not materialized	Alvaro Herrera	17:03

Dec. 2, 2020

Thread	Author	Time
Join push down on FDW partitions	Anders Svensson	13:30
Re: Join push down on FDW partitions 📎	Samed YILDIRIM	14:44
parallel safe on user defined functions	Voillequin, Jean-Marc	15:25
Re: parallel safe on user defined functions	Tom Lane	16:15

Dec. 3, 2020

Thread	Author	Time
calling function	Yambu	03:47
Re: Join push down on FDW partitions	Anders Svensson	09:52

Dec. 18, 2020

Thread	Author	Time
Custom aggregate last_value_when	Ben Tilly	21:03

Dec. 21, 2020

Thread	Author	Time
dblink_exists	ml	01:35
Re: dblink_exists	David G. Johnston	01:52
Re: dblink_exists	ml	05:07
JSON path query returns duplicate values	Thomas Kellerer	09:43

Dec. 29, 2020

Thread	Author	Time
Re: JSON path query returns duplicate values	Thomas Kellerer	14:14

Jan. 7, 2021

Thread	Author	Time
how to make query	Sachin Kumar	10:15
PostgreSQL Django Query	Sachin Kumar	11:55
Re: how to make query	Philip Semanchuk	13:58
Re: how to make query	Sachin Kumar	14:25
Re: how to make query	Steve Midgley	16:50
Re: how to make query	Philip Semanchuk	17:05

Jan. 14, 2021

Thread	Author	Time
Non blocking type change for primary column	Torge Kummerow	16:26

Jan. 15, 2021

Thread	Author	Time
Re: Non blocking type change for primary column	Guillaume Lelarge	09:42

Jan. 16, 2021

Thread	Author	Time
Re: Non blocking type change for primary column	Mohamed Wael Khobalatte	05:18

Jan. 19, 2021

Thread	Author	Time
Bring to dead tuples to alive	Roberto Médola	13:02
Re: Bring to dead tuples to alive	Steve Midgley	16:02
Re: Bring to dead tuples to alive	Craig Jackson	16:48
Re: Bring to dead tuples to alive	Roberto Médola	17:37
Re: Bring to dead tuples to alive	Craig Jackson	18:41
Re: Bring to dead tuples to alive	Erik Brandsberg	19:47
Re: Bring to dead tuples to alive	Roberto Médola	20:10
Re: Bring to dead tuples to alive	Steve Midgley	20:29
Re: Bring to dead tuples to alive	Skylar Thompson	23:22

Jan. 20, 2021

Thread	Author	Time
Re: Bring to dead tuples to alive	Roberto Médola	12:58

Jan. 23, 2021

Thread	Author	Time
Question about WITH ORDINALITY and unnest	Mike Martin	13:17
Re: Question about WITH ORDINALITY and unnest	David G. Johnston	16:14
Re: Question about WITH ORDINALITY and unnest	Shaozhong SHI	21:14
Re: Question about WITH ORDINALITY and unnest	Tom Lane	21:50

Jan. 24, 2021

Thread	Author	Time
format integer	ml	14:57
Re: format integer	David G. Johnston	16:06
Re: format integer	Steve Midgley	16:37
Re: format integer	Torge Kummerow	16:48
Re: format integer	ml	17:35

Jan. 29, 2021

Thread	Author	Time
Re: Bring to dead tuples to alive	Roberto Médola	16:47

Feb. 5, 2021

Thread	Author	Time
How to fix Execute format error?	Joe How	11:22
Re: How to fix Execute format error?	Pavel Stehule	15:01
Re: How to fix Execute format error?	Joe How	17:40
Re: How to fix Execute format error?	Pavel Stehule	17:48

Feb. 7, 2021

Thread	Author	Time
Whitelink to other data stores	Shaozhong SHI	11:27
Re: Whitelink to other data stores	Ian Lawrence Barwick	11:34

Feb. 9, 2021

Thread	Author	Time
Relationship between PostgreSQL and Datalakes and etc on Azure	Shaozhong SHI	09:23
Re: Relationship between PostgreSQL and Datalakes and etc on Azure	Steve Midgley	16:44

Feb. 20, 2021

Thread	Author	Time
embedded composite types	Arturo Guadagnin	14:41
Re: embedded composite types	David G. Johnston	15:07
Re: embedded composite types	Tom Lane	15:58

March 17, 2021

Thread	Author	Time
select into composite type / return	Gary Stainburn	16:48
Re: select into composite type / return	Tom Lane	17:26
Re: select into composite type / return	Gary Stainburn	17:42

March 18, 2021

Thread	Author	Time
Re: select into composite type / return	Gary Stainburn	10:05
Re: select into composite type / return	Torsten Grust	11:10
Re: select into composite type / return	Gary Stainburn	11:20
Re: select into composite type / return	Tom Lane	14:28
Re: select into composite type / return	Gary Stainburn	14:32

March 22, 2021

Thread	Author	Time
Re: select into composite type / return	Gary Stainburn	10:34
Re: select into composite type / return	Pavel Stehule	10:40
Re: select into composite type / return	Gary Stainburn	10:54
Re: select into composite type / return	Pavel Stehule	10:56
Re: select into composite type / return	Gary Stainburn	11:01
Re: select into composite type / return	Pavel Stehule	11:15

March 31, 2021

Thread	Author	Time
Serial sequence name when table/column name in uppercase	Sebastien FLAESCH	08:35
Re: Serial sequence name when table/column name in uppercase	Ian Lawrence Barwick	08:51
Re: Serial sequence name when table/column name in uppercase	Sebastien FLAESCH	08:58
Re: Serial sequence name when table/column name in uppercase	Sebastien FLAESCH	10:13
Re: Serial sequence name when table/column name in uppercase	Tom Lane	13:55
Re: Serial sequence name when table/column name in uppercase	Sebastien FLAESCH	14:57
Re: Serial sequence name when table/column name in uppercase	Sebastien FLAESCH	15:13

April 6, 2021

Thread	Author	Time
URL Decode function	JORGE MALDONADO	04:34
Re: URL Decode function	MichaelDBA	12:56
Re: URL Decode function	Andreas Joseph Krogh	13:03
Re: URL Decode function	MichaelDBA	13:07

April 19, 2021

Thread	Author	Time
Substitute of TRY and CATCH in postgres	aditya desai	13:21
Re: Substitute of TRY and CATCH in postgres	Thomas Kellerer	13:32

May 11, 2021

Thread	Author	Time
set Assert checking on by session	Rein Petersen	22:43
Re: set Assert checking on by session	Tom Lane	23:20

May 23, 2021

Thread	Author	Time
Getting transaction details from the WAL?	Bo Guo	02:00
Re: Getting transaction details from the WAL?	Christophe Pettus	02:03
Re: Getting transaction details from the WAL?	Bo Guo	02:36

May 24, 2021

Thread	Author	Time
Index creation	Yambu	03:41
Re: Index creation	David Rowley	04:00
Re: Index creation	Yambu	04:42
Long updates by primary key	Алексей Белобородов	10:19
Re: Long updates by primary key	Vijaykumar Jain	10:52
Re: Index creation	Steve Midgley	16:09
Re: Index creation	Yambu	17:34

May 25, 2021

Thread	Author	Time
RE: Index creation	Marc Mamin	09:44
Re: Index creation	Yambu	10:18

May 26, 2021

Thread	Author	Time
Select for update	Yambu	09:26
Re: Select for update	David G. Johnston	12:27
Re: Select for update	Yambu	15:19
Re: Select for update	David G. Johnston	17:06
Re: Select for update	Tom Lane	17:36

May 28, 2021

Thread	Author	Time
Postgresql - Json syntax in INSERT RETURNING clause with INTO	Ron Clarke	18:32
Re: Postgresql - Json syntax in INSERT RETURNING clause with INTO	Vijaykumar Jain	19:36
Re: Postgresql - Json syntax in INSERT RETURNING clause with INTO	David G. Johnston	19:41

May 31, 2021

Thread	Author	Time
Check ref cursor	Yambu	14:37
Re: Check ref cursor	Pavel Stehule	15:39

June 3, 2021

Thread	Author	Time
Update to whole table	Yambu	13:43
Re: Update to whole table	Steve Midgley	13:55

June 15, 2021

Thread	Author	Time
function INPUT as whole table	Yambu	10:59
Re: function INPUT as whole table	David G. Johnston	12:41
Re: function INPUT as whole table	Tom Lane	13:33
Re: function INPUT as whole table	Viswanatha Sastry	14:01
Re: function INPUT as whole table	Yambu	14:07
Re: function INPUT as whole table	Дмитрий Иванов	17:40

June 16, 2021

Thread	Author	Time
Re: function INPUT as whole table	Дмитрий Иванов	01:50

June 17, 2021

Thread	Author	Time
Listen and notify in psql process	Sakshi Jain	11:01
Fwd: Listen and notify in psql process	Sakshi Jain	11:04
Re: Listen and notify in psql process	Ravi Krishna	11:45
Re: Listen and notify in psql process	Torsten Förtsch	13:34
Re: Listen and notify in psql process	Erik Brandsberg	14:22

June 21, 2021

Thread	Author	Time
Help to design relations between some 5 tables with possible many-to-many relations	JORGE MALDONADO	19:07
Re: Help to design relations between some 5 tables with possible many-to-many relations	David G. Johnston	19:25
Re: Help to design relations between some 5 tables with possible many-to-many relations	Dean Gibson (DB Administrator)	21:03
Re: Help to design relations between some 5 tables with possible many-to-many relations	Dean Gibson (DB Administrator)	21:57

July 2, 2021

Thread	Author	Time
LAST_VALUE returns the entire partition	Дмитрий Иванов	12:04
Re: LAST_VALUE returns the entire partition	Tom Lane	14:04
Re: LAST_VALUE returns the entire partition	Дмитрий Иванов	15:30

July 5, 2021

Thread	Author	Time
Substitute for table variable and data migration approach	Avadhut Narayan Joshi	11:05

July 6, 2021

Thread	Author	Time
Re: Substitute for table variable and data migration approach	Steve Midgley	15:23

July 7, 2021

Thread	Author	Time
UPPER() Function Not Working as Expected in PostgreSQL 12.5 Version	Saraswat, Dhruv	17:35

July 8, 2021

Thread	Author	Time
Re: UPPER() Function Not Working as Expected in PostgreSQL 12.5 Version	David G. Johnston	16:10
Re: UPPER() Function Not Working as Expected in PostgreSQL 12.5 Version	Tom Lane	16:49

July 9, 2021

Thread	Author	Time
Support for PostgreSQL stored procedure through ITX. 📎	Prajakta Chinchole	05:53
Re: Support for PostgreSQL stored procedure through ITX.	Tom Lane	13:42
Re: Sort a table by a column value that is a column name?	Rob Sargent	16:32
Re: Sort a table by a column value that is a column name?	Steve Midgley	16:42
Sort a table by a column value that is a column name?	overland	16:59
Re: Sort a table by a column value that is a column name?	David G. Johnston	17:01
Re: Sort a table by a column value that is a column name?	overland	19:08

July 28, 2021

Thread	Author	Time
pg_verify_checksums on ubuntu 16.04	Rein Petersen	16:20
Re: pg_verify_checksums on ubuntu 16.04	Tom Lane	16:47
Re: pg_verify_checksums on ubuntu 16.04	Christophe Pettus	16:51

July 29, 2021

Thread	Author	Time
Equivalent of InternalRowsAffected in NonExecuteQuery for PostgreSQL	Avadhut Narayan Joshi	12:22
Re: Equivalent of InternalRowsAffected in NonExecuteQuery for PostgreSQL	Vijaykumar Jain	12:26
RE: Equivalent of InternalRowsAffected in NonExecuteQuery for PostgreSQL	Avadhut Narayan Joshi	12:31
Re: Equivalent of InternalRowsAffected in NonExecuteQuery for PostgreSQL	Vijaykumar Jain	12:37
Re: Equivalent of InternalRowsAffected in NonExecuteQuery for PostgreSQL	Steve Midgley	19:43

Aug. 3, 2021

Thread	Author	Time
How to generate the order if you know the next item for each item?	Rockdale Green	15:40
Re: How to generate the order if you know the next item for each item?	David G. Johnston	16:22

Aug. 5, 2021

Thread	Author	Time
Like Command returning wrong result set	Tchouante, Merlin	14:00
Sv: Like Command returning wrong result set	Andreas Joseph Krogh	14:04
Re: Like Command returning wrong result set	Pavel Stehule	14:05
Re: Like Command returning wrong result set	Christophe Pettus	14:05
Show table and columns with null value and count	Zied Kharrat	14:08
RE: Like Command returning wrong result set	Tchouante, Merlin	14:09
Re: How to generate the order if you know the next item for each item?	Tony Shelver	14:33
Re: Show table and columns with null value and count	David G. Johnston	14:38
Re: How to generate the order if you know the next item for each item?	Rockdale Green	16:53
Re: How to generate the order if you know the next item for each item?	Rockdale Green	16:55

Aug. 9, 2021

Thread	Author	Time
Hide some tables	[email protected]	12:57
Re: Hide some tables	Jayadevan M	13:39
Re: Hide some tables	Tom Lane	13:45
Re: Hide some tables	[email protected]	17:48

Aug. 10, 2021

Thread	Author	Time
Is this a security oversight?	Ben Tilly	17:41
Re: Is this a security oversight?	Tom Lane	18:32
Re: Is this a security oversight?	Ben Tilly	18:40
Re: Is this a security oversight?	Tom Lane	18:45

Aug. 12, 2021

Thread	Author	Time
How to call webservice from PostgreSQL	aditya desai	12:49
Re: How to call webservice from PostgreSQL	Pavel Stehule	12:53
Re: How to call webservice from PostgreSQL	aditya desai	15:11

Aug. 13, 2021

Thread	Author	Time
Is there any way to invoke Java API from PostgreSQL	aditya desai	04:27

Browse Archives

Prev | Next