pgsql-general - March 2023

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)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

March 1, 2023

Thread Author Time
Re: Interval in hours but not in days Leap second not taken into account Thomas Munro 01:29
Failed upgrade from 12.11 to 14.4 Arthur Ramsey 16:32
Re: Failed upgrade from 12.11 to 14.4 Tom Lane 19:54
Re: Failed upgrade from 12.11 to 14.4 Arthur Ramsey 23:27

March 2, 2023

Thread Author Time
Postgres Index and Updates Navindren Baskaran 07:53
Re: Postgres Index and Updates Laurenz Albe 09:07
Re: Postgres Index and Updates Dominique Devienne 09:58
Getting the exact SQL from inside an event trigger Joe Wildish 11:12
Re: Getting the exact SQL from inside an event trigger hubert depesz lubaczewski 12:29
Re: Getting the exact SQL from inside an event trigger Joe Wildish 13:01
Re: Postgres undeterministically uses a bad plan, how to convince it otherwise? cen 13:20
Dropping behavior for unique CONSTRAINTs Conner Bean 20:30
Converting row elements into a arrays? Ron 20:58
Re: Converting row elements into a arrays? Ray O'Donnell 21:01
Re: Converting row elements into a arrays? Ray O'Donnell 21:02
Re: Converting row elements into a arrays? David G. Johnston 21:34
Re: Converting row elements into a arrays? Rob Sargent 21:45
Re: Converting row elements into a arrays? Ron 21:46
Re: Converting row elements into a arrays? Ron 21:49
Re: Converting row elements into a arrays? Ron 21:57
Re: Converting row elements into a arrays? Rob Sargent 22:10
Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!)y Thorsten Glaser 23:02
Re: Postgres undeterministically uses a bad plan, how to convince it otherwise? Kirk Wolak 23:07

March 3, 2023

Thread Author Time
Re: Postgres undeterministically uses a bad plan, how to convince it otherwise? David Rowley 03:38
Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!)y Alban Hertroys 08:31
Re: Postgres undeterministically uses a bad plan, how to convince it otherwise? cen 09:35
Re: Postgres undeterministically uses a bad plan, how to convince it otherwise? David Rowley 10:29
PG16devel - vacuum_freeze_table_age seems not being taken into account Simon Elbaz 10:43
Re: Dropping behavior for unique CONSTRAINTs David Rowley 10:54
Re: PG16devel - vacuum_freeze_table_age seems not being taken into account David Rowley 11:01
Re: PG16devel - vacuum_freeze_table_age seems not being taken into account Simon Elbaz 11:25
Re: Dropping behavior for unique CONSTRAINTs Conner Bean 14:44
Re: PG16devel - vacuum_freeze_table_age seems not being taken into account Peter Geoghegan 18:09
Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!)y Thorsten Glaser 19:32
Re: Converting row elements into a arrays? Merlin Moncure 20:51
Re: Dropping behavior for unique CONSTRAINTs Ron 21:55
Re: 13.x, stream replication and locale(?) issues Thomas Munro 23:01

March 4, 2023

Thread Author Time
Re: Dropping behavior for unique CONSTRAINTs David Rowley 00:50
Re: Converting row elements into a arrays? Pavel Stehule 06:01
Re: Dropping behavior for unique CONSTRAINTs Peter J. Holzer 08:03
Re: Dropping behavior for unique CONSTRAINTs Peter J. Holzer 08:09
Re: Dropping behavior for unique CONSTRAINTs Ron 08:34
Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!)y Alban Hertroys 10:48
Re: Dropping behavior for unique CONSTRAINTs Peter J. Holzer 11:51
shp2pgsql generates fake fail full of zeroes 📎 Raivo Rebane 15:33
shp2pgsql error under windows Raivo Rebane 15:53
Re: shp2pgsql error under windows Christoph Moench-Tegeder 16:05
Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!)y Thorsten Glaser 20:00
Re: Dropping behavior for unique CONSTRAINTs Ron 22:01

March 5, 2023

Thread Author Time
psql \set variables in crosstab queries? Ron 00:20
Re: psql \set variables in crosstab queries? Tom Lane 01:22
Re: psql \set variables in crosstab queries? David G. Johnston 01:32
Re: psql \set variables in crosstab queries? Ron 05:03
Re: psql \set variables in crosstab queries? Ron 05:05
Re: psql \set variables in crosstab queries? David G. Johnston 05:15
what's hsitoric MVCC Snapshot? jacktby@gmail.com 14:49
Re: what's hsitoric MVCC Snapshot? Adrian Klaver 15:58
Re: what's hsitoric MVCC Snapshot? Adrian Klaver 16:00

