pgsql-general - September 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

Sept. 1, 2023

Thread Author Time
Re: [EXTERNAL] Oracle FDW version Jethro Elmer Sanidad 03:05
Re: PG FDW query fails, works local, same credentials Pete O'Such 07:10
Taking too much time to fetch the data from Azure postgreSQL Large objects (pg_largeobjects) Sai Teja 14:22
Re: Taking too much time to fetch the data from Azure postgreSQL Large objects (pg_largeobjects) Adrian Klaver 14:42
Strategy for migrating from Oracle to PG Johnson, Bruce E - (bjohnson) 22:22

Sept. 2, 2023

Thread Author Time
Question on Partition key veem v 22:35
Re: Question on Partition key Erik Wienhold 23:50

Sept. 3, 2023

Thread Author Time
Re: Question on Partition key Deep 08:32
Re: Question on Partition key veem v 10:52
PSQL = Yes ... JDBC = no ?? Amn Ojee Uw 16:00
Re: PSQL = Yes ... JDBC = no ?? Adrian Klaver 16:04
Re: PSQL = Yes ... JDBC = no ?? Amn Ojee Uw 22:25
Re: PSQL = Yes ... JDBC = no ?? Maciek Sakrejda 23:46
Re: PSQL = Yes ... JDBC = no ?? Adrian Klaver 23:46

Sept. 4, 2023

Thread Author Time
Re: PSQL = Yes ... JDBC = no ?? David G. Johnston 00:12
Re: PSQL = Yes ... JDBC = no ?? Amn Ojee Uw 00:19
Re: createuser unexpectedly creates superuser with createdb and createrole 📎 Erik Wienhold 01:32
Re: createuser unexpectedly creates superuser with createdb and createrole Tom Lane 01:42
Re: [EXTERNAL] Oracle FDW version Jethro Elmer Sanidad 05:16
Re: PSQL = Yes ... JDBC = no ?? Peter J. Holzer 06:15
Re: Question on Partition key David Rowley 09:01
Re: pg_dump/pg_restore and the magic of the search_path Arthur Bazin 09:05
rollback to savepoint issue Lorusso Domenico 09:51
Efficient Partitioning Strategies for PostgreSQL Table with KSUID and High Volume wheels 10:15
Re: rollback to savepoint issue Erik Wienhold 12:45
Re: rollback to savepoint issue Dominique Devienne 14:22
Re: [EXTERNAL] Oracle FDW version Adam Lee 14:31
Re: rollback to savepoint issue Dominique Devienne 14:32
Re: rollback to savepoint issue David G. Johnston 14:56
Re: rollback to savepoint issue Tom Lane 14:58
Re: rollback to savepoint issue Adrian Klaver 15:12
Re: rollback to savepoint issue Erik Wienhold 15:22
Array vs Temporary table vs Normal Table + truncate at end Lorusso Domenico 16:42
Re: createuser unexpectedly creates superuser with createdb and createrole 📎 Erik Wienhold 22:03

Sept. 5, 2023

Thread Author Time
Re: createuser unexpectedly creates superuser with createdb and createrole Laurenz Albe 01:56
Re: Array vs Temporary table vs Normal Table + truncate at end Laurenz Albe 02:01
Re: Will PostgreSQL 16 supports native transparent data encryption ? Matthias Apitz 09:21
./configure doesn't make effect? jacktby jacktby 11:41
Re: rollback to savepoint issue Alvaro Herrera 12:01
Re: ./configure doesn't make effect? Erik Wienhold 12:22
Re: ./configure doesn't make effect? David G. Johnston 13:01
Re: ./configure doesn't make effect? jacktby jacktby 13:07
Re: rollback to savepoint issue Tom Lane 13:19
Re: ./configure doesn't make effect? Adrian Klaver 14:36
Re: Strategy for migrating from Oracle to PG Deep 15:26
Re: Efficient Partitioning Strategies for PostgreSQL Table with KSUID and High Volume Lorusso Domenico 22:37

Sept. 6, 2023

