pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
moving data with pg_dump/pg_restore between database with different locale
  2023-10-11 11:34 UTC  Zwettler Markus (OIZ) <Markus.Zwettler@zuerich.ch>
` Re: moving data with pg_dump/pg_restore between database with different locale
  2023-10-11 16:49 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
  [2+ messages in thread]

No Data Being Inserted
  2023-10-11 11:46 UTC  Anthony Apollis <anthony.apollis@gmail.com>
` Re: No Data Being Inserted
  2023-10-11 12:39 UTC  Ron <ronljohnsonjr@gmail.com>
` Re: No Data Being Inserted
  2023-10-11 15:14 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
  [3+ messages in thread]

Subject: FATAL: cache lookup failed for relation 1247
  2023-10-11 06:05 UTC  Israr Khan <israr@amnex.com>
` Re: Subject: FATAL: cache lookup failed for relation 1247
  2023-10-11 14:24 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Proposal to Compile a 256-Byte Identifier Length Version Alongside the Current 64-Byte Version
  2023-10-10 03:49 UTC  David HJ <chuxiongzhong@gmail.com>
` Re: Proposal to Compile a 256-Byte Identifier Length Version Alongside the Current 64-Byte Version
  2023-10-10 06:22 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Proposal to Compile a 256-Byte Identifier Length Version Alongside the Current 64-Byte Version
  2023-10-10 06:32 UTC  Julien Rouhaud <rjuju123@gmail.com>
` Re: Proposal to Compile a 256-Byte Identifier Length Version Alongside the Current 64-Byte Version
  2023-10-10 06:53 UTC  Tatsuo Ishii <ishii@sraoss.co.jp>
` Re: Proposal to Compile a 256-Byte Identifier Length Version Alongside the Current 64-Byte Version
  2023-10-10 09:26 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Proposal to Compile a 256-Byte Identifier Length Version Alongside the Current 64-Byte Version
  2023-10-10 14:37 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Proposal to Compile a 256-Byte Identifier Length Version Alongside the Current 64-Byte Version
  2023-10-11 05:53 UTC  Peter Eisentraut <peter@eisentraut.org>
` Re: Proposal to Compile a 256-Byte Identifier Length Version Alongside the Current 64-Byte Version
  2023-10-11 05:56 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [8+ messages in thread]

GIST index and ORDER BY
  2023-10-09 10:39 UTC  Michał Kłeczek <michal@kleczek.org>

Index scan is not pushed down to union all subquery
  2023-10-05 06:14 UTC  Lauri Kajan <lauri.kajan@gmail.com>
` Re: Index scan is not pushed down to union all subquery
  2023-10-05 09:13 UTC  Marian Wendt <marian.wendt@yahoo.com>
` Re: Index scan is not pushed down to union all subquery
  2023-10-05 09:20 UTC  Marian Wendt <marian.wendt@yahoo.com>
` Re: Index scan is not pushed down to union all subquery
  2023-10-05 09:33 UTC  Marian Wendt <marian.wendt@yahoo.com>
` Re: Index scan is not pushed down to union all subquery
  2023-10-05 09:44 UTC  Dominique Devienne <ddevienne@gmail.com>
` Re: Index scan is not pushed down to union all subquery
  2023-10-05 13:25 UTC  Lauri Kajan <lauri.kajan@gmail.com>
` Re: Index scan is not pushed down to union all subquery
  2023-10-09 07:36 UTC  Lauri Kajan <lauri.kajan@gmail.com>
  [7+ messages in thread]

Multiple inserts with two levels of foreign keys
  2023-10-04 23:59 UTC  Dow Drake <dowdrake@gmail.com>
` Re: Multiple inserts with two levels of foreign keys
  2023-10-05 01:25 UTC  Ron <ronljohnsonjr@gmail.com>
` Re: Multiple inserts with two levels of foreign keys
  2023-10-05 01:50 UTC  Dow Drake <dowdrake@gmail.com>
