pgsql-general since 2023-02-23 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)
Advanced Search

Browse Archives

Prev | Next

Feb. 23, 2023

Thread Author Time
Re: Event Triggers unable to capture the DDL script executed Neethu P 04:10
Re: Event Triggers unable to capture the DDL script executed Laurenz Albe 10:50
Re: Event Triggers unable to capture the DDL script executed Neethu P 11:33
Re: Support logical replication of DDLs 📎 Ajin Cherian 11:42
Re: RLS without leakproof restrictions? Stephen Frost 16:47

Feb. 24, 2023

Thread Author Time
Re: Debugging postgres on Windows - could not open directory "/lib" Cathy Xie 01:16
Re: Support logical replication of DDLs Masahiko Sawada 08:42
Re: can't get psql authentication against Active Directory working Tomas Pospisek 14:21
Re: PostgreSQL optimizations for CoW FS Peter Eisentraut 16:13
Re: Debugging postgres on Windows - could not open directory "/lib" Adrian Klaver 16:59
curiosity in default column header Rob Sargent 20:47
Re: curiosity in default column header David G. Johnston 21:11
Re: can't get psql authentication against Active Directory working Stephen Frost 23:52

Feb. 25, 2023

Thread Author Time
IS as a binary operator david wheeler 10:38
Re: IS as a binary operator Tom Lane 16:54

Feb. 26, 2023

Thread Author Time
Give me details of some attributes!! [email protected] 14:29
Comparing Postgres logical replication to MySQL Siddharth Jain 20:28
Re: Give me details of some attributes!! Laurenz Albe 20:45

Feb. 27, 2023

Thread Author Time
Re: Event Triggers unable to capture the DDL script executed Neethu P 03:52
ERROR: unsupported Unicode escape sequence - in JSON-type column Jan Bilek 06:28
Interval in hours but not in days Leap second not taken into account PALAYRET Jacques 07:26
Re: Interval in hours but not in days Leap second not taken into account Laurenz Albe 08:23
Re: Interval in hours but not in days Leap second not taken into account PALAYRET Jacques 08:50
Re: Interval in hours but not in days Leap second not taken into account PALAYRET Jacques 10:28
Repear operations on 50 tables of the same schema? celati Laurent 11:53
Re: ERROR: unsupported Unicode escape sequence - in JSON-type column Laurenz Albe 12:13
Re: Event Triggers unable to capture the DDL script executed Laurenz Albe 12:14
Re: Repear operations on 50 tables of the same schema? Ron 14:31
Re: ERROR: unsupported Unicode escape sequence - in JSON-type column Erik Wienhold 15:17
pg_upgradecluster transfering only a portion of the data Dávid Suchan 15:44
Re: ERROR: unsupported Unicode escape sequence - in JSON-type column Tom Lane 16:12
Re: pg_upgradecluster transfering only a portion of the data Adrian Klaver 16:14
Re: pg_upgradecluster transfering only a portion of the data Tom Lane 16:36
Re: pg_upgradecluster transfering only a portion of the data Adrian Klaver 16:46
Re: pg_upgradecluster transfering only a portion of the data Tom Lane 16:48
Re: pg_upgradecluster transfering only a portion of the data Adrian Klaver 16:56
Re: pg_upgradecluster transfering only a portion of the data Adrian Klaver 16:58
Re: pg_upgradecluster transfering only a portion of the data Adrian Klaver 17:10
Re: pg_upgradecluster transfering only a portion of the data Dávid Suchan 17:18
Re: pg_upgradecluster transfering only a portion of the data Laurenz Albe 17:40
Re: pg_upgradecluster transfering only a portion of the data Adrian Klaver 17:44
Re: pg_upgradecluster transfering only a portion of the data Dávid Suchan 17:50
Re: pg_upgradecluster transfering only a portion of the data Dávid Suchan 17:54
Tempory table is not getting created inside Function in postgres. nikhil raj 19:10
pg_get_functiondef(), trailing spaces and + sign Ron 19:34
Re: pg_get_functiondef(), trailing spaces and + sign Adrian Klaver 19:38
Re: pg_get_functiondef(), trailing spaces and + sign Adrian Klaver 19:40
Re: Tempory table is not getting created inside Function in postgres. Adrian Klaver 19:47
Re: Tempory table is not getting created inside Function in postgres. Adrian Klaver 20:01
Re: Tempory table is not getting created inside Function in postgres. Tom Lane 20:04
Re: Tempory table is not getting created inside Function in postgres. nikhil raj 20:17
Re: Tempory table is not getting created inside Function in postgres. David G. Johnston 20:40
Re: pg_get_functiondef(), trailing spaces and + sign Kirk Wolak 22:40
DISTINCT *and* ORDER BY in aggregate functions on expressions(!) mirabilos 23:11

Feb. 28, 2023

Thread Author Time
Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!) Tom Lane 00:11
Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!) David G. Johnston 00:22
Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!) David G. Johnston 00:44
Re: ERROR: unsupported Unicode escape sequence - in JSON-type column Jan Bilek 00:55
Re: ERROR: unsupported Unicode escape sequence - in JSON-type column Jan Bilek 01:03
Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!) Thorsten Glaser 01:22
Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!) Tom Lane 01:32
Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!) David G. Johnston 01:48
Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!)y Thorsten Glaser 02:54
RE: Support logical replication of DDLs 📎 [email protected] 04:24
Re: DISTINCT *and* ORDER BY in aggregate functions on expressions(!)y Alban Hertroys 08:10
Re: Tempory table is not getting created inside Function in postgres. nikhil raj 09:54
Quit currently running query Albert Cornelius 10:53
13.x, stream replication and locale(?) issues Eugene M. Zheganin 11:08
Re: Quit currently running query Ian Lawrence Barwick 13:41
Re: Quit currently running query Ron 13:42
Move all elements toward another schema? celati Laurent 14:39
Re: 13.x, stream replication and locale(?) issues Tom Lane 15:21
Re: Quit currently running query Rob Sargent 15:38
Re: Move all elements toward another schema? David G. Johnston 16:44
Re: Move all elements toward another schema? Marcos Pegoraro 16:51
Re: Quit currently running query Peter J. Holzer 17:31
Re: Quit currently running query Ron 18:22
Re: 13.x, stream replication and locale(?) issues Thomas Munro 21:30

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? [email protected] 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 [email protected] 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 [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

Browse Archives

Prev | Next