pgsql-general - April 2016

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

April 1, 2016

Thread Author Time
Query from two tables return error arnaud gaboury 09:33
Re: Query from two tables return error arnaud gaboury 10:15
Multimaster Konstantin Knizhnik 10:33
Re: Multimaster Simon Riggs 11:38
Re: Multimaster Konstantin Knizhnik 11:50
Re: Query from two tables return error Sándor Daku 13:33
Re: Query from two tables return error arnaud gaboury 13:52
Re: Query from two tables return error Adrian Klaver 14:04
Re: Query from two tables return error arnaud gaboury 14:16
Re: Multimaster Joshua D. Drake 15:22
Re: Please advise on this trigger function Adrian Klaver 16:10
instead of triggers refreshing materialized views kovert 17:06
how to regenerate pg_control file ? Brahim EL ALLIOUI 17:44
Re: Multimaster Moreno Andreo 18:15
Re: how to regenerate pg_control file ? Adrian Klaver 18:42

April 3, 2016

Thread Author Time
plpgsql update row from record variable Seamus Abshere 01:07
CORRUPTION on TOAST table Soni M 03:38
Re: CORRUPTION on TOAST table Joshua D. Drake 03:43
Re: CORRUPTION on TOAST table Soni M 03:46
PG 9.3.12: Replication appears to have worked, but getting error messages in logs David Caldwell 05:50
Re: plpgsql update row from record variable Adrian Klaver 15:31
Re: CORRUPTION on TOAST table Adrian Klaver 16:06
Re: CORRUPTION on TOAST table Adrian Klaver 16:23

April 4, 2016

Thread Author Time
postgresql 9.3.10, FIPS mode and DRBG issues. 📎 Rodney Lott 18:04
Re: CORRUPTION on TOAST table Soni M 18:32
Re: postgresql 9.3.10, FIPS mode and DRBG issues. Tom Lane 19:51
Re: postgresql 9.3.10, FIPS mode and DRBG issues. Rodney Lott 20:22
Re: How to quote the COALESCE function? Kevin Grittner 21:49

April 5, 2016

Thread Author Time
Re: CORRUPTION on TOAST table Soni M 02:15
template1 being accessed drum.lucas@gmail.com 04:04
Re: template1 being accessed John R Pierce 04:11
Re: PG 9.3.12: Replication appears to have worked, but getting error messages in logs Michael Paquier 05:57
Re: PG 9.3.12: Replication appears to have worked, but getting error messages in logs David Caldwell 06:33
Re: template1 being accessed Luca Ferrari 06:35
Re: BSD initdb without ICU support and switch later jje 06:42
System aggregation Mark Morgan Lloyd 09:28
Shrinking TSvectors Howard News 11:37
Not signed yum repository packages Clodoaldo Neto 11:39
Re: Not signed yum repository packages Devrim Gündüz 12:15
Re: comparing two JSON objects in 9.3 yuri.ivanenko@progforce.com 12:42
Problem after replication switchover Lars Arvidson 12:55
Re: Shrinking TSvectors Oleg Bartunov 13:44
What does Rows Counted mean Rakesh Kumar 14:11
Re: Shrinking TSvectors Artur Zakirov 14:15
Re: What does Rows Counted mean Adrian Klaver 14:37
Re: Shrinking TSvectors Howard News 14:37
Re: Shrinking TSvectors Alexander Shereshevsky 14:42
Re: Shrinking TSvectors Adrian Klaver 14:45
Re: Shrinking TSvectors Howard News 14:48
I can't see wal receiver process in one node DrakoRod 15:37
Re: What does Rows Counted mean Rakesh Kumar 15:38
Re: What does Rows Counted mean Melvin Davidson 17:10
Re: What does Rows Counted mean Rakesh Kumar 17:22
Exclude constraint using custom operator Tobia Conforto 17:30
Re: What does Rows Counted mean Adrian Klaver 17:37
Re: What does Rows Counted mean Melvin Davidson 17:43
Re: Problem after replication switchover Alan Hodgson 19:37