` Re: Multiple inserts with two levels of foreign keys
  2023-10-05 01:57 UTC  Ron <ronljohnsonjr@gmail.com>
` Re: Multiple inserts with two levels of foreign keys
  2023-10-05 02:15 UTC  Dow Drake <dowdrake@gmail.com>
` Re: Multiple inserts with two levels of foreign keys
  2023-10-05 02:31 UTC  Ron <ronljohnsonjr@gmail.com>
` Re: Multiple inserts with two levels of foreign keys
  2023-10-05 09:39 UTC  Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: Multiple inserts with two levels of foreign keys
  2023-10-05 14:33 UTC  Dow Drake <dowdrake@gmail.com>
` Re: Multiple inserts with two levels of foreign keys
  2023-10-05 14:59 UTC  Ron <ronljohnsonjr@gmail.com>
` Re: Multiple inserts with two levels of foreign keys
  2023-10-08 09:02 UTC  Peter J. Holzer <hjp-pgsql@hjp.at>
` Re: Multiple inserts with two levels of foreign keys
  2023-10-08 21:01 UTC  Dow Drake <dowdrake@gmail.com>
  [11+ messages in thread]

psql trying twice to connect to local DB
  2023-10-07 22:44 UTC  Steve Baldwin <steve.baldwin@gmail.com>
` Re: psql trying twice to connect to local DB
  2023-10-07 23:13 UTC  Steve Baldwin <steve.baldwin@gmail.com>
` Re: psql trying twice to connect to local DB
  2023-10-07 23:14 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: psql trying twice to connect to local DB
  2023-10-08 02:39 UTC  Ron <ronljohnsonjr@gmail.com>
  [4+ messages in thread]

Gradual migration from integer to bigint?
  2023-09-30 05:55 UTC  James Healy <james@yob.id.au>
` Re: Gradual migration from integer to bigint?
  2023-09-30 16:22 UTC  grimy.outshine830@aceecat.org
` Re: Gradual migration from integer to bigint?
  2023-09-30 17:35 UTC  Bruce Momjian <bruce@momjian.us>
` Re: Gradual migration from integer to bigint?
  2023-10-01 03:16 UTC  James Healy <james@yob.id.au>
` Re: Gradual migration from integer to bigint?
  2023-10-01 03:37 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Gradual migration from integer to bigint?
  2023-10-01 04:26 UTC  Ron <ronljohnsonjr@gmail.com>
` Re: Gradual migration from integer to bigint?
  2023-10-01 08:18 UTC  James Healy <james@yob.id.au>
` Re: Gradual migration from integer to bigint?
  2023-10-01 09:30 UTC  Ann Harrison <ann@qbeast.net>
` Re: Gradual migration from integer to bigint?
  2023-10-01 17:04 UTC  Ireneusz Pluta <ipluta@wp.pl>
` Re: Gradual migration from integer to bigint?
  2023-10-01 22:47 UTC  Ron <ronljohnsonjr@gmail.com>
` Re: Gradual migration from integer to bigint?
  2023-10-05 12:25 UTC  Nick Cleaton <nick@cleaton.net>
` Re: Gradual migration from integer to bigint?
  2023-10-06 21:11 UTC  Bruce Momjian <bruce@momjian.us>
  [12+ messages in thread]

why generated columsn cannot be used in COPY TO?
  2023-10-06 11:53 UTC  Luca Ferrari <fluca1978@gmail.com>
` Re: why generated columsn cannot be used in COPY TO?
  2023-10-06 12:20 UTC  Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: why generated columsn cannot be used in COPY TO?
  2023-10-06 13:16 UTC  Ron <ronljohnsonjr@gmail.com>
