pgsql-general since 2023-03-09 00:00

General discussion area for users. Apart from compile, acceptance test, and bug problems, most new users will probably only be interested in this mailing list (unless they want to contribute to development or documentation). All non-bug related questions regarding PostgreSQL's version of SQL, and all installation related questions that do not involve bugs or failed compiles, should be restricted to this area. Please note that many of the developers monitor this area.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

March 9, 2023

Thread Author Time
select (17, 42)::s.t2 into... fails with "invalid input syntax" Bryn Llewellyn 00:41
Re: select (17, 42)::s.t2 into... fails with "invalid input syntax" David G. Johnston 00:50
Re: select (17, 42)::s.t2 into... fails with "invalid input syntax" Tom Lane 02:26
RE: Support logical replication of DDLs [email protected] 02:26
Re: select (17, 42)::s.t2 into... fails with "invalid input syntax" Bryn Llewellyn 02:58
Blog post series on commitfests and patches Chris Travers 03:24
Re: select (17, 42)::s.t2 into... fails with "invalid input syntax" David G. Johnston 03:28
Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses Pavel Stehule 04:53
crosstab Rosebrock, Uwe (Environment, Hobart) 06:07
public schema grants to PUBLIC role Dominique Devienne 09:34
RE: Support logical replication of DDLs 📎 [email protected] 09:58
RE: Support logical replication of DDLs [email protected] 09:58
Re: public schema grants to PUBLIC role Christoph Moench-Tegeder 11:35
RE: Blog post series on commitfests and patches Tim Clarke 12:14
Re: public schema grants to PUBLIC role Laurenz Albe 13:13
Re: crosstab David G. Johnston 13:22
find coumn name and his type with greatest size in bytes Алексей Ефимов 14:45
Re: public schema grants to PUBLIC role Dominique Devienne 15:18
Re: select (17, 42)::s.t2 into... fails with "invalid input syntax" Bryn Llewellyn 19:46
Re: select (17, 42)::s.t2 into... fails with "invalid input syntax" David G. Johnston 21:24

March 10, 2023

Thread Author Time
Onfly, function generated ID for Select Query Durumdara 07:12
SV: Onfly, function generated ID for Select Query Gustavsson Mikael 07:33
Get more columns from a lookup type subselect Durumdara 07:34
Re: Onfly, function generated ID for Select Query Durumdara 07:41
SV: Onfly, function generated ID for Select Query Gustavsson Mikael 07:48
Re: Get more columns from a lookup type subselect negora 08:43
Re: Get more columns from a lookup type subselect Durumdara 10:00
Re: Support logical replication of DDLs 📎 vignesh C 10:28
Re: Get more columns from a lookup type subselect negora 11:09
Re: can't get psql authentication against Active Directory working Tomas Pospisek 15:59
Re: select (17, 42)::s.t2 into... fails with "invalid input syntax" Bryn Llewellyn 20:29
Re: select (17, 42)::s.t2 into... fails with "invalid input syntax" David G. Johnston 20:46
Practice advice for use of %type in declaring a subprogram's formal arguments Bryn Llewellyn 21:28
Re: Practice advice for use of %type in declaring a subprogram's formal arguments David G. Johnston 21:53
Re: Support logical replication of DDLs 📎 Runqi Tian 22:41
Re: Practice advice for use of %type in declaring a subprogram's formal arguments Ron 22:49

March 11, 2023

Thread Author Time
Idea: Add first() and last() aggregate functions to the main release Ben Clements 12:20
ERROR: only immutable functions supported in continuous aggregate view Martijn de Munnik 14:04
Re: ERROR: only immutable functions supported in continuous aggregate view Tom Lane 15:47
confusion between max_standby_archive_delay, max_standby_archive_delay and max_standby_archive_delay Atul Kumar 20:23
Re: confusion between max_standby_archive_delay, max_standby_archive_delay and max_standby_archive_delay Ron 20:54
Re: Idea: Add first() and last() aggregate functions to the main release Erwin Brandstetter 23:49

March 12, 2023

