[go: up one dir, main page]

pgsql-general - May 2022

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)

Browse Archives

Prev | Next

May 1, 2022

Thread Author Time
Is data passing between publisher and subscriber in logical replication compressed? Avi Weinberg 14:38

May 2, 2022

Thread Author Time
Re: External psql editor Reid Thompson 18:57
Re: External psql editor Rich Shepard 19:18
Re: Backing up a DB excluding certain tables Adrian Klaver 19:18
Re: Backing up a DB excluding certain tables JORGE MALDONADO 19:24
Re: External psql editor Tom Lane 21:27
Re: External psql editor Rich Shepard 21:31
UUID vs serial and currval('sequence_id') Robert Stanford 22:33
Re: UUID vs serial and currval('sequence_id') David G. Johnston 22:39
Re: External psql editor Mladen Gogala 22:41
Re: UUID vs serial and currval('sequence_id') Robert Stanford 23:24
Re: UUID vs serial and currval('sequence_id') David G. Johnston 23:27

May 3, 2022

Thread Author Time
Re: External psql editor Steve Litt 05:49
Re: External psql editor Peter J. Holzer 06:36
Re: Backing up a DB excluding certain tables Adrian Klaver 15:47
Re: Backing up a DB excluding certain tables JORGE MALDONADO 16:10
Re: Backing up a DB excluding certain tables Adrian Klaver 17:12
Re: Backing up a DB excluding certain tables JORGE MALDONADO 17:26
Re: Support logical replication of DDLs Zheng Li 21:30
Meaning of "constant" not honored when the variable is used as the actual for a proc's OUT formal paameter Bryn Llewellyn 22:03
Re: Meaning of "constant" not honored when the variable is used as the actual for a proc's OUT formal paameter Tom Lane 22:22
Re: Meaning of "constant" not honored when the variable is used as the actual for a proc's OUT formal paameter Bryn Llewellyn 22:48

May 4, 2022

Thread Author Time
Logical replication 'possible' problem Steve Baldwin 03:50
Re: Logical replication 'possible' problem Steve Baldwin 03:54
Re: Logical replication 'possible' problem Steve Baldwin 06:48
Re: Whole Database or Table AES encryption Aaron Gray 07:35
Re: Whole Database or Table AES encryption Aaron Gray 07:38
Re: Replication with Patroni not working after killing secondary and starting again Zb B 08:21
Completely wrong queryplan Paul van der Linden 10:05
Re: Replication with Patroni not working after killing secondary and starting again Peter J. Holzer 10:46
Displaying chat by punished users only to themselves (db fiddle attached) Alexander Farber 12:47
Re: Displaying chat by punished users only to themselves (db fiddle attached) David G. Johnston 14:26
Re: Displaying chat by punished users only to themselves (db fiddle attached) Alexander Farber 14:40
Re: Displaying chat by punished users only to themselves (db fiddle attached) Ron 14:56
Re: Displaying chat by punished users only to themselves (db fiddle attached) Alexander Farber 15:04
Re: Displaying chat by punished users only to themselves (db fiddle attached) Alexander Farber 15:08
Re: Displaying chat by punished users only to themselves (db fiddle attached) David G. Johnston 15:20
Re: Displaying chat by punished users only to themselves (db fiddle attached) Alexander Farber 15:20
Re: Displaying chat by punished users only to themselves (db fiddle attached) David G. Johnston 15:28
Re: Displaying chat by punished users only to themselves (db fiddle attached) Alexander Farber 15:36
Re: Displaying chat by punished users only to themselves (db fiddle attached) Alexander Farber 15:39
Re: Displaying chat by punished users only to themselves (db fiddle attached) David G. Johnston 15:40
Re: Displaying chat by punished users only to themselves (db fiddle attached) Alexander Farber 15:53
Re: Displaying chat by punished users only to themselves (db fiddle attached) David G. Johnston 15:56
Re: Displaying chat by punished users only to themselves (db fiddle attached) Alexander Farber 16:12
Re: Displaying chat by punished users only to themselves (db fiddle attached) David G. Johnston 16:17
Re: Backing up a DB excluding certain tables JORGE MALDONADO 17:12
Re: Displaying chat by punished users only to themselves (db fiddle attached) Alexander Farber 17:16
Re: Backing up a DB excluding certain tables Francisco Olarte 17:19
Re: Displaying chat by punished users only to themselves (db fiddle attached) Alexander Farber 17:23
Re: Backing up a DB excluding certain tables Francisco Olarte 17:27
Re: Displaying chat by punished users only to themselves (db fiddle attached) David G. Johnston 17:44
Re: Displaying chat by punished users only to themselves (db fiddle attached) Alexander Farber 18:36
WIN1252 vs UTF8 database encoding JORGE MALDONADO 21:51
Re: WIN1252 vs UTF8 database encoding Adrian Klaver 22:27