` Re: why generated columsn cannot be used in COPY TO?
  2023-10-06 13:47 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: why generated columsn cannot be used in COPY TO?
  2023-10-06 14:04 UTC  Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: why generated columsn cannot be used in COPY TO?
  2023-10-06 14:55 UTC  Rob Sargent <robjsargent@gmail.com>
` Re: why generated columsn cannot be used in COPY TO?
  2023-10-06 15:03 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: why generated columsn cannot be used in COPY TO?
  2023-10-06 15:06 UTC  Dominique Devienne <ddevienne@gmail.com>
` Re: why generated columsn cannot be used in COPY TO?
  2023-10-06 15:45 UTC  Ron <ronljohnsonjr@gmail.com>
` Re: why generated columsn cannot be used in COPY TO?
  2023-10-06 15:53 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: why generated columsn cannot be used in COPY TO?
  2023-10-06 16:08 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: why generated columsn cannot be used in COPY TO?
  2023-10-06 16:17 UTC  Ron <ronljohnsonjr@gmail.com>
` Re: why generated columsn cannot be used in COPY TO?
  2023-10-06 16:37 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: why generated columsn cannot be used in COPY TO?
  2023-10-06 20:28 UTC  David G. Johnston <david.g.johnston@gmail.com>
  [14+ messages in thread]

How to make a map in pg kernel?
  2023-10-05 14:33 UTC  jacktby jacktby <jacktby@gmail.com>
` Re: How to make a map in pg kernel?
  2023-10-06 14:38 UTC  Artur Zakirov <zaartur@gmail.com>
  [2+ messages in thread]

Ask about Foreign Table Plug-in on Windows Server.
  2023-10-05 10:39 UTC  Anuwat Sagulmontreechai <anuwat_s@softsquaregroup.com>
` Re: Ask about Foreign Table Plug-in on Windows Server.
  2023-10-05 19:43 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` RE: Ask about Foreign Table Plug-in on Windows Server.
  2023-10-06 06:31 UTC  Anuwat Sagulmontreechai <anuwat_s@softsquaregroup.com>
  [3+ messages in thread]

No yum repo for CentOS 7 and postgres 16?
  2023-10-05 20:55 UTC  Jeff Ross <jross@openvistas.net>
` No yum repo for CentOS 7 and postgres 16?
  2023-10-05 21:46 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: No yum repo for CentOS 7 and postgres 16?
  2023-10-05 22:02 UTC  Jeff Ross <jross@openvistas.net>
  [3+ messages in thread]

Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  2023-10-04 02:32 UTC  Lincoln Swaine-Moore <lswainemoore@gmail.com>
` Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  2023-10-04 03:36 UTC  Steve Crawford <scrawford@pinpointresearch.com>
` Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  2023-10-04 10:27 UTC  Marian Wendt <marian.wendt@yahoo.com>
` Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  2023-10-04 14:11 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  2023-10-04 14:55 UTC  Marian Wendt <marian.wendt@yahoo.com>
` Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  2023-10-04 15:58 UTC  Lincoln Swaine-Moore <lswainemoore@gmail.com>
` Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  2023-10-04 16:54 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  2023-10-04 17:10 UTC  Lincoln Swaine-Moore <lswainemoore@gmail.com>
` Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  2023-10-04 17:22 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  2023-10-04 17:35 UTC  Lincoln Swaine-Moore <lswainemoore@gmail.com>
` Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  2023-10-04 17:40 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  2023-10-04 17:45 UTC  Lincoln Swaine-Moore <lswainemoore@gmail.com>
` Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  2023-10-04 19:00 UTC  Steve Crawford <scrawford@pinpointresearch.com>
` Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  2023-10-04 19:06 UTC  Alban Hertroys <haramrae@gmail.com>
` Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  2023-10-04 19:16 UTC  Lincoln Swaine-Moore <lswainemoore@gmail.com>
` Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  2023-10-04 19:30 UTC  Lincoln Swaine-Moore <lswainemoore@gmail.com>
` Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  2023-10-04 19:48 UTC  Brent Wood <Brent.Wood@niwa.co.nz>
` Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones
  2023-10-04 21:10 UTC  Alban Hertroys <haramrae@gmail.com>
  [18+ messages in thread]