Thread Author Time
Re: ERROR: only immutable functions supported in continuous aggregate view Martijn de Munnik 08:49
Re: confusion between max_standby_archive_delay, max_standby_archive_delay and max_standby_archive_delay Laurenz Albe 14:01
Re: Support logical replication of DDLs 📎 Zheng Li 15:24
Re: confusion between max_standby_archive_delay, max_standby_archive_delay and max_standby_archive_delay Ron 17:00
Re: confusion between max_standby_archive_delay, max_standby_archive_delay and max_standby_archive_delay Laurenz Albe 18:04
Help? Unexpected PostgreSQL compilation failure using generic compile script Martin Goodson 21:43
Re: Help? Unexpected PostgreSQL compilation failure using generic compile script Tom Lane 21:52
Re: Help? Unexpected PostgreSQL compilation failure using generic compile script Martin Goodson 22:01

March 13, 2023

Thread Author Time
Re: Help? Unexpected PostgreSQL compilation failure using generic compile script Adrian Klaver 00:02
Re: Practice advice for use of %type in declaring a subprogram's formal arguments Bryn Llewellyn 00:36
Re: can't get psql authentication against Active Directory working Stephen Frost 00:43
Seq Scan because of stats or because of cast? Dominique Devienne 09:07
Re: Seq Scan because of stats or because of cast? Tom Lane 13:53
Binary large object processing problems Raivo Rebane 15:00
Re: Binary large object processing problems Christoph Moench-Tegeder 15:26
Re: Binary large object processing problems Raivo Rebane 15:54
Re: Binary large object processing problems Tom Lane 16:18
Issues Scaling Postgres Concurrency Harrison Borges 16:24
Properly handle OOM death? Israel Brewster 17:21
Re: Properly handle OOM death? Adrian Klaver 17:28
Re: Properly handle OOM death? Israel Brewster 17:36
Re: Properly handle OOM death? Joe Conway 17:36
Re: Properly handle OOM death? Israel Brewster 17:41
Re: Properly handle OOM death? Peter J. Holzer 17:43
Re: Properly handle OOM death? Israel Brewster 17:55
Re: Properly handle OOM death? Joe Conway 18:37
Re: Properly handle OOM death? Israel Brewster 18:50
Re: Properly handle OOM death? Joe Conway 19:10
Re: Binary large object processing problems Raivo Rebane 19:11
Re: Properly handle OOM death? Israel Brewster 19:18
Re: Properly handle OOM death? Jeffrey Walton 19:36
Re: Properly handle OOM death? Joe Conway 19:42
Re: Properly handle OOM death? Peter J. Holzer 20:16
Re: Properly handle OOM death? Israel Brewster 20:18
Re: Properly handle OOM death? Joe Conway 20:25
Re: Properly handle OOM death? Israel Brewster 20:27
Re: Properly handle OOM death? Israel Brewster 20:29
Uppercase version of ß desired Celia McInnis 21:38
Using GSSAPI/Kerbros/Active Directory: want the database user name to be the full name including the realm name without specifying the user Michael Downey 22:12
Re: Uppercase version of ß desired Peter J. Holzer 22:45
Re: Uppercase version of ß desired Tom Lane 22:54

March 14, 2023

Thread Author Time
Re: Idea: PostgreSQL equivalent to Oracle's KEEP clause Ben Clements 03:07
Re: Support logical replication of DDLs 📎 Ajin Cherian 04:17
Re: Uppercase version of ß desired Celia McInnis 06:53
Problems connecting to the server Arsen Deputat 07:23
Re: Seq Scan because of stats or because of cast? Dominique Devienne 07:49
Re: Idea: PostgreSQL equivalent to Oracle's KEEP clause Alban Hertroys 08:01
Re: Uppercase version of ß desired Thorsten Glaser 09:27
Re: Idea: PostgreSQL equivalent to Oracle's KEEP clause David Rowley 09:29
Re: Idea: PostgreSQL equivalent to Oracle's KEEP clause David Rowley 09:35
Re: Uppercase version of ß desired Philip Semanchuk 13:12
Re: Uppercase version of ß desired Kip Cole 13:20
Re: Uppercase version of ß desired Celia McInnis 14:19
Re: Seq Scan because of stats or because of cast? Dominique Devienne 14:56
Re: Problems connecting to the server Adrian Klaver 17:24
Re: Issues Scaling Postgres Concurrency Adrian Klaver 17:34
Re: Issues Scaling Postgres Concurrency Alan Hodgson 18:01
Re: Issues Scaling Postgres Concurrency Laurenz Albe 21:47
Re: Issues Scaling Postgres Concurrency Peter J. Holzer 22:05
Re: Issues Scaling Postgres Concurrency Tom Lane 22:57

March 15, 2023

