pgsql-sql since 2024-01-09 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

Jan. 9, 2024

Thread	Author	Time
How to use one function which can be accessed for all schemas	intmail01	08:15
Problem with refcursor	Maximilian Tyrtania	08:23
Re: Problem with refcursor	Maximilian Tyrtania	11:17
Re: How to use one function which can be accessed for all schemas	Tom Lane	15:29
How to use one function which can be accessed for all schemas	Wetmore, Matthew (CTR)	16:39
Re: How to use one function which can be accessed for all schemas	Bindra Bambharoliya	18:09
Re: How to use one function which can be accessed for all schemas	David G. Johnston	18:38

Jan. 31, 2024

Thread	Author	Time
Re: Problem with refcursor	Samed YILDIRIM	14:59

Feb. 7, 2024

Thread	Author	Time
POSTGRES 15 - CONSTRAINT TRIGGER CREATION	Cars Jeeva	10:11
Re: POSTGRES 15 - CONSTRAINT TRIGGER CREATION	Steve Midgley	17:50
Re: POSTGRES 15 - CONSTRAINT TRIGGER CREATION	Tom Lane	23:30

Feb. 21, 2024

Thread	Author	Time
How to find all current sequence IDs	Campbell, Lance	22:06
Re: How to find all current sequence IDs	Tom Lane	22:13
Re: How to find all current sequence IDs	Nisarg Patel	23:17

Feb. 22, 2024

Thread	Author	Time
PG_DUMP ERROR	Cars Jeeva	10:42

Feb. 29, 2024

Thread	Author	Time
RE: How to find all current sequence IDs	Campbell, Lance	14:49

March 8, 2024

Thread	Author	Time
How to know if all insertions are finished	intmail01	12:01
Re: How to know if all insertions are finished	Steve Midgley	16:26
How to know if all insertions are finished	Wetmore, Matthew (CTR)	16:52

March 9, 2024

Thread	Author	Time
Re: How to know if all insertions are finished	intmail01	17:11

March 12, 2024

Thread	Author	Time
Nested loop behaviour with pg_stat_activity	Sheryl Prabhu David	07:30

March 13, 2024

Thread	Author	Time
Can portals interleave with other portals	Evgeny Smirnov	04:38
Re: Can portals interleave with other portals	Tom Lane	04:55
Re: Can portals interleave with other portals	Evgeny Smirnov	05:28
Re: Nested loop behaviour with pg_stat_activity	Tom Lane	14:30

March 14, 2024

Thread	Author	Time
Re: Nested loop behaviour with pg_stat_activity	Sheryl Prabhu David	07:29

March 22, 2024

Thread	Author	Time
How to choose table in SELECT clause without schema qualifier or 'set local'	intmail01	07:11
UPDATE with AND clarification	Jamie Thompson	11:36
Re: How to choose table in SELECT clause without schema qualifier or 'set local'	David G. Johnston	13:28
Re: UPDATE with AND clarification	David G. Johnston	13:35
Cursor with hold for select takes too long	Bindra Bambharoliya	16:50
Re: Cursor with hold for select takes too long	Erik Brandsberg	17:39
Re: Cursor with hold for select takes too long	Bindra Bambharoliya	17:47
Re: Cursor with hold for select takes too long	Tom Lane	17:57
Re: UPDATE with AND clarification	Jamie Thompson	19:51

March 24, 2024

Thread	Author	Time
decode/encode backslash to base64	ft	21:29
decode/encode backslash to base64	ft	21:31

March 25, 2024

Thread	Author	Time
Re: decode/encode backslash to base64	Tom Lane	13:48
Get error when calling function that returns a table 📎	Russell Rose | Passfield Data Systems	15:43
Re: Get error when calling function that returns a table	Tom Lane	16:26

March 26, 2024

Thread	Author	Time
xml build a list of all elements	ft	21:04
Re: xml build a list of all elements	Steve Midgley	22:27