I'm using both window and agg, is this expected sorting behavior?
  2023-10-04 16:05 UTC  jinser <aimer@purejs.icu>
` Re: I'm using both window and agg, is this expected sorting behavior?
  2023-10-04 16:32 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Strange error trying to import with Ora2PG
  2023-10-03 17:32 UTC  Johnson, Bruce E - (bjohnson) <Johnson@pharmacy.arizona.edu>
` Re: Strange error trying to import with Ora2PG
  2023-10-03 21:27 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: [EXT]Re: Strange error trying to import with Ora2PG
  2023-10-04 13:24 UTC  Johnson, Bruce E - (bjohnson) <Johnson@pharmacy.arizona.edu>
` Re: [EXT]Re: Strange error trying to import with Ora2PG
  2023-10-04 15:38 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: [EXT]Re: Strange error trying to import with Ora2PG
  2023-10-04 16:04 UTC  Johnson, Bruce E - (bjohnson) <Johnson@pharmacy.arizona.edu>
  [5+ messages in thread]

Peer authentication failed ???
  2023-10-03 09:55 UTC  Amn Ojee Uw <amnojeeuw@gmail.com>
` Re: Peer authentication failed ???
  2023-10-03 12:35 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Peer authentication failed ???
  2023-10-03 13:37 UTC  Peter J. Holzer <hjp-pgsql@hjp.at>
` Re: Peer authentication failed ???
  2023-10-04 09:28 UTC  Amn Ojee Uw <amnojeeuw@gmail.com>
  [4+ messages in thread]

Logical Replication vs. Free Replication Slots
  2023-10-03 15:27 UTC  Don Seiler <don@seiler.us>
` Re: Logical Replication vs. Free Replication Slots
  2023-10-03 16:41 UTC  Don Seiler <don@seiler.us>
  [2+ messages in thread]

Problems starting slave
  2023-10-02 14:38 UTC  Douglas Reed <dougreed765@yahoo.com>
` Re: Problems starting slave
  2023-10-03 13:33 UTC  Ron <ronljohnsonjr@gmail.com>
` Re: Problems starting slave
  2023-10-03 14:37 UTC  Douglas Reed <dougreed765@yahoo.com>
` Re: Problems starting slave
  2023-10-03 15:08 UTC  Ron <ronljohnsonjr@gmail.com>
  [4+ messages in thread]

Connection not allowed because of an error 'Not in pg_hba.conf'
  2023-09-18 19:45 UTC  Johnson, Bruce E - (bjohnson) <Johnson@pharmacy.arizona.edu>
` Re: Connection not allowed because of an error 'Not in pg_hba.conf'
  2023-09-18 20:00 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Connection not allowed because of an error 'Not in pg_hba.conf'
  2023-09-18 20:02 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Connection not allowed because of an error 'Not in pg_hba.conf'
  2023-09-18 20:48 UTC  Israel Brewster <ijbrewster@alaska.edu>
` Re: [EXT]Re: Connection not allowed because of an error 'Not in pg_hba.conf'
  2023-09-18 22:21 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: [EXT]Re: Connection not allowed because of an error 'Not in pg_hba.conf'
  2023-09-20 18:01 UTC  Harry Green <harrygreen91@yahoo.com>
` Re: [EXT]Re: Connection not allowed because of an error 'Not in pg_hba.conf'
  2023-09-20 21:16 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: [EXT]Re: Connection not allowed because of an error 'Not in pg_hba.conf'
  2023-10-03 09:59 UTC  Harry Green <harrygreen91@yahoo.com>