Thread Author Time
Is the PL/pgSQL refcursor useful in a modern three-tier app? Bryn Llewellyn 00:50
Re: Is the PL/pgSQL refcursor useful in a modern three-tier app? Adrian Klaver 02:09
Re: Is the PL/pgSQL refcursor useful in a modern three-tier app? Bryn Llewellyn 03:29
Re: Is the PL/pgSQL refcursor useful in a modern three-tier app? Adrian Klaver 04:30
Re: Is the PL/pgSQL refcursor useful in a modern three-tier app? Laurenz Albe 07:28
odd (maybe) procedure cacheing behaviour Tim.Colles 09:02
pg_upgrade Only the install user can be defined in the new cluster Dávid Suchan 09:30
Re: pg_upgrade Only the install user can be defined in the new cluster Daniel Gustafsson 12:27
Re: pg_upgrade Only the install user can be defined in the new cluster Dávid Suchan 13:48
Re: pg_upgrade Only the install user can be defined in the new cluster Daniel Gustafsson 13:48
Removing trailing zeros (decimal places) from a numeric (pre trim_scale()) with unexpected behaviour magog002 13:51
Table scan on 15.2 Arthur Ramsey 15:17
Re: Table scan on 15.2 Adrian Klaver 15:20
Re: pg_upgrade Only the install user can be defined in the new cluster Dávid Suchan 15:39
Re: Table scan on 15.2 Arthur Ramsey 15:53
How to behive if I remove password from postgres role Raivo Rebane 16:02
Re: Table scan on 15.2 Tom Lane 16:03
Re: Table scan on 15.2 Arthur Ramsey 16:10
Re: How to behive if I remove password from postgres role Adrian Klaver 16:12
Re: How to behive if I remove password from postgres role Tom Lane 16:12
Re: Table scan on 15.2 Tom Lane 16:18
Re: Table scan on 15.2 Arthur Ramsey 16:24
Re: Removing trailing zeros (decimal places) from a numeric (pre trim_scale()) with unexpected behaviour Erik Wienhold 16:50
Numeric Division - Result Scale Calculation Oddity David G. Johnston 17:19
uuid-ossp source or binaries for Windows Mark Hill 18:31
Re: Table scan on 15.2 Arthur Ramsey 18:35
Re: uuid-ossp source or binaries for Windows Daniel Gustafsson 19:15
Re: Is the PL/pgSQL refcursor useful in a modern three-tier app? Bryn Llewellyn 20:37
Re: Is the PL/pgSQL refcursor useful in a modern three-tier app? Adrian Klaver 21:00
Re: Is the PL/pgSQL refcursor useful in a modern three-tier app? Bryn Llewellyn 22:09
Re: Help? Unexpected PostgreSQL compilation failure using generic compile script Martin Goodson 23:47

March 16, 2023

Thread Author Time
Re: Is the PL/pgSQL refcursor useful in a modern three-tier app? Bryn Llewellyn 01:41
"No Free extents", table using all allocated space but no rows! Dolan, Sean 01:58
RE: Support logical replication of DDLs [email protected] 02:43
RE: uuid-ossp source or binaries for Windows Mark Hill 03:14
Re: "No Free extents", table using all allocated space but no rows! Laurenz Albe 05:45
Re: Is the PL/pgSQL refcursor useful in a modern three-tier app? Laurenz Albe 05:48
Re: valgrind a background worker Jon Erdman 06:38
Re: Is the PL/pgSQL refcursor useful in a modern three-tier app? Dominique Devienne 08:17
Re: Is the PL/pgSQL refcursor useful in a modern three-tier app? Pavel Stehule 08:23
Re: Is the PL/pgSQL refcursor useful in a modern three-tier app? Dominique Devienne 08:55
Re: pg_upgrade Only the install user can be defined in the new cluster Daniel Gustafsson 09:28
Re: Is the PL/pgSQL refcursor useful in a modern three-tier app? Pavel Stehule 10:15
Re: Is the PL/pgSQL refcursor useful in a modern three-tier app? Dominique Devienne 10:52
Re: Is the PL/pgSQL refcursor useful in a modern three-tier app? Pavel Stehule 11:45
Aw: Re: Removing trailing zeros (decimal places) from a numeric (pre trim_scale()) with unexpected behaviour magog002 12:57
RE: EXTERNAL: Re: "No Free extents", table using all allocated space but no rows! Dolan, Sean 13:20
FW: uuid-ossp source or binaries for Windows Mark Hill 13:31
Re: pg_upgrade Only the install user can be defined in the new cluster Dávid Suchan 14:56
Re: Is the PL/pgSQL refcursor useful in a modern three-tier app? Adrian Klaver 17:05
Re: pg_upgrade Only the install user can be defined in the new cluster Tom Lane 18:24
Re: pg_upgrade Only the install user can be defined in the new cluster Daniel Gustafsson 19:14
Re: EXTERNAL: Re: "No Free extents", table using all allocated space but no rows! Laurenz Albe 19:24
Many logical replication synchronization worker threads kicking off for ONE table Dolan, Sean 20:38