April 1, 2024

Thread	Author	Time
help with a particular multi-table query	James Cloos	22:03
Re: help with a particular multi-table query	Steve Midgley	23:13

April 2, 2024

Thread	Author	Time
postgres is slow on windows 📎	Nazneen Mulani	09:19
Re: postgres is slow on windows	Jayadevan M	10:37

April 4, 2024

Thread	Author	Time
Re: postgres is slow on windows	Samed YILDIRIM	09:17
Re: help with a particular multi-table query	Samed YILDIRIM	10:18

April 5, 2024

Thread	Author	Time
Help with error date_trunc() function.	Miguel Angel Prada	16:23
Re: Help with error date_trunc() function.	Tom Lane	16:37
Function can not use the 'NEW' variable as a direct parameter inside trigger function?	intmail01	17:17
Re: Function can not use the 'NEW' variable as a direct parameter inside trigger function?	Tom Lane	19:21

April 27, 2024

Thread	Author	Time
How to pass arguments in postgres to sql scripts.	kunwar singh	13:03
Re: How to pass arguments in postgres to sql scripts.	Samed YILDIRIM	13:13

May 1, 2024

Thread	Author	Time
One parent record with 3 possible child records	JORGE MALDONADO	23:08
Re: One parent record with 3 possible child records	David G. Johnston	23:24

May 2, 2024

Thread	Author	Time
Re: One parent record with 3 possible child records	Sanjay Minni	13:33
Re: One parent record with 3 possible child records	Rob Sargent	13:37
Re: One parent record with 3 possible child records	David G. Johnston	14:02
One parent record with 3 possible child records	Wetmore, Matthew (CTR)	14:37
Re: One parent record with 3 possible child records	Sanjay Minni	15:12
Re: One parent record with 3 possible child records	Rob Sargent	18:28
Re: One parent record with 3 possible child records	Nic Mitchell	22:47

May 3, 2024

Thread	Author	Time
Re: How to pass arguments in postgres to sql scripts.	Feike Steenbergen	16:43

May 14, 2024

Thread	Author	Time
Small table selection extremely slow!	Bo Guo	11:11
Re: Small table selection extremely slow!	David Rowley	11:16
Re: Small table selection extremely slow!	MichaelDBA	11:26
Re: Small table selection extremely slow!	Bo Guo	11:50
Re: Small table selection extremely slow!	Shane Borden	12:10
Re: Small table selection extremely slow!	Bo Guo	12:15
Re: Small table selection extremely slow!	Bo Guo	13:36

May 30, 2024

Thread	Author	Time
Pgadmin 4 cannot add or modify line in a view	intmail01	14:26
Re: Pgadmin 4 cannot add or modify line in a view	Usman Khan	14:52
Re: Pgadmin 4 cannot add or modify line in a view	intmail01	18:01
Re: Pgadmin 4 cannot add or modify line in a view	Usman Khan	19:07
Re: Pgadmin 4 cannot add or modify line in a view	Steve Midgley	21:40

May 31, 2024

Thread	Author	Time
Re: Pgadmin 4 cannot add or modify line in a view	Amitabh Kant	02:05
Postgres fine tuning	Kanimozhi Manoharan	05:42
Re: Pgadmin 4 cannot add or modify line in a view	Muhammad Ikram	06:21
Re: Pgadmin 4 cannot add or modify line in a view	intmail01	15:33

June 3, 2024

Thread	Author	Time
Re: Postgres fine tuning	Kanimozhi Manoharan	05:26

June 25, 2024

Thread	Author	Time
struggling with GRANT while upgrading from 13 to 16	Axel Rau	17:04
Re: struggling with GRANT while upgrading from 13 to 16	Steve Midgley	17:28
Re: struggling with GRANT while upgrading from 13 to 16	Axel Rau	17:38
Re: struggling with GRANT while upgrading from 13 to 16	Tom Lane	18:46

