pgsql-general since 2019-02-01 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
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

Feb. 1, 2019

Thread Author Time
Re: problem 📎 Moreno Andreo 13:41
FK Constraint with ON DELETE SET DEFAULT cascading as table owner Brad Leupen 14:01
Re: pgexpress 4.60 vita voom ceuro 14:34

Feb. 2, 2019

Thread Author Time
Re: FK Constraint with ON DELETE SET DEFAULT cascading as table owner rob stone 04:17
FK Constraint with ON DELETE SET DEFAULT cascading as table owner David G. Johnston 04:59

Feb. 3, 2019

Thread Author Time
Re: Revoke SQL doesn't take effect Jason W 08:43
Server goes to Recovery Mode when run a SQL PegoraroF10 15:53
Re: Server goes to Recovery Mode when run a SQL PegoraroF10 16:05
Re: Server goes to Recovery Mode when run a SQL Adrian Klaver 16:08
Re: Server goes to Recovery Mode when run a SQL PegoraroF10 16:32
Re: Server goes to Recovery Mode when run a SQL Adrian Klaver 18:05

Feb. 4, 2019

Thread Author Time
Re: Server goes to Recovery Mode when run a SQL Michael Paquier 01:07
JSONB Array of Strings (with GIN index) versus Split Rows (B-Tree Index) Syed Jafri 05:34
Re: Server goes to Recovery Mode when run a SQL rob stone 05:57
FDW, too long to run explain Vijaykumar Jain 07:14
Need details on 9.6 version of postgres A H S Phanindra 10:10
Re: Server goes to Recovery Mode when run a SQL PegoraroF10 11:13
Re: Need details on 9.6 version of postgres Adrian Klaver 15:06
Re: Server goes to Recovery Mode when run a SQL Adrian Klaver 15:09
Re: Need details on 9.6 version of postgres Andreas Kretschmer 15:22
Re: Server goes to Recovery Mode when run a SQL PegoraroF10 15:33
Re: Server goes to Recovery Mode when run a SQL Adrian Klaver 15:53
Re: JSONB Array of Strings (with GIN index) versus Split Rows (B-Tree Index) Ian Zimmerman 21:44
Re: JSONB Array of Strings (with GIN index) versus Split Rows (B-Tree Index) David G. Johnston 22:02
Re: Server goes to Recovery Mode when run a SQL rob stone 22:05

Feb. 5, 2019

Thread Author Time
Re: oracle_fwd - is it safe or not? Peter Eisentraut 09:27
Connection issue Maximilian Tyrtania 09:48
Re: Connection issue Adrian Klaver 14:57
Re: Connection issue Maximilian Tyrtania 15:18
Re: Connection issue Adrian Klaver 15:44
Auto close idle connections for specific user (not by pg_cancel command) Emi 17:47
Re: Auto close idle connections for specific user (not by pg_cancel command) Pavel Stehule 17:51
Re: Auto close idle connections for specific user (not by pg_cancel command) Thomas Poty 17:59
Re: Auto close idle connections for specific user (not by pg_cancel command) Thomas Poty 18:23
Re: Auto close idle connections for specific user (not by pg_cancel command) Thomas Poty 18:37
RE: Connection issue Ricardo Martin Gomez 23:19

Feb. 6, 2019

Thread Author Time
Re: Connection issue Maximilian Tyrtania 15:18
Calling rest service from postgresql functions and stored proc mahesh.sp 16:14
Re: Connection issue Adrian Klaver 16:19
Re: Connection issue Maximilian Tyrtania 16:30
Re: Connection issue Adrian Klaver 16:43
Re: Implementing an expanded object in C Michel Pelletier 18:56
How to find out tables that are frequently read/ write? Jason W 20:37

Feb. 7, 2019

