pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedmoving 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