March 6, 2023

Thread Author Time
Row Level Security Policy Name in Error Message Louis Tian 00:18
Re: Support logical replication of DDLs 📎 Ajin Cherian 06:34
RE: Support logical replication of DDLs wangw.fnst@fujitsu.com 10:16
Re: Row Level Security Policy Name in Error Message Daniel Gustafsson 11:19
Re: Support logical replication of DDLs vignesh C 13:13
CREATE/DROP ROLE transactional? GRANT/REVOKE? Dominique Devienne 13:19
Re: CREATE/DROP ROLE transactional? GRANT/REVOKE? Erik Wienhold 14:02
Re: CREATE/DROP ROLE transactional? GRANT/REVOKE? Tom Lane 15:06
Re: CREATE/DROP ROLE transactional? GRANT/REVOKE? Dominique Devienne 15:25
Re: CREATE/DROP ROLE transactional? GRANT/REVOKE? Tom Lane 15:31
Re: CREATE/DROP ROLE transactional? GRANT/REVOKE? Dominique Devienne 15:34
Re: CREATE/DROP ROLE transactional? GRANT/REVOKE? Dominique Devienne 15:39
garbage data back Brad White 20:17
Re: garbage data back Adrian Klaver 20:23
Re: garbage data back David G. Johnston 20:29
Re: Support logical replication of DDLs Zheng Li 20:37
Fwd: garbage data back Brad White 20:48
Re: garbage data back David G. Johnston 20:54
Re: Fwd: garbage data back Adrian Klaver 20:59
Re: garbage data back Brad White 21:27
Re: garbage data back Adrian Klaver 21:56
Idea: PostgreSQL equivalent to Oracle's KEEP clause Ben Clements 22:06
Re: Idea: PostgreSQL equivalent to Oracle's KEEP clause Tom Lane 23:40

March 7, 2023

Thread Author Time
How does Postgres store a B-Tree on disk while using the OS file system? Siddharth Jain 00:24
Re: How does Postgres store a B-Tree on disk while using the OS file system? Ron 00:49
Re: How does Postgres store a B-Tree on disk while using the OS file system? Christophe Pettus 01:07
Re: Idea: PostgreSQL equivalent to Oracle's KEEP clause David Rowley 02:51
Re: How does Postgres store a B-Tree on disk while using the OS file system? Siddharth Jain 02:53
Re: Idea: PostgreSQL equivalent to Oracle's KEEP clause David G. Johnston 03:11
Re: Idea: PostgreSQL equivalent to Oracle's KEEP clause David Rowley 03:46
Multiple core dump errors are thrown by initdb when Huge pages are enabled in OS and huge_pages is set to “off” in postgresql.conf.sample in Kubernetes. M Tarkeshwar Rao 05:44
Re: Multiple core dump errors are thrown by initdb when Huge pages are enabled in OS and huge_pages is set to “off” in postgresql.conf.sample in Kubernetes. Julien Rouhaud 07:00
escape vs. bytea in config Mathias Mayrhofer 10:53
Re: escape vs. bytea in config Laurenz Albe 12:35
Re: escape vs. bytea in config Peter J. Holzer 12:53
psql \conninfo in tabular form? Ron 17:58
Re: psql \conninfo in tabular form? Erik Wienhold 19:07
Re: garbage data back Brad White 19:30
Behavior of PL/pgSQL function following drop and re-create of a table that it uses Bryn Llewellyn 20:24
Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses David G. Johnston 21:25

March 8, 2023

Thread Author Time
Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses Bryn Llewellyn 00:52
Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses David G. Johnston 01:03
could not bind IPv4 address "127.0.0.1": Address already in use Siddharth Jain 01:28
Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses David G. Johnston 04:25
Fwd: Behavior of PL/pgSQL function following drop and re-create of a table that it uses David G. Johnston 04:26
Re: could not bind IPv4 address "127.0.0.1": Address already in use Tom Lane 04:28
Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses Tom Lane 04:49
Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses David G. Johnston 04:56
Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses Bryn Llewellyn 05:19
Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses David G. Johnston 05:27
Re: could not bind IPv4 address "127.0.0.1": Address already in use Siddharth Jain 16:45
Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses Bryn Llewellyn 21:29
Re: Behavior of PL/pgSQL function following drop and re-create of a table that it uses Ron 23:20

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 wangw.fnst@fujitsu.com 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 📎 houzj.fnst@fujitsu.com 09:58
RE: Support logical replication of DDLs houzj.fnst@fujitsu.com 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

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31