May 5, 2022

Thread Author Time
Re: Displaying chat by punished users only to themselves (db fiddle attached) Alexander Farber 10:44
Re: Displaying chat by punished users only to themselves (db fiddle attached) Alexander Farber 18:38
Re: Displaying chat by punished users only to themselves (db fiddle attached) David G. Johnston 18:47
Re: Displaying chat by punished users only to themselves (db fiddle attached) Alexander Farber 18:57

May 6, 2022

Thread Author Time
Psycopg3 fails to resolve 'timezone localtime' on MacOS Jerry Sievers 01:03
Re: Psycopg3 fails to resolve 'timezone localtime' on MacOS Tom Lane 01:29
Re: Psycopg3 fails to resolve 'timezone localtime' on MacOS Daniele Varrazzo 01:43
Re: Psycopg3 fails to resolve 'timezone localtime' on MacOS Jerry Sievers 01:43
Re: Psycopg3 fails to resolve 'timezone localtime' on MacOS Jerry Sievers 01:54
Re: Psycopg3 fails to resolve 'timezone localtime' on MacOS Jerry Sievers 02:11
Order of rows in statement triggers NEW/OLD tables hubert depesz lubaczewski 06:20
Re: Psycopg3 fails to resolve 'timezone localtime' on MacOS Francisco Olarte 09:01
Re: Replication with Patroni not working after killing secondary and starting again Zb B 10:40
Re: Support logical replication of DDLs 📎 Amit Kapila 13:24
Re: Support logical replication of DDLs Zheng Li 16:51
"A transaction cannot be ended inside a block with exception handlers." Bryn Llewellyn 23:40

May 7, 2022

Thread Author Time
Re: "A transaction cannot be ended inside a block with exception handlers." David G. Johnston 00:14
Vertical partition Rama Krishnan 00:23
Re: Vertical partition David G. Johnston 00:51
Re: Vertical partition Rama Krishnan 01:48
Re: Vertical partition David G. Johnston 01:50
How to get value wrapped in json? Shaozhong SHI 01:54
pg_dump: VACUUM and REINDEXING Hasan Marzooq 02:35
Re: "A transaction cannot be ended inside a block with exception handlers." Bryn Llewellyn 02:46
Re: "A transaction cannot be ended inside a block with exception handlers." Tom Lane 03:05
Re: How to get value wrapped in json? David G. Johnston 03:08
Re: Support logical replication of DDLs Amit Kapila 04:08
Re: "A transaction cannot be ended inside a block with exception handlers." Bryn Llewellyn 04:23
Re: "A transaction cannot be ended inside a block with exception handlers." David G. Johnston 04:46
Re: pg_dump: VACUUM and REINDEXING Guillaume Lelarge 07:36
Re: pg_dump: VACUUM and REINDEXING Ron 08:21
Re: pg_dump: VACUUM and REINDEXING Guillaume Lelarge 10:06
PLPGSQL - extra column existence in trigger Durumdara 13:02
Re: pg_dump: VACUUM and REINDEXING Hasan Marzooq 13:27
Re: PLPGSQL - extra column existence in trigger David G. Johnston 14:41
Re: pg_dump: VACUUM and REINDEXING Guillaume Lelarge 16:11

May 8, 2022

Thread Author Time
Re: Support logical replication of DDLs Dilip Kumar 07:09

May 9, 2022