` Re: [EXT]Re: Connection not allowed because of an error 'Not in pg_hba.conf'
  2023-10-03 14:57 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
  [9+ messages in thread]

specifying multiple options in URI psql behaviour?
  2023-10-02 12:48 UTC  Wim Bertels <wim.bertels@ucll.be>
` Re: specifying multiple options in URI psql behaviour?
  2023-10-02 14:21 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: specifying multiple options in URI psql behaviour?
  2023-10-02 15:21 UTC  Wim Bertels <wim.bertels@ucll.be>
` Re: specifying multiple options in URI psql behaviour?
  2023-10-03 13:35 UTC  Ron <ronljohnsonjr@gmail.com>
  [4+ messages in thread]

Operating of synchronous master when no standby is available
  2023-10-02 08:54 UTC  Sergey Cherukhin <sergey.cherukhin@gmail.com>
` Re: Operating of synchronous master when no standby is available
  2023-10-02 11:15 UTC  Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: Operating of synchronous master when no standby is available
  2023-10-02 14:59 UTC  Ron <ronljohnsonjr@gmail.com>
` Re: Operating of synchronous master when no standby is available
  2023-10-02 22:13 UTC  MATSUO Takatoshi <matsuo.tak@gmail.com>
` Re: Operating of synchronous master when no standby is available
  2023-10-03 08:51 UTC  Sergey Cherukhin <sergey.cherukhin@gmail.com>
` Re: Operating of synchronous master when no standby is available
  2023-10-03 10:22 UTC  MATSUO Takatoshi <matsuo.tak@gmail.com>
` Re: Operating of synchronous master when no standby is available
  2023-10-03 12:40 UTC  Sergey Cherukhin <sergey.cherukhin@gmail.com>
  [7+ messages in thread]

pg_stat_statements IN problem
  2023-10-02 16:19 UTC  byme@byme.email
` Re: pg_stat_statements IN problem
  2023-10-02 18:50 UTC  Wim Bertels <wim.bertels@ucll.be>
` Re: pg_stat_statements IN problem
  2023-10-03 08:05 UTC  byme@byme.email
` Re: pg_stat_statements IN problem
  2023-10-03 08:22 UTC  David Rowley <dgrowleyml@gmail.com>
` Re: pg_stat_statements IN problem
  2023-10-03 08:54 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: pg_stat_statements IN problem
  2023-10-03 09:03 UTC  byme@byme.email
` Re: pg_stat_statements IN problem
  2023-10-03 09:19 UTC  David Rowley <dgrowleyml@gmail.com>
  [7+ messages in thread]

How to force "re-TOAST" after changing STORAGE or COMPRESSION?
  2023-10-02 14:42 UTC  Dominique Devienne <ddevienne@gmail.com>
` Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION?
  2023-10-02 23:57 UTC  Michael Paquier <michael@paquier.xyz>
` Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION?
  2023-10-03 01:33 UTC  rob stone <floriparob@tpg.com.au>
` Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION?
  2023-10-03 04:31 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION?
  2023-10-03 04:45 UTC  Michael Paquier <michael@paquier.xyz>
` Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION?
  2023-10-03 07:08 UTC  Dominique Devienne <ddevienne@gmail.com>
` Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION?
  2023-10-03 07:15 UTC  Michael Paquier <michael@paquier.xyz>
` Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION?
  2023-10-03 07:17 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION?
  2023-10-03 07:29 UTC  Dominique Devienne <ddevienne@gmail.com>
  [9+ messages in thread]

How to investigate deadlocks
  2023-10-02 11:27 UTC  Matthias Apitz <guru@unixarea.de>
` Re: How to investigate deadlocks
  2023-10-02 11:36 UTC  Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: How to investigate deadlocks
  2023-10-02 11:39 UTC  Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: How to investigate deadlocks
  2023-10-02 14:01 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: How to investigate deadlocks
  2023-10-02 14:16 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: How to investigate deadlocks
  2023-10-02 22:25 UTC  David G. Johnston <david.g.johnston@gmail.com>
  [6+ messages in thread]


[next (older)]

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox