pgsql-sql since 2021-08-12 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

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
Re: Is there any way to invoke Java API from PostgreSQL Erik Brandsberg 04:32
Re: Is there any way to invoke Java API from PostgreSQL aditya desai 04:42
Re: Is there any way to invoke Java API from PostgreSQL Erik Brandsberg 04:54
How to revoke access and list schema objects [email protected] 16:00
Re: Is there any way to invoke Java API from PostgreSQL Steve Midgley 16:39
Re: How to revoke access and list schema objects Programadores cba 19:03

Aug. 18, 2021

Thread Author Time
Re: Is there any way to invoke Java API from PostgreSQL aditya desai 10:18
Backup Functions Sridhar Parepalli 15:05
Re: Backup Functions Vijaykumar Jain 15:30
RE: Backup Functions Sridhar Parepalli 16:05
Re: Backup Functions Tom Lane 16:17
RE: Backup Functions Sridhar Parepalli 17:14
Re: Backup Functions David G. Johnston 17:43

Aug. 19, 2021

Thread Author Time
Re: Backup Functions David G. Johnston 05:12

Aug. 23, 2021

Thread Author Time
Partition by outer join aditya desai 15:52

Aug. 24, 2021

Thread Author Time
Re: Partition by outer join aditya desai 03:58
Re: Partition by outer join hubert depesz lubaczewski 06:32
Re: Partition by outer join Thomas Kellerer 06:39
Re: Partition by outer join aditya desai 06:49
question about to_tsvector and to_tsquery Martin Norbäck Olivers 12:01
Re: question about to_tsvector and to_tsquery Tom Lane 14:12
Re: Partition by outer join David G. Johnston 14:15
Re: Partition by outer join Steve Midgley 16:01
Re: Partition by outer join David G. Johnston 16:09
Re: Partition by outer join Thomas Kellerer 16:45

Aug. 26, 2021

Thread Author Time
Re: Partition by outer join aditya desai 03:37

Sept. 13, 2021

Thread Author Time
PostgreSQL performance GNU vs LLVM arjun shetty 17:23

Sept. 19, 2021

Thread Author Time
How to sort deleted rows with trigger. Some rows before then some rows after. [email protected] 17:31
Re: How to sort deleted rows with trigger. Some rows before then some rows after. Rob Sargent 18:00

Sept. 20, 2021

Thread Author Time
Re: How to sort deleted rows with trigger. Some rows before then some rows after. intmail01 15:53
Re: How to sort deleted rows with trigger. Some rows before then some rows after. David G. Johnston 16:22
Re: How to sort deleted rows with trigger. Some rows before then some rows after. Rob Sargent 16:58

Sept. 24, 2021

Thread Author Time
SQL Error [0A000]: ERROR: OVER is not supported for ordered-set aggregate percentile_cont 📎 Matias Montroull 13:23
Re: SQL Error [0A000]: ERROR: OVER is not supported for ordered-set aggregate percentile_cont David G. Johnston 21:04

Sept. 25, 2021

Thread Author Time
Creating a query to structure results grouped by two columns, pivoting only a third colum Iuri Sampaio 16:39

Sept. 26, 2021

Thread Author Time
Re: Creating a query to structure results grouped by two columns, pivoting only a third colum Steve Midgley 00:53

Sept. 27, 2021

Thread Author Time
Re: Creating a query to structure results grouped by two columns, pivoting only a third colum Iuri Sampaio 14:06

Oct. 3, 2021

Thread Author Time
PostgreSQL CHECK Constraint Shaozhong SHI 07:30
PostgreSQL CHECK Constraint Shaozhong SHI 07:31
Re: PostgreSQL CHECK Constraint Christian Ramseyer 14:01
Re: PostgreSQL CHECK Constraint Shaozhong SHI 18:16
Re: PostgreSQL CHECK Constraint Karsten Hilbert 18:35
Re: PostgreSQL CHECK Constraint Shaozhong SHI 18:44
Re: PostgreSQL CHECK Constraint Christian Ramseyer 18:47
Re: PostgreSQL CHECK Constraint Shaozhong SHI 18:53
Re: PostgreSQL CHECK Constraint Karsten Hilbert 18:56

Oct. 4, 2021