Thread Author Time
Re: Connection issue Ricardo Martin Gomez 02:12
Re: Calling rest service from postgresql functions and stored proc Magnus Hagander 09:57
Re: Calling rest service from postgresql functions and stored proc Pavel Stehule 10:00
Re: Connection issue Maximilian Tyrtania 10:25
How to add a new psql command ? Quentin Di-Fant 10:39
Re: How to add a new psql command ? Pavel Stehule 11:02
Odd messages on reloading DB table Steve Wampler 16:28
Re: Odd messages on reloading DB table Steve Wampler 16:38
Re: How to add a new psql command ? Michel Pelletier 17:16
Re: Odd messages on reloading DB table David G. Johnston 22:24
Full text search parser dictionary Eugene Podshivalov 22:44

Feb. 8, 2019

Thread Author Time
query logging of prepared statements Justin Pryzby 13:29
Re: Server goes to Recovery Mode when run a SQL PegoraroF10 21:11
Re: [EXTERNAL]Re: Server goes to Recovery Mode when run a SQL Jeremiah Bauer 21:22
Re: Server goes to Recovery Mode when run a SQL Adrian Klaver 21:23

Feb. 9, 2019

Thread Author Time
Trigger function always logs postgres as user name Alexander Reichstadt 10:08
Re: FDW, too long to run explain auxsvr 11:39
Re: Trigger function always logs postgres as user name Francisco Olarte 12:44
Re: Server goes to Recovery Mode when run a SQL Justin Pryzby 21:46

Feb. 10, 2019

Thread Author Time
Re: query logging of prepared statements 📎 Justin Pryzby 01:57
Re: Server goes to Recovery Mode when run a SQL rob stone 04:15
Unused files in the database directory after crashed VACUUM FULL Hannes Erven 08:19
Re: Unused files in the database directory after crashed VACUUM FULL Tom Lane 15:41
Re: Unused files in the database directory after crashed VACUUM FULL Andrew Gierth 15:53
Promote replica before being able to accept connections Martín Fernández 17:32
Re: Unused files in the database directory after crashed VACUUM FULL Hannes Erven 22:49
Shared hosting with FDW on AWS RDS auxsvr 22:57
Re: Shared hosting with FDW on AWS RDS Paul Jungwirth 23:19
Re: Unused files in the database directory after crashed VACUUM FULL Tom Lane 23:20

Feb. 11, 2019

Thread Author Time
Re: Unused files in the database directory after crashed VACUUM FULL Thomas Munro 04:03
Re: tsvector field length limitation AJG 09:10
bdr replication breaks down Daniel Fink (PDF) 10:18
Re: Promote replica before being able to accept connections Laurenz Albe 10:55
Postgresql Duplicate DB Sathish Kumar 11:09
RE: Postgresql Duplicate DB Alvaro Aguayo Garcia-Rada 11:16
Re: Postgresql Duplicate DB Laurenz Albe 11:16
Re: bdr replication breaks down Alvaro Aguayo Garcia-Rada 13:21
Implementing pgaudit extension on Microsoft Windows Niels Jespersen 13:23
RE: bdr replication breaks down Daniel Fink (PDF) 14:32
Re: Implementing pgaudit extension on Microsoft Windows Pavel Stehule 14:37
Re: Implementing pgaudit extension on Microsoft Windows Tom Lane 14:43
Re: Implementing pgaudit extension on Microsoft Windows Pavel Stehule 14:47
Re: Promote replica before being able to accept connections Martín Fernández 14:59
Copy entire schema A to a different schema B Tiffany Thang 16:00
Re: Copy entire schema A to a different schema B Adrian Klaver 16:07
Re: Copy entire schema A to a different schema B Ron 16:10
Re: Copy entire schema A to a different schema B Tiffany Thang 16:30
Re: Copy entire schema A to a different schema B Adrian Klaver 16:53
Re: Odd messages on reloading DB table Steve Wampler 19:29
Re: Odd messages on reloading DB table David G. Johnston 20:03
Aurora Postgresql RDS DB Latency github kran 21:14
Re: Aurora Postgresql RDS DB Latency Michael Lewis 21:29
Blank, nullable date column rejected by psql Rich Shepard 22:44
Re: Blank, nullable date column rejected by psql Ron 22:49
Re: Blank, nullable date column rejected by psql Adrian Klaver 22:49
Re: Blank, nullable date column rejected by psql Tom Lane 22:50
Re: Blank, nullable date column rejected by psql David G. Johnston 22:58
Re: Blank, nullable date column rejected by psql Rich Shepard 23:30
Re: Blank, nullable date column rejected by psql Rich Shepard 23:32
Re: Blank, nullable date column rejected by psql Ron 23:41
Re: Blank, nullable date column rejected by psql Rich Shepard 23:43
Re: Blank, nullable date column rejected by psql Rich Shepard 23:44
Re: Blank, nullable date column rejected by psql Ken Tanzer 23:55