Thread Author Time
The P0004 assert_failure exception assert_failure exception seems to be unhandleable Bryn Llewellyn 02:39
Re: The P0004 assert_failure exception assert_failure exception seems to be unhandleable David G. Johnston 03:04
Re: "A transaction cannot be ended inside a block with exception handlers." Bryn Llewellyn 03:49
Re: The P0004 assert_failure exception assert_failure exception seems to be unhandleable Bryn Llewellyn 04:07
Need to install Postgres Version 14 in Linux server with Client and migration steps. Rajamoorthy-CW, Thirumurugan 8361 06:46
Re: pg_dump: VACUUM and REINDEXING Laurenz Albe 06:50
Re: Support logical replication of DDLs Bharath Rupireddy 07:16
Re: Support logical replication of DDLs Amit Kapila 08:56
Re: Support logical replication of DDLs Alvaro Herrera 09:05
Re: PLPGSQL - extra column existence in trigger Durumdara 11:27
Re: pg_dump: VACUUM and REINDEXING Tom Lane 14:08
Re: Need to install Postgres Version 14 in Linux server with Client and migration steps. Sandeep Kumar Jakkaraju 16:07
RE: Need to install Postgres Version 14 in Linux server with Client and migration steps. Rajamoorthy-CW, Thirumurugan 8361 16:09
Re: Need to install Postgres Version 14 in Linux server with Client and migration steps. Alan Hodgson 16:14
Re: Need to install Postgres Version 14 in Linux server with Client and migration steps. Sandeep Kumar Jakkaraju 16:14
Re: Need to install Postgres Version 14 in Linux server with Client and migration steps. Adrian Klaver 16:14

May 10, 2022

Thread Author Time
Set timeout just on a query? Shaozhong SHI 00:58
Set timeout just on a query? Shaozhong SHI 00:59
Re: Set timeout just on a query? Christophe Pettus 01:00
Re: Set timeout just on a query? Bharath Rupireddy 03:56
Question on cast string to date 正华吕 04:28
Re: Question on cast string to date Pavel Stehule 04:36
Re: Question on cast string to date Ian Lawrence Barwick 04:38
Re: Question on cast string to date Tom Lane 04:44
Re: Question on cast string to date David G. Johnston 05:40
Re: Question on cast string to date 正华吕 05:47
Re: Question on cast string to date Tom Lane 06:03
Re: Support logical replication of DDLs Masahiko Sawada 07:02
Re: Support logical replication of DDLs Amit Kapila 09:27
Re: Support logical replication of DDLs 📎 Ajin Cherian 11:33
Re: Support logical replication of DDLs Amit Kapila 12:39
Re: Support logical replication of DDLs 📎 Ajin Cherian 15:17
Re: Support logical replication of DDLs Zheng Li 15:48
Fedora 36 Kieran McCusker 16:38
Re: Fedora 36 Adrian Klaver 18:58
Re: PLPGSQL - extra column existence in trigger Peter J. Holzer 22:43

May 11, 2022

Thread Author Time
Deferred constraint trigger semantics Bryn Llewellyn 00:46
Re: Deferred constraint trigger semantics David G. Johnston 01:19
Re: Deferred constraint trigger semantics Bryn Llewellyn 02:52
Re: Deferred constraint trigger semantics David G. Johnston 03:33
Re: Support logical replication of DDLs Masahiko Sawada 04:45
Re: Support logical replication of DDLs 📎 Ajin Cherian 06:21
Re: Deferred constraint trigger semantics Laurenz Albe 06:29
Re: Support logical replication of DDLs Masahiko Sawada 07:38
Re: Support logical replication of DDLs Amit Kapila 09:15
Re: PLPGSQL - extra column existence in trigger hubert depesz lubaczewski 10:29
Re: Support logical replication of DDLs Masahiko Sawada 12:55
consistent postgresql snapshot Zwettler Markus (OIZ) 15:41
Re: Deferred constraint trigger semantics Bryn Llewellyn 22:43
Re: Deferred constraint trigger semantics Bryn Llewellyn 22:54
Re: Deferred constraint trigger semantics David G. Johnston 23:10
Re: Deferred constraint trigger semantics Bryn Llewellyn 23:45
Re: consistent postgresql snapshot Ron 23:50