Thread Author Time
How to set up temporary path for starting up psql in any folder? Shaozhong SHI 10:40
How to set up temporary path for starting up psql in any folder? Shaozhong SHI 11:18
Re: How to set up temporary path for starting up psql in any folder? Francisco Olarte 11:24
Testing of a fast method to bulk insert a Pandas DataFrame into Postgres Shaozhong SHI 15:43
Testing of a fast method to bulk insert a Pandas DataFrame into Postgres Shaozhong SHI 15:44
Re: Testing of a fast method to bulk insert a Pandas DataFrame into Postgres Adrian Klaver 16:06
Re: Testing of a fast method to bulk insert a Pandas DataFrame into Postgres Shaozhong SHI 16:20
Re: Testing of a fast method to bulk insert a Pandas DataFrame into Postgres Rob Sargent 16:25
Re: Testing of a fast method to bulk insert a Pandas DataFrame into Postgres Adrian Klaver 16:50
Re: Testing of a fast method to bulk insert a Pandas DataFrame into Postgres Shaozhong SHI 17:10
Re: Testing of a fast method to bulk insert a Pandas DataFrame into Postgres Adrian Klaver 17:28
Re: Testing of a fast method to bulk insert a Pandas DataFrame into Postgres Steve Midgley 17:30
Re: Testing of a fast method to bulk insert a Pandas DataFrame into Postgres Adrian Klaver 17:30
Re: How to set up temporary path for starting up psql in any folder? Steve Midgley 17:34
Re: Testing of a fast method to bulk insert a Pandas DataFrame into Postgres Shaozhong SHI 20:13
Re: Testing of a fast method to bulk insert a Pandas DataFrame into Postgres Steve Midgley 23:34

Oct. 5, 2021

Thread Author Time
Is it possible to combine the power of Postgres and Python in do statement? Shaozhong SHI 13:05
Re: Is it possible to combine the power of Postgres and Python in do statement? Tom Lane 14:32
Re: Is it possible to combine the power of Postgres and Python in do statement? Shaozhong SHI 15:48

Oct. 6, 2021

Thread Author Time
DBMS Queus aditya desai 13:19
Create trigger on after logon on schema aditya desai 15:22
Re: DBMS Queus hubert depesz lubaczewski 15:42
Re: Create trigger on after logon on schema hubert depesz lubaczewski 15:44
Re: Create trigger on after logon on schema aditya desai 16:09
Re: Create trigger on after logon on schema Steve Midgley 18:16
Re: Create trigger on after logon on schema Erik Brandsberg 18:26

Oct. 7, 2021

Thread Author Time
Re: Create trigger on after logon on schema aditya desai 05:19
Re: Create trigger on after logon on schema aditya desai 08:48
Re: Create trigger on after logon on schema Metin Ulusinan 20:53

Oct. 8, 2021

Thread Author Time
How to capture error message and save to a table in PostgreSQL? Shaozhong SHI 09:45
A new scenario for check constraints Shaozhong SHI 11:13
Re: How to capture error message and save to a table in PostgreSQL? Steve Midgley 17:09
Re: A new scenario for check constraints Steve Midgley 19:01

Oct. 9, 2021

Thread Author Time
Re: How to capture error message and save to a table in PostgreSQL? Karsten Hilbert 18:22
Re: How to capture error message and save to a table in PostgreSQL? Rob Sargent 18:29

Oct. 10, 2021

Thread Author Time
Removing JSONB key across all elements of nested array JP 20:45

Oct. 11, 2021

Thread Author Time
Re: Create trigger on after logon on schema aditya desai 07:48
Regex for properly formed names Shaozhong SHI 13:00
Aw: Regex for properly formed names Karsten Hilbert 13:10
Re: Regex for properly formed names Metin Ulusinan 13:15
LISTEN / NOTIFY aditya desai 14:11
Re: LISTEN / NOTIFY Erik Brandsberg 14:52
Re: Regex for properly formed names Steve Midgley 15:08
Re: Regex for properly formed names Erik Brandsberg 15:16
Re: LISTEN / NOTIFY aditya desai 15:31
Re: LISTEN / NOTIFY David G. Johnston 15:36
Re: LISTEN / NOTIFY Steve Midgley 15:46
Re: LISTEN / NOTIFY aditya desai 16:36
Re: LISTEN / NOTIFY Erik Brandsberg 16:59
Re: Removing JSONB key across all elements of nested array Steve Midgley 19:09

