pgsql-general - February 2018

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, 2018

Thread Author Time
Re: Please help me understand unlogged tables Michael Paquier 00:45
Re: PG Sharding Steven Lembark 03:48
Re: Issue with WAL logs temporary not replaying Eugene Pirogov 07:17
Re: Information on savepoint requirement within transctions Robert Zenz 08:25
Master-Slave error: the database system is starting up Сергей Злобин 14:43
Re: Master-Slave error: the database system is starting up Andreas Kretschmer 16:48
Re: PG Sharding Dan Wierenga 18:01
What is your psql tip? Joshua D. Drake 19:50
Searching Postgresql Database with psycopg2 📎 brandon wallace 20:50
Re: Searching Postgresql Database with psycopg2 Rob Sargent 20:52
Re: Searching Postgresql Database with psycopg2 David Kohn 20:59
Rolls Andrew Bartley 21:22
Re: Rolls Rob Sargent 21:29
Re: Rolls Andrew Bartley 21:42
Re: Rolls David G. Johnston 21:43
Re: Recreating functions after starting the database server. raf 22:25
Re: Issue with WAL logs temporary not replaying Tomas Vondra 23:44
Re: pgaudit? Devrim Gündüz 23:46

Feb. 2, 2018

Thread Author Time
Re: pgaudit? Simon Riggs 00:43
Ensure extension exists Geoffrey Hoffman 00:47
Create schema with in a specific database from a script file Abhra Kar 02:09
Re: Create schema with in a specific database from a script file Melvin Davidson 02:18
Re: Create schema with in a specific database from a script file Abhra Kar 02:42
Re: Create schema with in a specific database from a script file Melvin Davidson 02:53
Create schema with in a specific database from a script file David G. Johnston 02:56
Re: Master-Slave error: the database system is starting up Sargez 07:30
Re: Master-Slave error: the database system is starting up Daniel Westermann 08:03
Re: PG Sharding Matej 09:50
FATAL: failed to create a backend connection Vikas Sharma 12:27
Re: FATAL: failed to create a backend connection Pavan Teja 12:47
Increasing size of array items without locking Rowan Seymour 15:26
Postgres Planner "Inconsistency"? Renzo Bertuzzi 15:37
Re: Unexpected ErrorMessage reply to SSLRequest Peter Eisentraut 19:36
Re: Ensure extension exists Peter Eisentraut 19:38
Re: Ensure extension exists geoff hoffman 19:40
Re: ERROR: too many dynamic shared memory segments Tom Lane 20:01
Re: ERROR: too many dynamic shared memory segments Robert Haas 20:19
Re: ERROR: too many dynamic shared memory segments Tom Lane 20:56

Feb. 3, 2018

Thread Author Time
Re: Postgres Planner "Inconsistency"? Laurenz Albe 05:27
pgAdmin questions bob gailer 20:24
Re: pgAdmin questions Adrian Klaver 20:30
Re: pgAdmin questions bob gailer 21:00
Re: pgAdmin questions Adrian Klaver 21:12
Re: pgAdmin questions bob gailer 21:24
Re: pgAdmin questions bob gailer 21:24

Feb. 4, 2018

Thread Author Time
Looking for workaround to avoid deadlock when using exclusion constraint Mark Scheffer 11:57

Feb. 5, 2018

Thread Author Time
Re: pgAdmin questions Khushboo Vashi 03:53
Replication slots for cascading replication. Tore Halvorsen 08:20
weird result by changing type enum array to text array of a column Thomas Poty 10:26
Re: weird result by changing type enum array to text array of a column rob stone 12:16
Re: weird result by changing type enum array to text array of a column Thomas Poty 13:09
Regex Replace with 2 conditions Denisa Cirstescu 13:34
Re: Regex Replace with 2 conditions Francisco Olarte 14:26
Re: Regex Replace with 2 conditions Tom Lane 14:43
Re: Regex Replace with 2 conditions David G. Johnston 14:53
RE: Regex Replace with 2 conditions Denisa Cirstescu 16:54
Re: Regex Replace with 2 conditions Francisco Olarte 17:22
Postgres install Azimuddin Mohammed 20:41
Re: Postgres install Adrian Klaver 20:51

Feb. 6, 2018