June 26, 2024

Thread	Author	Time
Re: struggling with GRANT while upgrading from 13 to 16	Axel Rau	11:01
Re: struggling with GRANT while upgrading from 13 to 16	Axel Rau	11:08
[RESOLVED] Re: struggling with GRANT while upgrading from 13 to 16	Axel Rau	13:38

July 8, 2024

Thread	Author	Time
Trick to create alias/mirror table	intmail01	11:27
Re: Trick to create alias/mirror table	Kashif Zeeshan	11:55
Re: Trick to create alias/mirror table	shammat	12:09
Re: Trick to create alias/mirror table	Achilleas Mantzios - cloud	12:17
Re: Trick to create alias/mirror table	intmail01	13:04
Re: Trick to create alias/mirror table	David G. Johnston	13:11
Re: Trick to create alias/mirror table	shammat	13:29
Re: Trick to create alias/mirror table	shammat	13:44

July 15, 2024

Thread	Author	Time
SQL statements error in pgsql 16 but not in pgsql 12	Frank Komsic	22:57
Re: SQL statements error in pgsql 16 but not in pgsql 12	David G. Johnston	23:23

July 16, 2024

Thread	Author	Time
Re: SQL statements error in pgsql 16 but not in pgsql 12	Bharani SV-forum	14:56
Re: SQL statements error in pgsql 16 but not in pgsql 12	David G. Johnston	15:00
Re: SQL statements error in pgsql 16 but not in pgsql 12	Frank Komsic	18:01

July 18, 2024

Thread	Author	Time
Re: SQL statements error in pgsql 16 but not in pgsql 12	Bharani SV-forum	14:50
Re: SQL statements error in pgsql 16 but not in pgsql 12	Tom Lane	14:57

July 20, 2024

Thread	Author	Time
Using replication to upgrade db from 12 to 16	Frank Komsic	17:01
Re: Using replication to upgrade db from 12 to 16	Kashif Zeeshan	17:45
Re: Using replication to upgrade db from 12 to 16	Frank Komsic	17:59
Re: Using replication to upgrade db from 12 to 16	Kashif Zeeshan	18:09

July 22, 2024

Thread	Author	Time
Re: Using replication to upgrade db from 12 to 16	Achilleas Mantzios	17:00

Aug. 19, 2024

Thread	Author	Time
Powerfailure caused a reduction in INSERT performance of version 12 database.	Frank Komsic	14:33
Re: Powerfailure caused a reduction in INSERT performance of version 12 database.	Steve Midgley	14:49
Re: Powerfailure caused a reduction in INSERT performance of version 12 database.	Frank Komsic	16:07
Re: Powerfailure caused a reduction in INSERT performance of version 12 database.	Frank Komsic	16:27
Re: Powerfailure caused a reduction in INSERT performance of version 12 database.	Frank Komsic	16:31
Re: Powerfailure caused a reduction in INSERT performance of version 12 database.	Steve Midgley	16:37
Re: Powerfailure caused a reduction in INSERT performance of version 12 database.	Frank Komsic	17:16

Aug. 27, 2024

Thread	Author	Time
ORDER BY elements in ARRAY	Andreas Joseph Krogh	11:22
Re: ORDER BY elements in ARRAY	Guillaume Lelarge	11:44
object mapping for json/jsonb columns	Jan Bernitt	12:28
Re: ORDER BY elements in ARRAY	David G. Johnston	12:39
Re: ORDER BY elements in ARRAY	Andreas Joseph Krogh	14:59
Re: object mapping for json/jsonb columns	Steve Midgley	15:34
Re: ORDER BY elements in ARRAY	David G. Johnston	16:03
Re: object mapping for json/jsonb columns	Jan Bernitt	16:05
object mapping for json/jsonb columns	David G. Johnston	16:17
Re: ORDER BY elements in ARRAY	Andreas Joseph Krogh	16:27

Sept. 3, 2024