Oct. 12, 2021

Thread Author Time
Fault with initcap Shaozhong SHI 16:30
Fault with initcap Shaozhong SHI 16:31
Aw: Fault with initcap Karsten Hilbert 16:50
Re: Fault with initcap Rob Sargent 16:53
Re: Fault with initcap Steve Midgley 17:28
Aw: Re: Fault with initcap Karsten Hilbert 17:52
Re: Fault with initcap Adrian Klaver 19:34
Re: Removing JSONB key across all elements of nested array JP 19:44
Aw: Re: Re: Fault with initcap Karsten Hilbert 19:56
Re: Fault with initcap Shaozhong SHI 20:50
Re: Fault with initcap Karsten Hilbert 21:09
Re: Fault with initcap Adrian Klaver 22:02
Re: Fault with initcap Shaozhong SHI 23:03

Oct. 13, 2021

Thread Author Time
Re: Removing JSONB key across all elements of nested array Steve Midgley 00:17
Re: Fault with initcap Adrian Klaver 00:27
Re: Fault with initcap Lee Hachadoorian 03:55
Re: Fault with initcap Metin Ulusinan 06:33
Re: Fault with initcap Pavel Stehule 07:03
Re: Removing JSONB key across all elements of nested array JP 07:04
Re: Fault with initcap Shaozhong SHI 08:48
Re: Fault with initcap Metin Ulusinan 09:38
RE: Fault with initcap Jain, Ankit 16:17

Oct. 14, 2021

Thread Author Time
Re: Fault with initcap Shaozhong SHI 08:55
What is the regex for apostraphe in postgres? Shaozhong SHI 10:31
Re: What is the regex for apostraphe in postgres David G. Johnston 12:31
Re: What is the regex for apostraphe in postgres? Torsten Grust 12:35
Re: Fault with initcap Metin Ulusinan 13:42
Re: What is the regex for apostraphe in postgres? Steve Midgley 15:19

Oct. 17, 2021

Thread Author Time
Does PostgreSQL have a pseudo-column like "LEVEL" in Oracle Jian He 08:36
Re: Does PostgreSQL have a pseudo-column like "LEVEL" in Oracle Thomas Kellerer 10:53
Re: Does PostgreSQL have a pseudo-column like "LEVEL" in Oracle Simon Riggs 20:42

Oct. 18, 2021

Thread Author Time
Query out of memory aditya desai 16:42
Re: Query out of memory aditya desai 16:43
Re: Query out of memory Vijaykumar Jain 16:48
Re: Query out of memory aditya desai 19:03
Re: Query out of memory Guillaume Lelarge 21:05

Oct. 19, 2021

Thread Author Time
Re: Query out of memory aditya desai 04:07
Fwd: Query out of memory aditya desai 05:58
Re: Query out of memory Adam Brusselback 09:54
Re: Query out of memory Dave Cramer 09:57
Re: Fwd: Query out of memory Justin Pryzby 10:26
Re: Query out of memory aditya desai 10:46
Sv: Fwd: Query out of memory Andreas Joseph Krogh 11:08
Re: Query out of memory Michael Lewis 13:39
create a procedure based on column data change in postgrersql Jian He 13:45
Re: Query out of memory aditya desai 13:48
Re: create a procedure based on column data change in postgrersql David G. Johnston 14:37

Oct. 22, 2021

Thread Author Time
Re: Query out of memory Ninad Shah 14:41

Oct. 23, 2021

Thread Author Time
Convert text to user defined datatype aditya desai 09:40
RE: Convert text to user defined datatype Voillequin, Jean-Marc 14:18
Re: Convert text to user defined datatype aditya desai 14:31
Re: Convert text to user defined datatype Tom Lane 14:39

Oct. 25, 2021

Thread Author Time
Re: Convert text to user defined datatype aditya desai 03:27

Oct. 28, 2021

Thread Author Time
How to assign variable in array value inside function proc. aditya desai 17:43
Re: How to assign variable in array value inside function proc. David G. Johnston 18:05

Oct. 30, 2021

