pgsql-sql - October 2021

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
Jump to day: 1 3 4 5 6 7 8 9 10 11 12 13 14 17 18 19 22 23 25 28 30

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

Browse Archives

Prev | Next
Jump to day: 1 3 4 5 6 7 8 9 10 11 12 13 14 17 18 19 22 23 25 28 30