April 6, 2016

Thread Author Time
Re: template1 being accessed Sameer Kumar 00:35
Re: I can't see wal receiver process in one node Sameer Kumar 00:37
Re: template1 being accessed John R Pierce 00:41
Re: comparing two JSON objects in 9.3 yuri.ivanenko@progforce.com 09:29
Trying to understand page structures in PG Rakesh Kumar 09:39
Re: Exclude constraint using custom operator Tobia Conforto 10:15
Re: Trying to understand page structures in PG Albe Laurenz 10:33
Re: Problem after replication switchover Lars Arvidson 10:33
what database schema version management system to use? Alexey Bashtanov 10:55
PostgreSQL 9.5.1 -> PG_REWIND NOT FOUND sgringer 11:02
Re: what database schema version management system to use? Achilleas Mantzios 11:34
Re: Exclude constraint using custom operator Tom Lane 13:50
Re: what database schema version management system to use? Adrian Klaver 13:50
Re: Trying to understand page structures in PG Joshua D. Drake 14:00
Re: what database schema version management system to use? Thomas Kellerer 14:16
database is not accepting commands to avoid wraparound data loss in database pedrovlf 15:13
Re: Trying to understand page structures in PG rob stone 15:35
Re: what database schema version management system to use? Jeff Janes 15:41
Multi-row constraints, how to avoid unnecessary trigger execution? Tobia Conforto 16:32
Re: Multi-row constraints, how to avoid unnecessary trigger execution? Sándor Daku 16:51
Re: Multi-row constraints, how to avoid unnecessary trigger execution? Andreas Joseph Krogh 16:54
Re: Multi-row constraints, how to avoid unnecessary trigger execution? Tobia Conforto 17:00
Re: Multi-row constraints, how to avoid unnecessary trigger execution? Andreas Joseph Krogh 17:44
Re: I can't see wal receiver process in one node DrakoRod 19:03
Re: pg_upgrade error regarding hstore operator Feld, Michael (IMS) 20:21
Re: Problem after replication switchover Alan Hodgson 20:48
Re: PostgreSQL 9.5.1 -> PG_REWIND NOT FOUND Adrian Klaver 22:04
Deadlock between VACUUM and ALTER TABLE commands Kevin Burke 22:22
Re: pg_upgrade error regarding hstore operator Tom Lane 23:01
Re: what database schema version management system to use? Bill Moran 23:24

April 7, 2016

Thread Author Time
Re: database is not accepting commands to avoid wraparound data loss in database Jeff Janes 01:17
Re: Trying to understand page structures in PG Jeff Janes 01:31
Re: what database schema version management system to use? John R Pierce 04:39
Re: PostgreSQL 9.5.1 -> PG_REWIND NOT FOUND sgringer 06:31
Re: PostgreSQL 9.5.1 -> PG_REWIND NOT FOUND John R Pierce 06:46
Re: Deadlock between VACUUM and ALTER TABLE commands Alexey Bashtanov 08:27
Re: Problem after replication switchover Lars Arvidson 09:20
Re: what database schema version management system to use? Berend Tober 10:21
Re: what database schema version management system to use? Karsten Hilbert 10:43
Non-default postgresql.conf values to log Alex Ignatov 12:36
Re: Trying to understand page structures in PG Rakesh Kumar 12:50
Re: Non-default postgresql.conf values to log Christoph Moench-Tegeder 13:35
Re: database is not accepting commands to avoid wraparound data loss in database Merlin Moncure 13:40
Re: PostgreSQL 9.5.1 -> PG_REWIND NOT FOUND Adrian Klaver 13:43
Re: Non-default postgresql.conf values to log Tom Lane 13:53
Re: Non-default postgresql.conf values to log Alex Ignatov 14:26
Re: Non-default postgresql.conf values to log Rob Sargent 14:59
Re: 9.5 new features Alvaro Herrera 16:31
Re: Non-default postgresql.conf values to log Alex Ignatov 17:06
Re: what database schema version management system to use? John R Pierce 17:35
Re: Non-default postgresql.conf values to log David G. Johnston 17:37
Re: Non-default postgresql.conf values to log David G. Johnston 17:39
Re: Non-default postgresql.conf values to log Adrian Klaver 17:46
Re: Non-default postgresql.conf values to log Tom Lane 17:50
Re: pg_upgrade error regarding hstore operator Feld, Michael (IMS) 20:04