Feb. 12, 2019

Thread Author Time
Re: Aurora Postgresql RDS DB Latency github kran 00:00
Re: Blank, nullable date column rejected by psql Rich Shepard 00:05
Re: Blank, nullable date column rejected by psql Ken Tanzer 00:29
Re: Blank, nullable date column rejected by psql Ron 00:42
pg_dump on a standby for a very active master Arjun Ranade 00:44
Re: Promote replica before being able to accept connections Michael Paquier 03:17
Re: Server goes to Recovery Mode when run a SQL Michael Paquier 03:24
SV: Implementing pgaudit extension on Microsoft Windows Niels Jespersen 07:57
Re: Implementing pgaudit extension on Microsoft Windows Pavel Stehule 07:59
Re: Implementing pgaudit extension on Microsoft Windows Pavel Stehule 08:00
Re: Blank, nullable date column rejected by psql Laurenz Albe 08:20
SV: Implementing pgaudit extension on Microsoft Windows Niels Jespersen 09:34
Re: Implementing pgaudit extension on Microsoft Windows Pavel Stehule 11:22
Re: Aurora Postgresql RDS DB Latency github kran 13:07
Re: Blank, nullable date column rejected by psql Rich Shepard 13:42
Re: SV: Implementing pgaudit extension on Microsoft Windows Tom Lane 14:14
BDR 1.0: background worker wants to start that should not be there Daniel Fink (PDF) 14:52
Re: postgresql v11.1 Segmentation fault: signal 11: by running SELECT... JIT Issue? Justin Pryzby 15:12
Re: BDR 1.0: background worker wants to start that should not be there Alvaro Aguayo Garcia-Rada 15:14
Out of memory: Kill process nnnn (postmaster) score nn or sacrifice child Vikas Sharma 16:20
Re: postgresql v11.1 Segmentation fault: signal 11: by running SELECT... JIT Issue? pabloa98 16:31
pg_dump on a standby for a very active master Arjun Ranade 16:32
Re: Out of memory: Kill process nnnn (postmaster) score nn or sacrifice child Adrian Klaver 16:39
Re: Copy entire schema A to a different schema B Tiffany Thang 17:10
RE: pg_dump on a standby for a very active master Scot Kreienkamp 17:36
Re: pg_dump on a standby for a very active master Stephen Frost 17:59
Re: pg_dump on a standby for a very active master Arjun Ranade 18:02
Re: pg_dump on a standby for a very active master Stephen Frost 18:06
Re: pg_dump on a standby for a very active master Arjun Ranade 18:18
Postgresql RDS DB Latency Chossing Hash join Plan github kran 18:27
Temp tables and replication identities Michael Lewis 18:30
Re: Postgresql RDS DB Latency Chossing Hash join Plan Michael Lewis 18:33
Re: Postgresql RDS DB Latency Chossing Hash join Plan 📎 github kran 18:55
Subquery to select max(date) value Rich Shepard 22:23
Re: Subquery to select max(date) value David G. Johnston 22:29
Re: Subquery to select max(date) value [RESOLVED] Rich Shepard 22:32
Re: Subquery to select max(date) value Rich Shepard 22:43
Re: Subquery to select max(date) value Rich Shepard 22:48
Re: Subquery to select max(date) value Matt Zagrabelny 22:55
Re: Subquery to select max(date) value Adrian Klaver 22:58
Re: Subquery to select max(date) value Ken Tanzer 22:59
Re: Subquery to select max(date) value Rich Shepard 23:02
Re: Subquery to select max(date) value Rich Shepard 23:20
Getting wrong time using now() Om Prakash Jaiswal 23:36
Re: Subquery to select max(date) value Ken Tanzer 23:38
Re: Getting wrong time using now() Adrian Klaver 23:40
Re: Getting wrong time using now() Tom Lane 23:46
Re: Subquery to select max(date) value Rich Shepard 23:48