Thread Author Time
Re: Postgres install Benjamin Scherrey 00:01
Re: Postgres install Dave Cramer 00:38
Alter table set logged hanging after writing out all WAL Jeremy Finzel 06:50
Found non-empty schema without metadata table error while migrating Abhra Kar 06:52
Re: Alter table set logged hanging after writing out all WAL Michael Paquier 07:19
Parallel Query - Can it be used within functions? Michael Krüger 07:24
Re: Parallel Query - Can it be used within functions? Andreas Kretschmer 07:35
Re: Alter table set logged hanging after writing out all WAL Jeremy Finzel 07:36
Function execution is taking more than 2hrs Raghavendra Rao J S V 10:06
PostgreSQL Active-Active Dhandapani Shanmugam 11:01
Re: Function execution is taking more than 2hrs Laurenz Albe 11:09
Re: PostgreSQL Active-Active Andreas Kretschmer 11:10
Re: PostgreSQL Active-Active Stephen Frost 11:12
Re: PostgreSQL Active-Active Stephen Frost 11:16
Re: Postgres install Samuel Teixeira Santos 11:18
Re: PostgreSQL Active-Active Laurenz Albe 11:24
Re: PostgreSQL Active-Active Thomas Kellerer 11:30
Re: PostgreSQL Active-Active Shreeyansh Dba 11:38
Re: Pgcrypto (PostgreSQL 10) on Debain 9? Magnus Hagander 12:31
Pgcrypto (PostgreSQL 10) on Debain 9? Thiemo Kellner 12:37
pgcrypto.gen_random_uuid() or uuid-ossp.uuid_generate_v4()? Thiemo Kellner 12:42
Re: Pgcrypto (PostgreSQL 10) on Debain 9? Thiemo Kellner, NHC Barhufpflege 13:25
Re: pgcrypto.gen_random_uuid() or uuid-ossp.uuid_generate_v4()? Adam Brusselback 13:53
Re: pgcrypto.gen_random_uuid() or uuid-ossp.uuid_generate_v4()? Thiemo Kellner, NHC Barhufpflege 14:21
Re: pgcrypto.gen_random_uuid() or uuid-ossp.uuid_generate_v4()? Tom Lane 14:56
Re: pgcrypto.gen_random_uuid() or uuid-ossp.uuid_generate_v4()? Thiemo Kellner, NHC Barhufpflege 15:22
Re: Regex Replace with 2 conditions George Neuner 15:46
Re: Regex Replace with 2 conditions David G. Johnston 15:52
Re: Pgcrypto (PostgreSQL 10) on Debain 9? Raymond O'Donnell 15:58
Re: Regex Replace with 2 conditions George Neuner 16:13
Re: Found non-empty schema without metadata table error while migrating Adrian Klaver 16:38
Re: Regex Replace with 2 conditions Francisco Olarte 16:57
Re: Regex Replace with 2 conditions George Neuner 17:18
pgadmin4: not possible to create server robert rottermann 17:24
Re: pgadmin4: not possible to create server Adrian Klaver 17:28
Re: pgadmin4: not possible to create server Murtuza Zabuawala 17:29
Re: pgadmin4: not possible to create server robert 22:05
Re: pgadmin4: not possible to create server robert 22:07
Re: pgadmin4: not possible to create server robert 22:08
Re: pgadmin4: not possible to create server robert 22:08
Re: pgadmin4: not possible to create server Adrian Klaver 22:12
Re: pgadmin4: not possible to create server robert 22:17
Re: pgadmin4: not possible to create server robert 22:19
postgres instalation Azimuddin Mohammed 22:27
Re: pgadmin4: not possible to create server Adrian Klaver 22:30
Re: pgadmin4: not possible to create server Adrian Klaver 22:33
solution: Re: pgadmin4: not possible to create server robert 23:02
Re: pgadmin4: not possible to create server robert 23:11
Re: pgadmin4: not possible to create server Adrian Klaver 23:20

Feb. 7, 2018

Thread Author Time
Re: Alter table set logged hanging after writing out all WAL Michael Paquier 00:01
RE: postgres instalation godofsix 00:05
Re: postgres instalation David G. Johnston 00:19
Re: postgres instalation Azimuddin Mohammed 01:41
Re: postgres instalation David G. Johnston 01:45
Fwd: postgres instalation Azimuddin Mohammed 02:05
Re: Fwd: postgres instalation Adrian Klaver 03:17
Re: Fwd: postgres instalation Azimuddin Mohammed 03:32
Re: Fwd: postgres instalation Adrian Klaver 03:41
Re: Alter table set logged hanging after writing out all WAL Jeremy Finzel 03:48
Re: Pgcrypto (PostgreSQL 10) on Debain 9? Michael Paquier 05:06
Re: Fwd: postgres instalation Shreeyansh Dba 05:16
Re: Fwd: postgres instalation Azimuddin Mohammed 06:35
Re: Fwd: postgres instalation Azimuddin Mohammed 07:02
Re: [solved] Pgcrypto (PostgreSQL 10) on Debain 9? Thiemo Kellner 07:17
Documentation section F Thiemo Kellner 07:35
RE: PostgreSQL Active-Active Lazaro Garcia 14:28
"could not receive data from client" && "incomplete startup packet" David Gauthier 14:34
Re: "could not receive data from client" && "incomplete startup packet" David G. Johnston 14:47
RE: PostgreSQL Active-Active Alexander Kukushkin 16:24
Re: Master-Slave error: the database system is starting up Sargez 16:37
Re: "could not receive data from client" && "incomplete startup packet" David Gauthier 16:59
BDR, ERROR: previous init failed, manual cleanup is required Zhu, Joshua 17:14
Re: Alter table set logged hanging after writing out all WAL Jeremy Finzel 17:35
Critical errors during logical decoding Colin Morelli 19:20
Re: Documentation section F Peter Eisentraut 19:53
Re: Critical errors during logical decoding Colin Morelli 20:07
LDAP for postgres Azimuddin Mohammed 20:28
[No subject] Salvador Jacinto 20:30
Re: "could not receive data from client" && "incomplete startup packet" Alvaro Herrera 20:46
Re: LDAP for postgres John Scalia 21:13
Re: LDAP for postgres Stephen Frost 21:18
Re: Critical errors during logical decoding Tomas Vondra 21:18
Re: Critical errors during logical decoding Colin Morelli 21:22
Re: BDR, ERROR: previous init failed, manual cleanup is required Dan Wierenga 21:45
Re: "could not receive data from client" && "incomplete startup packet" David Gauthier 21:47
Re: "could not receive data from client" && "incomplete startup packet" David Gauthier 21:57
Re: "could not receive data from client" && "incomplete startup packet" Alvaro Herrera 23:24
Re: Fwd: postgres instalation Adrian Klaver 23:29