March 17, 2023

Thread Author Time
src/test/examples/testlibpq2.c where the HAVE_SYS_SELECT_H is defined. jian he 06:47
Delete values from JSON Andreas Joseph Krogh 07:56
nested xml/json to table Wim Bertels 10:05
Re: nested xml/json to table 📎 Thomas Kellerer 10:21
Re: src/test/examples/testlibpq2.c where the HAVE_SYS_SELECT_H is defined. Thomas Munro 10:26
Re: Delete values from JSON 📎 Romain MAZIÈRE 10:56
Re: nested xml/json to table Wim Bertels 11:04
Re: Delete values from JSON Andreas Joseph Krogh 11:06
RE: Support logical replication of DDLs Takamichi Osumi (Fujitsu) 14:49
Re: Support logical replication of DDLs 📎 Zheng Li 15:40
Re: src/test/examples/testlibpq2.c where the HAVE_SYS_SELECT_H is defined. jian he 16:42
Re: Is the PL/pgSQL refcursor useful in a modern three-tier app? Peter J. Holzer 23:15
Re: EXTERNAL: Re: "No Free extents", table using all allocated space but no rows! Peter J. Holzer 23:37

March 18, 2023

Thread Author Time
Can't connect to server Wu, Abigaile 06:10
Re: Can't connect to server Romain Mazière - SIGMAZ Consilium 08:12
Re: Delete values from JSON Boris Zentner 13:26
Re: Can't connect to server Adrian Klaver 14:25
Re: Delete values from JSON Andreas Joseph Krogh 17:07
Getting error while upgrading postgres from version 12 to 13 shashidhar Reddy 20:39
Re: Getting error while upgrading postgres from version 12 to 13 Ron 20:43
Re: Getting error while upgrading postgres from version 12 to 13 shashidhar Reddy 21:24
Re: Getting error while upgrading postgres from version 12 to 13 Tomas Pospisek 21:26
Re: Getting error while upgrading postgres from version 12 to 13 Tomas Pospisek 21:30
Re: Can't connect to server Jeff Janes 21:30
Re: Properly handle OOM death? Tomas Pospisek 22:02
Re: Properly handle OOM death? Jeffrey Walton 23:13

March 19, 2023

Thread Author Time
Re: Getting error while upgrading postgres from version 12 to 13 shashidhar Reddy 02:26
Re: Getting error while upgrading postgres from version 12 to 13 Adrian Klaver 04:15
Re: Getting error while upgrading postgres from version 12 to 13 David G. Johnston 05:59
Re: Properly handle OOM death? Joe Conway 13:41

March 20, 2023

Thread Author Time
Re[2]: Getting error while upgrading postgres from version 12 to 13 abdulsayeed24 05:37
RE: Support logical replication of DDLs 📎 [email protected] 09:17
NULL pg_database.datacl Dominique Devienne 10:52
Re: pg_upgrade Only the install user can be defined in the new cluster Dávid Suchan 11:58
Re: NULL pg_database.datacl Erik Wienhold 12:18
Logical replication fails when adding multiple replicas Will Roper 12:46
Re: NULL pg_database.datacl Dominique Devienne 12:50
Oracle to PostgreSQL Migration Inzamam Shafiq 12:57
Re: NULL pg_database.datacl Erik Wienhold 13:18
Re: NULL pg_database.datacl Dominique Devienne 13:41
Re: pg_upgrade Only the install user can be defined in the new cluster David G. Johnston 13:57
Re: pg_upgrade Only the install user can be defined in the new cluster Dávid Suchan 14:02
Re: pg_upgrade Only the install user can be defined in the new cluster David G. Johnston 14:08
Re: Oracle to PostgreSQL Migration Ron Johnson 14:15

Browse Archives

Prev | Next