Feb. 13, 2019

Thread Author Time
Re: Subquery to select max(date) value Andrew Gierth 00:44
SV: SV: Implementing pgaudit extension on Microsoft Windows Niels Jespersen 08:32
Is the ring buffer not used for index blocks Daniel Westermann 09:48
Re: Subquery to select max(date) value Jan Kohnert 10:32
Re: Server goes to Recovery Mode when run a SQL PegoraroF10 11:41
Re: Server goes to Recovery Mode when run a SQL rob stone 12:29
Re: Server goes to Recovery Mode when run a SQL PegoraroF10 12:32
Re: Out of memory: Kill process nnnn (postmaster) score nn or sacrifice child Vikas Sharma 12:40
Re: Subquery to select max(date) value Rich Shepard 13:34
Re: Server goes to Recovery Mode when run a SQL rob stone 13:41
Postgrest over foreign data wrapper adrien ruffie 14:13
Re: Server goes to Recovery Mode when run a SQL PegoraroF10 14:15
Re: SV: SV: Implementing pgaudit extension on Microsoft Windows Joe Conway 14:17
Re: Subquery to select max(date) value Rich Shepard 14:28
Re: Subquery to select max(date) value Adrian Klaver 14:48
Re: Subquery to select max(date) value Rich Shepard 15:37
Re: Subquery to select max(date) value Adrian Klaver 15:46
Re: Postgresql RDS DB Latency Chossing Hash join Plan github kran 15:49
Re: Subquery to select max(date) value Adrian Klaver 16:01
Re: Subquery to select max(date) value Rich Shepard 16:13
Re: Subquery to select max(date) value Rich Shepard 17:06
Re: Subquery to select max(date) value Adrian Klaver 17:29
Re: Postgresql RDS DB Latency Chossing Hash join Plan Michael Lewis 17:37
Re: Out of memory: Kill process nnnn (postmaster) score nn or sacrifice child Andreas Kretschmer 17:38
Re: Subquery to select max(date) value Rich Shepard 18:09
Re: Postgrest over foreign data wrapper Dave Cramer 18:49
Re: Subquery to select max(date) value Adrian Klaver 20:25
Re: Subquery to select max(date) value Andrew Gierth 20:58
Postgrest over foreign data wrapper adrien ruffie 21:04
Re: Postgrest over foreign data wrapper Adrian Klaver 21:36
Re: Postgrest over foreign data wrapper Michael Lewis 21:36
Re: Postgrest over foreign data wrapper Adrian Klaver 21:43
Re: Postgrest over foreign data wrapper Michael Lewis 21:54
Problem linking to libpq.lib on Windows Roberto de Figueiredo Ribeiro 22:21
Re: Subquery to select max(date) value Rich Shepard 22:24
Streaming replication - invalid resource manager ID Maeldron T. 22:49
Re: Subquery to select max(date) value Adrian Klaver 22:52
Re: Subquery to select max(date) value Rich Shepard 23:13
Re: SV: SV: Implementing pgaudit extension on Microsoft Windows Joe Conway 23:33
Re: Subquery to select max(date) value Brent Wood 23:51

Feb. 14, 2019

Thread Author Time
Re: Subquery to select max(date) value Rich Shepard 00:26
SV: SV: SV: Implementing pgaudit extension on Microsoft Windows Niels Jespersen 08:06
SV: SV: SV: Implementing pgaudit extension on Microsoft Windows Niels Jespersen 08:41
logical replication suganthi Sekar 09:51
Re: Problem linking to libpq.lib on Windows Dmitry Igrishin 10:59
RES: Problem linking to libpq.lib on Windows Roberto de Figueiredo Ribeiro 11:43

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