pgsql-sql since 2021-05-31 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

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
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

Browse Archives

Prev | Next