Thread Author Time
running ANALYZE results in => duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index" Torsten Krah 07:46
Postgres partition max limit Daulat 08:05
Re: Postgres partition max limit Laurenz Albe 08:11
Re: running ANALYZE results in => duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index" Laurenz Albe 08:21
Re: running ANALYZE results in => duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index" Torsten Krah 08:33
Re: running ANALYZE results in => duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index" Laurenz Albe 09:56
Re: running ANALYZE results in => duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index" Erik Wienhold 10:04
Re: running ANALYZE results in => duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index" Torsten Krah 10:31
Pgbackrest Restore Error - Segmentation fault (core dumped) pgdba pgdba 11:08
Re: Postgres partition max limit Chris Travers 11:10
Re: Pgbackrest Restore Error - Segmentation fault (core dumped) Daniel Gustafsson 12:15
Re: Pgbackrest Restore Error - Segmentation fault (core dumped) Rob Sargent 13:32
postgreSQL UPPER Method is converting the character "µ" into "M" Sai Teja 13:42
Re: postgreSQL UPPER Method is converting the character "µ" into "M" Tom Lane 13:53
Re: postgreSQL UPPER Method is converting the character "µ" into "M" Sai Teja 14:04
Re: postgreSQL UPPER Method is converting the character "µ" into "M" Laurenz Albe 14:21
Re: postgreSQL UPPER Method is converting the character "µ" into "M" Erik Wienhold 14:23
Q: inet operators for IPv4 encapsulated in IPv6 Albrecht Dreß 14:51
Re: postgreSQL UPPER Method is converting the character "µ" into "M" Helmut Bender 15:22
Re: postgreSQL UPPER Method is converting the character "µ" into "M" Francisco Olarte 15:29
Re: postgreSQL UPPER Method is converting the character "µ" into "M" Sai Teja 16:04
Re: postgreSQL UPPER Method is converting the character "µ" into "M" Erik Wienhold 16:37
Re: postgreSQL UPPER Method is converting the character "µ" into "M" Erik Wienhold 16:47
Re: postgreSQL UPPER Method is converting the character "µ" into "M" Sai Teja 17:09
Ynt: Pgbackrest Restore Error - Segmentation fault (core dumped) pgdba pgdba 17:27
Re: Q: inet operators for IPv4 encapsulated in IPv6 Erik Wienhold 17:41
Re: Q: inet operators for IPv4 encapsulated in IPv6 Albrecht Dreß 18:32
Re: running ANALYZE results in => duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index" Imre Samu 18:42
listening on an address other than 'localhost'? Johnson, Bruce E - (bjohnson) 19:23
Re: Ynt: Pgbackrest Restore Error - Segmentation fault (core dumped) Rob Sargent 19:31
Re: postgreSQL UPPER Method is converting the character "µ" into "M" Jehan-Guillaume de Rorthais 19:39
Query performance going from Oracle to Postgres Dirschel, Steve 20:06
Re: Query performance going from Oracle to Postgres Laurenz Albe 21:14

Sept. 7, 2023

Thread Author Time
Re: Query performance going from Oracle to Postgres David Rowley 02:28
Re: Query performance going from Oracle to Postgres Peter Geoghegan 03:07
Re: listening on an address other than 'localhost'? Daniel Gustafsson 07:22
Re: listening on an address other than 'localhost'? Erik Wienhold 07:23
ERROR: stack depth limit exceeded gzh 07:45
Re: Query performance going from Oracle to Postgres David Rowley 10:48
Re: postgreSQL UPPER Method is converting the character "µ" into "M" Joe Conway 12:44
Re: ERROR: stack depth limit exceeded Tom Lane 13:29
Re: ERROR: stack depth limit exceeded Geoff Winkless 13:46
Feedback on supporting AI queries in Postgres with EvaDB Arulraj, Joy 14:12
Re: listening on an address other than 'localhost'? Adrian Klaver 14:47
Re: Will PostgreSQL 16 supports native transparent data encryption ? Stephen Frost 16:31
Re: Will PostgreSQL 16 supports native transparent data encryption ? Stephen Frost 16:33
Only getting few records inserted from millions 📎 Anthony Apollis 17:14
Huge input lookup exception when trying to create the index for XML data type column in postgreSQL Sai Teja 17:28
Re: Only getting few records inserted from millions Erik Wienhold 17:39
Re: Huge input lookup exception when trying to create the index for XML data type column in postgreSQL Tom Lane 19:09
Re: Huge input lookup exception when trying to create the index for XML data type column in postgreSQL Erik Wienhold 19:37
Re: Huge input lookup exception when trying to create the index for XML data type column in postgreSQL David G. Johnston 19:56
Re: Huge input lookup exception when trying to create the index for XML data type column in postgreSQL Tom Lane 20:21

Sept. 8, 2023

