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

Sept. 4, 2020

Thread Author Time
Re: Crossing/Rotating table rows to rows and columns Iuri Sampaio 00:20
Re: Crossing/Rotating table rows to rows and columns Christophe Pettus 00:22

Sept. 7, 2020

Thread Author Time
Re: Crossing/Rotating table rows to rows and columns Iuri Sampaio 02:03

Sept. 11, 2020

Thread Author Time
Clarification on pg_attribute attrelid Mike Martin 11:26
Re: Clarification on pg_attribute attrelid Tom Lane 14:12

Sept. 17, 2020

Thread Author Time
Postgres as a service for supporting common application users Shaozhong SHI 22:59
Postgres as a service for supporting common application users Shaozhong SHI 23:04

Oct. 3, 2020

Thread Author Time
Querying sporadic time series type data. Tim Uckun 05:44
Re: Querying sporadic time series type data. David G. Johnston 16:11
Re: Querying sporadic time series type data. Tim Uckun 23:53

Oct. 4, 2020

Thread Author Time
Re: Querying sporadic time series type data. David G. Johnston 00:10
Re: Querying sporadic time series type data. Steven Pousty 00:42
Re: Querying sporadic time series type data. Tim Uckun 08:29
parallelisation of queries Francesco De Angelis 14:40

Oct. 8, 2020

Thread Author Time
libpq CREATE DATABASE operation from multiple treads p.sun.fun 19:46
Re: libpq CREATE DATABASE operation from multiple treads Tom Lane 19:57
Re: libpq CREATE DATABASE operation from multiple treads p.sun.fun 20:04
Re: libpq CREATE DATABASE operation from multiple treads Dmitry Igrishin 20:15
Re: libpq CREATE DATABASE operation from multiple treads p.sun.fun 20:30
Re: libpq CREATE DATABASE operation from multiple treads Tom Lane 20:32
Re: libpq CREATE DATABASE operation from multiple treads Rob Sargent 20:35
Re: libpq CREATE DATABASE operation from multiple treads Tom Lane 20:36
Re: libpq CREATE DATABASE operation from multiple treads p.sun.fun 20:41
Re: libpq CREATE DATABASE operation from multiple treads Rob Sargent 20:43
Re: libpq CREATE DATABASE operation from multiple treads p.sun.fun 20:46
Re: libpq CREATE DATABASE operation from multiple treads Rob Sargent 20:50
Re: libpq CREATE DATABASE operation from multiple treads p.sun.fun 20:52
Re: libpq CREATE DATABASE operation from multiple treads Tom Lane 20:56
Re: libpq CREATE DATABASE operation from multiple treads Tom Lane 20:57

Oct. 9, 2020

Thread Author Time
Re: libpq CREATE DATABASE operation from multiple treads p.sun.fun 03:33
Re: libpq CREATE DATABASE operation from multiple treads Guillaume Lelarge 03:44
Re: libpq CREATE DATABASE operation from multiple treads p.sun.fun 03:49
send query in background Franz Timmer 04:31
send query in background ml 04:34
Re: send query in background Tatsuo Ishii 04:40
getting aroung chr(0) James Cloos 20:01

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