April 8, 2016

Thread Author Time
Re: [GENERAL] pg_restore casts check constraints differently Victor Pontis 00:16
Re: Trying to understand page structures in PG Albe Laurenz 09:08
Re: Trying to understand page structures in PG Albe Laurenz 09:18
Shipping big WAL archives to hot standby Jordi 09:22
max_stack_depth problem though query is substantially smaller Charles Clavadetscher 10:19
Please let me know the latest PostgreSQL version available on Solaris 11? M Tarkeshwar Rao 10:50
Re: Please let me know the latest PostgreSQL version available on Solaris 11? Raymond O'Donnell 11:06
Re: max_stack_depth problem though query is substantially smaller Albe Laurenz 11:25
Postgresql 9.3.4 file system compatibility Marllius 12:56
Re: Postgresql 9.3.4 file system compatibility Bob Lunney 13:00
Re: Postgresql 9.3.4 file system compatibility Marllius 13:16
Re: what database schema version management system to use? Merlin Moncure 14:09
Re: max_stack_depth problem though query is substantially smaller Tom Lane 14:20
Re: Postgresql 9.3.4 file system compatibility Scott Mead 14:20
Re: Transitioning to a SQL db Karl O. Pinc 15:04
Bypassing NULL elements in row_to_json function Michael Nolan 15:31
recover from this error Scott Ribe 15:44
Re: Bypassing NULL elements in row_to_json function Raymond O'Donnell 15:53
Re: max_stack_depth problem though query is substantially smaller Bannert Matthias 16:31
Re: Bypassing NULL elements in row_to_json function David G. Johnston 16:44
Re: Bypassing NULL elements in row_to_json function Adrian Klaver 16:47
Re: Transitioning to a SQL db Adrian Klaver 17:07
Re: recover from this error Melvin Davidson 17:28
Re: Postgresql 9.3.4 file system compatibility John R Pierce 17:28
Re: Bypassing NULL elements in row_to_json function Michael Nolan 18:10
pg_upgrade with an extension name change Christophe Pettus 19:15
Re: max_stack_depth problem though query is substantially smaller Tom Lane 19:39
Re: max_stack_depth problem though query is substantially smaller Bannert Matthias 19:52
Re: what database schema version management system to use? Karsten Hilbert 21:44

April 9, 2016

Thread Author Time
9.5 - Is there any way to disable automatic rollback? durumdara@gmail.com 07:00
Re: 9.5 - Is there any way to disable automatic rollback? David G. Johnston 07:29
Really unique session ID - PID + connection timestamp? Durumdara 08:30
Re: Really unique session ID - PID + connection timestamp? Christoph Berg 10:07
Re: Really unique session ID - PID + connection timestamp? John R Pierce 10:30
Re: max_stack_depth problem though query is substantially smaller Bannert Matthias 10:50
Re: Really unique session ID - PID + connection timestamp? Stephen Frost 11:42
Re: Really unique session ID - PID + connection timestamp? Durumdara 11:48
Re: Really unique session ID - PID + connection timestamp? Stephen Frost 11:57
Re: Really unique session ID - PID + connection timestamp? Christoph Berg 12:40
Re: 9.5 - Is there any way to disable automatic rollback? Adrian Klaver 13:56
Re: Really unique session ID - PID + connection timestamp? Adrian Klaver 14:05
Re: Bypassing NULL elements in row_to_json function Michael Nolan 14:29
Re: Really unique session ID - PID + connection timestamp? Tom Lane 15:14
Re: max_stack_depth problem though query is substantially smaller Tom Lane 15:25