Feb. 8, 2018

Thread Author Time
Re: Critical errors during logical decoding Tomas Vondra 01:28
Re: Alter table set logged hanging after writing out all WAL Michael Paquier 03:46
Re: Documentation section F Thiemo Kellner, NHC Barhufpflege 07:07
List all columns referencing an FK Andreas Joseph Krogh 10:31
PITR Multiple recoveries Sébastien Boutté 13:07
Re: "could not receive data from client" && "incomplete startup packet" David Gauthier 14:21
Re: "could not receive data from client" && "incomplete startup packet" Tom Lane 14:49
Odd behavior with 'currval' Steven Hirsch 16:09
Re: PITR Multiple recoveries Jeff Janes 16:11
Re: Odd behavior with 'currval' David G. Johnston 16:15
Re: Odd behavior with 'currval' Adrian Klaver 16:21
there is a great difference between the query execution time and the log record time [email protected] 16:35
Re: Odd behavior with 'currval' Francisco Olarte 16:39
Re: there is a great difference between the query execution time and the log record time Adrian Klaver 16:43
Re: there is a great difference between the query execution time and the log record time Francisco Olarte 16:44
Re: there is a great difference between the query execution time and the log record time nemo 16:50
Re: there is a great difference between the query execution time and the log record time nemo 16:51
Re: there is a great difference between the query execution time and the log record time Adrian Klaver 16:54
Re: there is a great difference between the query execution time and the log record time 邓彪 17:14
Re: there is a great difference between the query execution time and the log record time Adrian Klaver 17:33
回复：there is a great difference between the query execution time and the log record time 邓彪 17:38
Re: Odd behavior with 'currval' Steven Hirsch 17:58
RE: BDR, ERROR: previous init failed, manual cleanup is required Zhu, Joshua 18:08
Re: Odd behavior with 'currval' Adrian Klaver 18:09
Re: 回复：there is a great difference between the query execution time and the log record time Adrian Klaver 18:13
Re: Odd behavior with 'currval' Melvin Davidson 18:17
Re: Odd behavior with 'currval' Steven Hirsch 18:20
Re: Odd behavior with 'currval' Melvin Davidson 18:21
Re: Odd behavior with 'currval' Adrian Klaver 18:27
Re: Odd behavior with 'currval' Adrian Klaver 18:31
Re: Odd behavior with 'currval' Melvin Davidson 18:31
Re: Odd behavior with 'currval' Francisco Olarte 18:34
Re: Odd behavior with 'currval' Steven Hirsch 18:45
Re: Odd behavior with 'currval' Adrian Klaver 18:47
Re: Odd behavior with 'currval' Steven Hirsch 18:54
Re: Odd behavior with 'currval' Adrian Klaver 19:01
Re: Odd behavior with 'currval' Steven Hirsch 19:12
Re: Odd behavior with 'currval' David G. Johnston 19:34
Re: Odd behavior with 'currval' Adrian Klaver 19:35
Re: Odd behavior with 'currval' Steven Hirsch 19:51
Re: Odd behavior with 'currval' David G. Johnston 19:54
Re: Odd behavior with 'currval' David G. Johnston 19:55
DOW is 0-based? Igal @ Lucee.org 20:24
Re: DOW is 0-based? Igor Korot 20:57
Re: Odd behavior with 'currval' Steven Hirsch 21:22
Re: Odd behavior with 'currval' David G. Johnston 21:27
Re: Odd behavior with 'currval' Steven Hirsch 21:52
Re: PITR Multiple recoveries Sébastien Boutté 22:13

Feb. 9, 2018

Thread Author Time
Re: DOW is 0-based? Thomas Kellerer 07:23
Re: Odd behavior with 'currval' Francisco Olarte 15:27
Re: Odd behavior with 'currval' David G. Johnston 15:45
Re: Odd behavior with 'currval' Francisco Olarte 15:47
testing for DEFAULT insert value in ON CONFLICT DO UPDATE query Geoff Winkless 16:31

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