Thread Author Time
Re: Query performance going from Oracle to Postgres Peter Geoghegan 01:22
Re: ERROR: stack depth limit exceeded gzh 03:32
Re: Huge input lookup exception when trying to create the index for XML data type column in postgreSQL Sai Teja 05:51
pg_restore unexpected end of file Les 06:29
Re: ERROR: stack depth limit exceeded Laurenz Albe 06:40
Re: running ANALYZE results in => duplicate key value violates unique constraint "pg_statistic_relid_att_inh_index" Torsten Krah 07:22
Re: Will PostgreSQL 16 supports native transparent data encryption ? Matthias Apitz 08:26
Re: Huge input lookup exception when trying to create the index for XML data type column in postgreSQL Dominique Devienne 09:39
Re: Huge input lookup exception when trying to create the index for XML data type column in postgreSQL Dominique Devienne 09:45
Is data import from Oracle table to Postgres table in Ora2pg consecutive or random? duc hiep ha 10:19
Re: Huge input lookup exception when trying to create the index for XML data type column in postgreSQL Rob Sargent 11:07
Even if I have a lot of free space PgSQL returns "ERROR: could not extend file - No space left on device" Nature Conservation Geovista Space 11:25
Re: ERROR: stack depth limit exceeded Tom Lane 13:53
Re: Even if I have a lot of free space PgSQL returns "ERROR: could not extend file - No space left on device" Adrian Klaver 15:27
Re: pg_restore unexpected end of file Adrian Klaver 15:40
pgsql --echo-errors --quiet and setval Les 19:36
Re: pgsql --echo-errors --quiet and setval Adrian Klaver 20:11
Re: pgsql --echo-errors --quiet and setval David G. Johnston 22:01

Sept. 9, 2023

Thread Author Time
Re: postgreSQL UPPER Method is converting the character "µ" into "M" Peter J. Holzer 07:31
Re: postgreSQL UPPER Method is converting the character "µ" into "M" Peter J. Holzer 07:34
Re: Even if I have a lot of free space PgSQL returns "ERROR: could not extend file - No space left on device" Alban Hertroys 09:33

Sept. 10, 2023

Thread Author Time
Re: pgsql --echo-errors --quiet and setval Tom Lane 17:43
Re: pgsql --echo-errors --quiet and setval David G. Johnston 17:50

Sept. 11, 2023

Thread Author Time
Re: ERROR: stack depth limit exceeded gzh 04:57
Can't drop logical replication slot Eduardo Gargiulo 13:55
Making Sure Primary and Secondary Keys Alligns Anthony Apollis 14:09
Re: Making Sure Primary and Secondary Keys Alligns Alban Hertroys 15:33
Upgrade problem Graeme 16:04
Re: Upgrade problem Tom Lane 16:10
Re: Upgrade problem Adrian Klaver 16:13
Re: Upgrade problem Graeme 16:22
Re: Upgrade problem Tom Lane 16:26
Re: Upgrade problem Graeme 16:33
Re: Upgrade problem Ray O'Donnell 16:36
Re: Upgrade problem Adrian Klaver 16:50
Granting privileges to a schema to a role Johnson, Bruce E - (bjohnson) 18:07
Re: Granting privileges to a schema to a role Erik Wienhold 22:32

Sept. 12, 2023

Thread Author Time
Re: Upgrade problem Peter J. Holzer 09:39
Re: Upgrade problem Graeme 10:51
Is data import from Oracle table to Postgres table in Ora2pg consecutive or random? duc hiep ha 11:17
pg_update and encoding Graeme 11:49
Re: Is data import from Oracle table to Postgres table in Ora2pg consecutive or random? Peter J. Holzer 12:19
Re: Is data import from Oracle table to Postgres table in Ora2pg consecutive or random? Matthias Apitz 12:26
Re: Is data import from Oracle table to Postgres table in Ora2pg consecutive or random? Daniel Gustafsson 13:10
Re: Is data import from Oracle table to Postgres table in Ora2pg consecutive or random? DAVID ROTH 13:24
Re: pg_update and encoding Adrian Klaver 14:52
Re: pg_update and encoding Graeme 14:56
Re: Upgrade problem Adrian Klaver 14:57

Sept. 13, 2023

Thread Author Time
Unqualified relations in views Pete O'Such 05:58
Re: Unqualified relations in views Laurenz Albe 06:11
Re: Making Sure Primary and Secondary Keys Alligns Anthony Apollis 09:06
Re: Unqualified relations in views Pete O'Such 17:41
Re: Making Sure Primary and Secondary Keys Alligns Sándor Daku 17:49
RE: [EXT] Re: Query performance going from Oracle to Postgres Dirschel, Steve 17:58

Sept. 14, 2023