Thread	Author	Time
Re: Powerfailure caused a reduction in INSERT performance of version 12 database.	Frank Komsic	22:14

Sept. 13, 2024

Thread	Author	Time
PostgreSQL implicitly double-quoting identifier name with umlaut	Michael Downey	23:06
Re: PostgreSQL implicitly double-quoting identifier name with umlaut	Tom Lane	23:20
RE: PostgreSQL implicitly double-quoting identifier name with umlaut	Michael Downey	23:33

Oct. 3, 2024

Thread	Author	Time
invalid reference to FROM-clause entry for table	Sam Stearns	22:14
Re: invalid reference to FROM-clause entry for table	Tom Lane	22:21

Oct. 4, 2024

Thread	Author	Time
RE: invalid reference to FROM-clause entry for table	Adw Spe	13:27
Re: invalid reference to FROM-clause entry for table	Sam Stearns	15:12

Oct. 5, 2024

Thread	Author	Time
Re: invalid reference to FROM-clause entry for table	David G. Johnston	02:35

Oct. 15, 2024

Thread	Author	Time
Oracle ==> Postgres View 📎	Sam Stearns	21:30
Re: Oracle ==> Postgres View	David Rowley	21:46
Re: Oracle ==> Postgres View	William Alves Da Silva	21:49

Oct. 16, 2024

Thread	Author	Time
Re: Oracle ==> Postgres View	Sam Stearns	16:15
Postgres View DDL	Sam Stearns	21:33
Re: Postgres View DDL	Sam Stearns	21:42
Re: Postgres View DDL	David G. Johnston	21:47
Re: Postgres View DDL	William Alves Da Silva	22:04
Re: Postgres View DDL	Sam Stearns	23:07

Nov. 25, 2024

Thread	Author	Time
Inconsistent results for division and multiplication operations	szy	15:46
Re: Inconsistent results for division and multiplication operations	Erik Brandsberg	15:53
回复： Inconsistent results for division and multiplication operations	szy	16:12
Re: Inconsistent results for division and multiplication operations	Philip Semanchuk	16:23
Re: Inconsistent results for division and multiplication operations	Tom Lane	16:34

Nov. 26, 2024

Thread	Author	Time
Re: Inconsistent results for division and multiplication operations	Martin Norbäck Olivers	08:13

Dec. 3, 2024

Thread	Author	Time
Request for PostgreSQL Resources and Documentation	Suat Mollasalihoglu	11:54
Re: Request for PostgreSQL Resources and Documentation	Steve Midgley	19:30

Dec. 4, 2024

Thread	Author	Time
Re: Request for PostgreSQL Resources and Documentation	Andrew Cilia	06:40
Re: Request for PostgreSQL Resources and Documentation	Suat Mollasalihoglu	08:04
Re: Request for PostgreSQL Resources and Documentation	shammat	14:19
Clarification Needed on PostgreSQL Version Upgrade	Hamza Godil	19:16

Dec. 5, 2024

Thread	Author	Time
Re: Clarification Needed on PostgreSQL Version Upgrade	Steve Midgley	18:40

Dec. 8, 2024

Thread	Author	Time
What is the best way to do this in Postgres	kunwar singh	11:38
Re: What is the best way to do this in Postgres	David G. Johnston	15:26
Re: What is the best way to do this in Postgres 📎	Carl Sopchak	16:50
Re: What is the best way to do this in Postgres	Erik Brandsberg	17:06

Dec. 16, 2024

Thread	Author	Time
Abitity to identify the current iteration in a recursive SELECT (feature request)	sulfinu	10:21

Dec. 18, 2024

Thread	Author	Time
Re: Abitity to identify the current iteration in a recursive SELECT (feature request)	Greg Sabino Mullane	14:06

Dec. 19, 2024

Thread	Author	Time
Re: Abitity to identify the current iteration in a recursive SELECT (feature request)	sulfinu	09:16