Thread Author Time
Re: How to assign variable in array value inside function proc. aditya desai 17:43

Nov. 1, 2021

Thread Author Time
Re: How to assign variable in array value inside function proc. aditya desai 16:20
Re: How to assign variable in array value inside function proc. David G. Johnston 16:53

Nov. 11, 2021

Thread Author Time
Constructing colum name as alias aditya desai 07:46
Re: Constructing colum name as alias Torsten Grust 11:10
Re: Constructing colum name as alias David G. Johnston 13:19
Re: Constructing colum name as alias Theodore M Rolle, Jr. 13:22
Re: Constructing colum name as alias David G. Johnston 14:14
Re: Constructing colum name as alias David G. Johnston 14:16
Re: Constructing colum name as alias chris 14:23

Nov. 16, 2021

Thread Author Time
SELECT on view runs slower with more WHERE conditions aditya desai 17:10

Nov. 30, 2021

Thread Author Time
Re: Fault with initcap Shaozhong SHI 00:17

Dec. 9, 2021

Thread Author Time
ERROR ON INSERTING USING A CURSOR IN EDB POSTGRESQL 📎 James Kitambara 10:36
Re: ERROR ON INSERTING USING A CURSOR IN EDB POSTGRESQL Sandeep Saxena 10:55

Dec. 10, 2021

Thread Author Time
Re: ERROR ON INSERTING USING A CURSOR IN EDB POSTGRESQL 📎 James Kitambara 15:40

Dec. 12, 2021

Thread Author Time
Memory exhaustion on large query Brice André 18:25
Re: Memory exhaustion on large query Erik Brandsberg 18:33
Re: Memory exhaustion on large query Tom Lane 18:43

Dec. 14, 2021

Thread Author Time
5 tables with 3 different relation cases JORGE MALDONADO 02:32
Re: Memory exhaustion on large query Brice André 03:31
Re: 5 tables with 3 different relation cases Rob Sargent 03:47
Re: 5 tables with 3 different relation cases Steve Midgley 04:19
Re: ERROR ON INSERTING USING A CURSOR IN EDB POSTGRESQL Simon Riggs 10:58
Re: ERROR ON INSERTING USING A CURSOR IN EDB POSTGRESQL James Kitambara 15:22

Dec. 15, 2021

Thread Author Time
Re: ERROR ON INSERTING USING A CURSOR IN EDB POSTGRESQL hubert depesz lubaczewski 11:36

Dec. 17, 2021

Thread Author Time
Pragma autonomous transactions in Postgres/ Certification based authentication in DB Links aditya desai 15:43
Re: Pragma autonomous transactions in Postgres/ Certification based authentication in DB Links Jonathan Katz 16:11
Re: Pragma autonomous transactions in Postgres/ Certification based authentication in DB Links Tom Lane 16:27
Re: Pragma autonomous transactions in Postgres/ Certification based authentication in DB Links Jonathan Katz 16:42
Re: Pragma autonomous transactions in Postgres/ Certification based authentication in DB Links Tom Lane 17:04
Re: Pragma autonomous transactions in Postgres/ Certification based authentication in DB Links Thomas Kellerer 17:07
Re: Pragma autonomous transactions in Postgres/ Certification based authentication in DB Links Steve Midgley 17:13
Re: Pragma autonomous transactions in Postgres/ Certification based authentication in DB Links Tom Lane 17:58

Dec. 30, 2021

Thread Author Time
ALTERING COLLATION aditya desai 07:42
Re: ALTERING COLLATION Tom Lane 15:58

Jan. 5, 2022

Thread Author Time
Return product category with hierarchical info Richard Klingler 12:19
Re: Return product category with hierarchical info Oliveiros Cristina 12:28
Re: Return product category with hierarchical info Richard Klingler 12:37
Re: Return product category with hierarchical info Oliveiros Cristina 13:00
Re: Return product category with hierarchical info Steve Midgley 16:42

Jan. 19, 2022

Thread Author Time
Clean up shop database Richard Klingler 11:03
Re: Clean up shop database Rob Sargent 12:04
Re: Clean up shop database Richard Klingler 12:40
Re: Clean up shop database Rob Sargent 12:56
Re: Clean up shop database Richard Klingler 13:17

Browse Archives

Prev | Next