April 10, 2016

Thread Author Time
Re: Bypassing NULL elements in row_to_json function Michael Nolan 04:48
Re: Really unique session ID - PID + connection timestamp? Durumdara 07:07
Re: Bypassing NULL elements in row_to_json function David G. Johnston 07:30
Re: Shipping big WAL archives to hot standby Venkata Balaji N 08:05
Re: max_stack_depth problem though query is substantially smaller Bannert Matthias 09:06
Re: Really unique session ID - PID + connection timestamp? Alban Hertroys 11:05
Re: Really unique session ID - PID + connection timestamp? durumdara@gmail.com 13:29
Re: max_stack_depth problem though query is substantially smaller Tom Lane 14:29
Re: Bypassing NULL elements in row_to_json function Michael Nolan 14:49
Re: Bypassing NULL elements in row_to_json function David G. Johnston 15:14
Re: Bypassing NULL elements in row_to_json function Adrian Klaver 15:23
Re: Really unique session ID - PID + connection timestamp? David G. Johnston 15:29
Re: Bypassing NULL elements in row_to_json function Michael Nolan 15:39
Re: Bypassing NULL elements in row_to_json function Adrian Klaver 15:56
Re: Really unique session ID - PID + connection timestamp? Adrian Klaver 16:03
Re: Bypassing NULL elements in row_to_json function David G. Johnston 16:24
Re: Bypassing NULL elements in row_to_json function Michael Nolan 16:53
Re: Bypassing NULL elements in row_to_json function Adrian Klaver 19:32
Re: Multimaster Dorian Hoxha 21:48

April 11, 2016

Thread Author Time
Re: Postgresql 9.3.4 file system compatibility Albe Laurenz 07:52
Re: Postgresql 9.3.4 file system compatibility John R Pierce 08:04
Re: Postgresql 9.3.4 file system compatibility Marllius 10:27
Re: Postgresql 9.3.4 file system compatibility Stephen Frost 12:21
How to build docs from master? Andreas Joseph Krogh 12:27
Re: Really unique session ID - PID + connection timestamp? Durumdara 12:44
Re: How to build docs from master? Artur Zakirov 13:05
Re: How to build docs from master? Andreas Joseph Krogh 13:10
Re: 9.5 - Is there any way to disable automatic rollback? Durumdara 14:01
Re: 9.5 - Is there any way to disable automatic rollback? Marc Mamin 14:17

April 12, 2016

Thread Author Time
pgpool-II: cannot use serializable mode in a hot standby Alexander Pyhalov 08:06
Freezing localtimestamp and other time function on some value Alex Ignatov 10:50
Re: Freezing localtimestamp and other time function on some value Petr Korobeinikov 11:31
Re: Freezing localtimestamp and other time function on some value Pavel Stehule 11:47
Re: Freezing localtimestamp and other time function on some value Petr Korobeinikov 12:11
Re: Freezing localtimestamp and other time function on some value Rakesh Kumar 12:13
Re: Freezing localtimestamp and other time function on some value Alex Ignatov 12:27
Re: pgpool-II: cannot use serializable mode in a hot standby Adrian Klaver 13:50
Re: Freezing localtimestamp and other time function on some value George Neuner 13:57
Re: pgpool-II: cannot use serializable mode in a hot standby Alexander Pyhalov 14:02
Re: pgpool-II: cannot use serializable mode in a hot standby Adrian Klaver 14:17
Fastest way to duplicate a quite large database Edson Richter 14:25
Re: Freezing localtimestamp and other time function on some value Alex Ignatov 14:36
Re: Fastest way to duplicate a quite large database John R Pierce 14:46
Re: Fastest way to duplicate a quite large database Edson Richter 14:51

Browse Archives

Prev | Next