Dec. 20, 2024

Thread	Author	Time
Re: Abitity to identify the current iteration in a recursive SELECT (feature request)	shammat	15:25

Jan. 2, 2025

Thread	Author	Time
View performance with implicit cast	Tomasz Szypowski	20:02

Jan. 4, 2025

Thread	Author	Time
Re: View performance with implicit cast	Tom Lane	18:37

Jan. 5, 2025

Thread	Author	Time
RE: View performance with implicit cast	Tomasz Szypowski	22:45

Jan. 7, 2025

Thread	Author	Time
RE: View performance with implicit cast	Zornoza Sanchez, Jose Blas	07:43
Re: View performance with implicit cast	Tom Lane	14:52
RE: View performance with implicit cast	Tomasz Szypowski	20:07
Re: View performance with implicit cast	Tom Lane	20:34

Feb. 12, 2025

Thread	Author	Time
Database Query to find content location	Tchouante, Merlin	21:05

March 31, 2025

Thread	Author	Time
Revoke Connect Privilege from Database not working	Ing. Marijo Kristo	15:26

April 1, 2025

Thread	Author	Time
Re: Revoke Connect Privilege from Database not working	Tom Lane	14:13
Re: Revoke Connect Privilege from Database not working	David G. Johnston	14:15

April 7, 2025

Thread	Author	Time
Aw:  Re: Revoke Connect Privilege from Database not working	Ing. Marijo Kristo	08:53
Re: Re: Revoke Connect Privilege from Database not working	David G. Johnston	13:42
Aw:  Re: Re: Revoke Connect Privilege from Database not working	Ing. Marijo Kristo	14:27
Re:   Re: Re: Revoke Connect Privilege from Database not working	David G. Johnston	15:37
Re:   Re: Re: Revoke Connect Privilege from Database not working	Tom Lane	16:06
Re:   Re: Re: Revoke Connect Privilege from Database not working	David G. Johnston	16:22

April 14, 2025

Thread	Author	Time
Detached partitioning tables with RF keys in latest minor version is changed	Shay Patel	19:25

April 25, 2025

Thread	Author	Time
default cardinality with non-existent value 📎	Igor Kustov	09:35
Re: default cardinality with non-existent value	Tom Lane	14:03

May 10, 2025

Thread	Author	Time
Re: Detached partitioning tables with RF keys in latest minor version is changed	Álvaro Herrera	19:13

May 21, 2025

Thread	Author	Time
Confirming precedence order of Default for GUCs	Manav Kumar	08:06
Re: Confirming precedence order of Default for GUCs	Tom Lane	13:35
Re: Confirming precedence order of Default for GUCs	David G. Johnston	13:52

May 24, 2025

Thread	Author	Time
Full Text Search German Date	Thorsten	07:51
Re: Full Text Search German Date	Tom Lane	14:37

June 27, 2025

Thread	Author	Time
Permission Denied on INSERT	Sam Stearns	15:11
Re: Permission Denied on INSERT	Tom Lane	15:26
Re: Permission Denied on INSERT	Sam Stearns	16:59

June 30, 2025

Thread	Author	Time
Re: Permission Denied on INSERT	DINESH NAIR	03:01
Re: Permission Denied on INSERT	Sam Stearns	14:36

Aug. 28, 2025

Thread	Author	Time
PostgreSQL Extension Hot-Reload Pattern (Using a Dummy "noop" Version)	Orwa Diraneyya	09:38

Oct. 28, 2025

Thread	Author	Time
Linux file permission for COPY TO SQL command	Krzysztof	19:39
Re: Linux file permission for COPY TO SQL command	Rob Sargent	23:03

Oct. 29, 2025

Thread	Author	Time
Re: Linux file permission for COPY TO SQL command	Roland Müller	16:12
Re: Linux file permission for COPY TO SQL command	Krzysztof	18:44

Browse Archives

Prev | Next