Thread Author Time
Access plan selection logic PG9.2 -> PG14 📎 Ryo Yamaji (Fujitsu) 07:15
Help with PostgreSQL Upgrade SMITH Matt 10:50
Re: Help with PostgreSQL Upgrade Daniel Gustafsson 11:11
Re: Access plan selection logic PG9.2 -> PG14 David Rowley 14:42
Re: Access plan selection logic PG9.2 -> PG14 Adrian Klaver 14:59
Re: Help with PostgreSQL Upgrade Adrian Klaver 15:24
RE: Help with PostgreSQL Upgrade SMITH Matt 15:37

Sept. 15, 2023

Thread Author Time
RE: Access plan selection logic PG9.2 -> PG14 Ryo Yamaji (Fujitsu) 09:13
RE: Access plan selection logic PG9.2 -> PG14 Ryo Yamaji (Fujitsu) 09:29
Re: Access plan selection logic PG9.2 -> PG14 David Rowley 09:50
update from 13 to16 Martin Mueller 16:55
Re: update from 13 to16 Adrian Klaver 17:01
Can two-phase commit support LISTEN, UNLISTEN, and NOTIFY? James Stuart 17:55

Sept. 16, 2023

Thread Author Time
Re: update from 13 to16 Maciek Sakrejda 19:01
Re: Can two-phase commit support LISTEN, UNLISTEN, and NOTIFY? Tom Lane 23:03

Sept. 17, 2023

Thread Author Time
Ensuring Rifferential Integrity Anthony Apollis 17:24
Re: Ensuring Rifferential Integrity Peter J. Holzer 20:54

Sept. 18, 2023

Thread Author Time
How to synchronize the read/write DB on my laptop with the read-only DB on cloud (primary on premises, replica on cloud)? Utku 08:03
trouble restoring a database backed up with pg_dump/pg_dump_all - relations are created in the wrong order Harry Green 15:08
Re: trouble restoring a database backed up with pg_dump/pg_dump_all - relations are created in the wrong order Adrian Klaver 15:16
Re: trouble restoring a database backed up with pg_dump/pg_dump_all - relations are created in the wrong order Adrian Klaver 15:20
Re: trouble restoring a database backed up with pg_dump/pg_dump_all - relations are created in the wrong order David G. Johnston 15:40
Re: trouble restoring a database backed up with pg_dump/pg_dump_all - relations are created in the wrong order Laurenz Albe 19:28
Connection not allowed because of an error 'Not in pg_hba.conf' Johnson, Bruce E - (bjohnson) 19:45
Re: Connection not allowed because of an error 'Not in pg_hba.conf' Adrian Klaver 20:00
Re: Connection not allowed because of an error 'Not in pg_hba.conf' Tom Lane 20:02
Re: Connection not allowed because of an error 'Not in pg_hba.conf' Israel Brewster 20:48
Re: [EXT]Re: Connection not allowed because of an error 'Not in pg_hba.conf' Adrian Klaver 22:21

Sept. 19, 2023

Thread Author Time
[Beginner Question]What should I do if I want to achieve lsm-tree index in postgresql? Wen Yi 00:59
回复: ident auth does not works as usual pan snowave 03:46
Calculating Days/Time(Are Loops Neccessary?) Anthony Apollis 17:09
Changed functionality from 14.3 to 15.3 Michael Corey 19:09

Sept. 20, 2023

Thread Author Time
Re: Changed functionality from 14.3 to 15.3 Erik Wienhold 00:17
debugger from superuser only.... why? 📎 Александр Петросян (web) 05:30
could not open file "base/XX/XX": Interrupted system call Torsten Krah 08:49
Re: could not open file "base/XX/XX": Interrupted system call Laurenz Albe 11:11
Re: could not open file "base/XX/XX": Interrupted system call Torsten Krah 11:24
Re: Changed functionality from 14.3 to 15.3 Michael Corey 13:15
Re: Calculating Days/Time(Are Loops Neccessary?) Adrian Klaver 15:04
Re: Calculating Days/Time(Are Loops Neccessary?) Alvaro Herrera 15:20
Re: Changed functionality from 14.3 to 15.3 Erik Wienhold 16:33
Re: Changed functionality from 14.3 to 15.3 Michael Corey 17:17
Re: trouble restoring a database backed up with pg_dump/pg_dump_all - relations are created in the wrong order Harry Green 17:59
Re: [EXT]Re: Connection not allowed because of an error 'Not in pg_hba.conf' Harry Green 18:01
Re: trouble restoring a database backed up with pg_dump/pg_dump_all - relations are created in the wrong order Adrian Klaver 18:16
Re: Changed functionality from 14.3 to 15.3 Erik Wienhold 19:07
Re: Changed functionality from 14.3 to 15.3 Michael Corey 19:19

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