May 12, 2022

Thread Author Time
effects of nullifying bytea column on storage David Gauthier 00:01
Re: effects of nullifying bytea column on storage David G. Johnston 00:05
Re: Support logical replication of DDLs Amit Kapila 02:54
Re: effects of nullifying bytea column on storage David Gauthier 02:59
Re: effects of nullifying bytea column on storage David G. Johnston 03:10
Re: Deferred constraint trigger semantics Laurenz Albe 06:51
AW: [Extern] Re: consistent postgresql snapshot Zwettler Markus (OIZ) 09:10
Restricting user to see schema structure Neeraj M R 10:04
Re: AW: [Extern] Re: consistent postgresql snapshot Tom Lane 13:48
Re: Fedora 36 Adrian Klaver 14:40
Re: Deferred constraint trigger semantics alias 14:48
Re: AW: [Extern] Re: consistent postgresql snapshot Nick Cleaton 14:53
Re: effects of nullifying bytea column on storage Hugh Ranalli 15:03
Re: Restricting user to see schema structure Adrian Klaver 15:24
Re: AW: [Extern] Re: consistent postgresql snapshot kaido vaikla 17:02
Re: Restricting user to see schema structure Bryn Llewellyn 18:29
Re: Deferred constraint trigger semantics Bryn Llewellyn 18:40
Re: Restricting user to see schema structure Adrian Klaver 18:44
Re: Restricting user to see schema structure David G. Johnston 19:14

May 13, 2022

Thread Author Time
Re: Restricting user to see schema structure Bryn Llewellyn 02:35
Re: Restricting user to see schema structure David G. Johnston 03:01
Re: Restricting user to see schema structure Tom Lane 03:08
Re: Restricting user to see schema structure Bryn Llewellyn 03:42
Re: Restricting user to see schema structure Pavel Stehule 03:46
Re: Restricting user to see schema structure Bryn Llewellyn 04:10
Re: AW: [Extern] Re: consistent postgresql snapshot Ron 04:11
Re: Restricting user to see schema structure Neeraj M R 05:03
Re: Deferred constraint trigger semantics Bryn Llewellyn 05:06
Re: Restricting user to see schema structure David G. Johnston 05:08
Re: Restricting user to see schema structure Bryn Llewellyn 05:13
Re: Restricting user to see schema structure Neeraj M R 05:51
Re: Deferred constraint trigger semantics Laurenz Albe 06:28
Re: Restricting user to see schema structure Bryn Llewellyn 06:37
Re: Deferred constraint trigger semantics Bryn Llewellyn 06:43
generated column cast from timestamptz to timestamp not OK. alias 10:47
Re: generated column cast from timestamptz to timestamp not OK. Francisco Olarte 11:45
Re: Restricting user to see schema structure David G. Johnston 13:47
Re: Restricting user to see schema structure Adrian Klaver 15:16
Re: Restricting user to see schema structure Adrian Klaver 15:30
Logon via GSSAPI from Linux fails, but works from Windows Niels Jespersen 16:25
Re: Support logical replication of DDLs 📎 Zheng Li 21:01

May 16, 2022

Thread Author Time
Re: Deferred constraint trigger semantics Bryn Llewellyn 19:03
Re: Restricting user to see schema structure Bryn Llewellyn 21:04
Re: Restricting user to see schema structure Adrian Klaver 21:23
Re: Restricting user to see schema structure David G. Johnston 21:23

May 17, 2022

Thread Author Time
[No subject] Rama Krishnan 03:42
Re: Amul Sul 03:49
Re: David G. Johnston 03:49
Re: Restricting user to see schema structure Bryn Llewellyn 05:21
Row level security insert policy does not validate update new values/content? alias 11:56
Parallel not working 📎 huangning290@yahoo.com 12:24
Alternative to slow SRF in SELECT? Markur Sens 14:19
Re: Alternative to slow SRF in SELECT? David G. Johnston 14:33
Re: Restricting user to see schema structure David G. Johnston 14:53
Postgres AST Deparser for Postgres Dan Lynch 15:29

Browse Archives

Prev | Next