pgsql-general - March 2017

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 29 30 31

March 1, 2017

Thread Author Time
Re: Shared WAL archive between master and standby: WALs not always identical Adrian Klaver 00:15
array_to_json - dealing with returning no rows Jong-won Choi 01:31
Re: array_to_json - dealing with returning no rows Jong-won Choi 02:06
emitting all plans considered for a query (as opposed to just the winning one) Dan Hitt 03:32
Re: [GENERAL] C++ port of Postgres 📎 Peter Eisentraut 04:42
Re: Understanding pg_last_xlog_receive_location Michael Paquier 05:47
Re: [GENERAL] C++ port of Postgres Andres Freund 06:30
Re: is (not) distinct from Johann Spies 08:15
Re: ERROR: functions in index expression must be marked IMMUTABLE Sven R. Kunze 13:36
Re: ERROR: functions in index expression must be marked IMMUTABLE Geoff Winkless 13:40
Re: ERROR: functions in index expression must be marked IMMUTABLE Sven R. Kunze 14:23
Re: is (not) distinct from Adrian Klaver 15:18
Re: is (not) distinct from Tom Lane 16:12
appropriate column for storing ipv4 address jonathan vanasco 16:39
Re: appropriate column for storing ipv4 address Paul Jungwirth 16:57
Re: appropriate column for storing ipv4 address Steve Atkins 18:03
Re: disk writes within a transaction jonathan vanasco 18:19
Re: Understanding pg_last_xlog_receive_location Zach Walton 19:17
Re: Understanding pg_last_xlog_receive_location Zach Walton 20:53
Re: Re: Causeless CPU load waves in backend, on windows, 9.5.5 (EDB binary). Nikolai Zhubr 21:43

March 2, 2017

Thread Author Time
Re: Understanding pg_last_xlog_receive_location Michael Paquier 00:36
Load a csv to remote postgresql database priyanka raghav 06:01
Re: Load a csv to remote postgresql database Pavel Stehule 06:08
Re: Load a csv to remote postgresql database John R Pierce 06:34
column "waiting" does not exist Johann Spies 08:27
Re: column "waiting" does not exist Charles Clavadetscher 08:43
Ynt: column "waiting" does not exist Neslisah Demirci 08:54
Re: appropriate column for storing ipv4 address Emre Hasegeli 10:12
Re: Setup pgpool-II with streaming replication subash 10:48
Re: column "waiting" does not exist Johann Spies 13:20
pg_restore successful with warnings returns exit code of non-zero dhanuj hippie 15:39
Re: pg_restore successful with warnings returns exit code of non-zero Adrian Klaver 16:06
Postgres 9.x table/index stats reset timestamp Dave Quello 18:03
PG on SSD scott ribe 19:42
CentOS 7.3, PostgreSQL 9.6.2, PHP 5.4 deliver array as string Alexander Farber 20:45
Re: Querying JSON Lists Sven R. Kunze 21:09
Re: CentOS 7.3, PostgreSQL 9.6.2, PHP 5.4 deliver array as string Adrian Klaver 21:12
Re: CentOS 7.3, PostgreSQL 9.6.2, PHP 5.4 deliver array as string David G. Johnston 21:29
Re: CentOS 7.3, PostgreSQL 9.6.2, PHP 5.4 deliver array as string Alexander Farber 21:30
Re: CentOS 7.3, PostgreSQL 9.6.2, PHP 5.4 deliver array as string Alexander Farber 21:32
Re: CentOS 7.3, PostgreSQL 9.6.2, PHP 5.4 deliver array as string Thomas Kellerer 21:46
Re: CentOS 7.3, PostgreSQL 9.6.2, PHP 5.4 deliver array as string Adrian Klaver 22:36
Re: Understanding pg_last_xlog_receive_location Zach Walton 23:04
Re: PG on SSD Scott Marlowe 23:31

March 3, 2017

Thread Author Time
Re: Postgres 9.x table/index stats reset timestamp Michael Paquier 00:31
Re: CentOS 7.3, PostgreSQL 9.6.2, PHP 5.4 deliver array as string rob stone 02:40
DISTINCT vs GROUP BY - was Re: is (not) distinct from George Neuner 05:26
Re: CentOS 7.3, PostgreSQL 9.6.2, PHP 5.4 deliver array as string Alexander Farber 07:32
Re: CentOS 7.3, PostgreSQL 9.6.2, PHP 5.4 deliver array as string Alexander Farber 07:33
Autoanalyze oddity Peter J. Holzer 08:33
Re: PG on SSD Achilleas Mantzios 09:24
Re: DISTINCT vs GROUP BY - was Re: is (not) distinct from Sven R. Kunze 09:51
Re: ERROR: functions in index expression must be marked IMMUTABLE Geoff Winkless 10:43
Re: ERROR: functions in index expression must be marked IMMUTABLE Sven R. Kunze 11:44
PortalSuspended Rui Pacheco 11:51
Re: ERROR: functions in index expression must be marked IMMUTABLE Sven R. Kunze 12:17
Re: Full Text Search combined with Fuzzy Nicolas Paris 12:49
Re: ERROR: functions in index expression must be marked IMMUTABLE Geoff Winkless 12:58
Re: Full Text Search combined with Fuzzy Artur Zakirov 13:08
Re: Full Text Search combined with Fuzzy Nicolas Paris 13:17
Re: DISTINCT vs GROUP BY - was Re: is (not) distinct from David Rowley 13:32
Re: Full Text Search combined with Fuzzy Artur Zakirov 14:03
Re: Autoanalyze oddity Adrian Klaver 14:39
Re: Querying JSON Lists Adrian Klaver 15:05
Re: PortalSuspended Tom Lane 15:21
odd optimizer result, index condition "is not null" on column defined as "not null" Martin F 16:41
Re: odd optimizer result, index condition "is not null" on column defined as "not null" Martin Frb 17:11
Re: odd optimizer result, index condition "is not null" on column defined as "not null" Martin F 17:12
Re: odd optimizer result, index condition "is not null" on column defined as "not null" Tom Lane 17:33
Re: odd optimizer result, index condition "is not null" on column defined as "not null" Martin F 18:06
Re: odd optimizer result, index condition "is not null" on column defined as "not null" Martin F 18:45
Re: Querying JSON Lists Sven R. Kunze 19:50
Re: Querying JSON Lists Adrian Klaver 20:48

March 4, 2017

Thread Author Time
Re: DISTINCT vs GROUP BY - was Re: is (not) distinct from George Neuner 07:36

March 5, 2017

Thread Author Time
Re: Autoanalyze oddity Peter J. Holzer 11:01
Re: Autoanalyze oddity Adrian Klaver 16:39
Re: Autoanalyze oddity Peter J. Holzer 18:42

March 6, 2017

Thread Author Time
parameter type is unknown error Günce Kaya 11:28
Fwd: parameter type is unknown error Günce Kaya 11:36
Re: Fwd: parameter type is unknown error Charles Clavadetscher 11:51
Re: Fwd: parameter type is unknown error Raymond O'Donnell 11:57
Re: Fwd: parameter type is unknown error Günce Kaya 12:00
Re: Fwd: parameter type is unknown error Günce Kaya 12:20
Re: Fwd: parameter type is unknown error Charles Clavadetscher 12:22
Re: Fwd: parameter type is unknown error Tom Lane 12:36
Re: Fwd: parameter type is unknown error Günce Kaya 12:36
Re: Fwd: parameter type is unknown error Charles Clavadetscher 12:51
Re: parameter type is unknown error 📎 Samed YILDIRIM 13:27
Re: Fwd: parameter type is unknown error Adrian Klaver 14:12
Re: Fwd: parameter type is unknown error Charles Clavadetscher 14:20

March 7, 2017

Thread Author Time
Re: Fwd: parameter type is unknown error Günce Kaya 04:18
Copy database to another host without data from specific tables Panagiotis Atmatzidis 07:02
Re: Copy database to another host without data from specific tables Condor 07:43
Re: Copy database to another host without data from specific tables Condor 07:43
Re: Copy database to another host without data from specific tables Achilleas Mantzios 08:39
Re: is (not) distinct from Johann Spies 09:22
Re: Copy database to another host without data from specific tables Vick Khera 13:02
Re: intentional or oversight? pg_dump -c does not restore default priviliges on schema public Stephen Frost 14:32
Re: is (not) distinct from Adrian Klaver 15:04
Re: Feature request - psql --quote-variable Caleb Cushing 20:04
Running TAP regression tests under windows/msvc Mark Dilger 20:24
Re: Feature request - psql --quote-variable Pavel Stehule 20:29
PGSQL 9.6.2 unable to find readline John Iliffe 20:38
Re: Feature request - psql --quote-variable David G. Johnston 20:46
Re: PGSQL 9.6.2 unable to find readline Devrim Gündüz 21:12
Re: PGSQL 9.6.2 unable to find readline admin 21:16
Re: Running TAP regression tests under windows/msvc Mark Dilger 21:30
Re: PGSQL 9.6.2 unable to find readline John Iliffe 21:33
Re: PGSQL 9.6.2 unable to find readline Adrian Klaver 22:32
Postgres, apps, special characters and UTF-8 encoding Ken Tanzer 23:20
Re: Postgres, apps, special characters and UTF-8 encoding David G. Johnston 23:32

March 8, 2017

Thread Author Time
Re: Postgres, apps, special characters and UTF-8 encoding Adrian Klaver 00:25
Re: Postgres, apps, special characters and UTF-8 encoding rob stone 01:41
Unable to start postgresql John Iliffe 04:17
Re: Copy database to another host without data from specific tables Panagiotis Atmatzidis 04:26
Re: Unable to start postgresql Melvin Davidson 04:26
Request to confirm which command is use for exclusive operation Yogesh Sharma 04:46
Re: Unable to start postgresql Tom Lane 05:01
Re: Unable to start postgresql Adrian Klaver 05:09
Re: Request to confirm which command is use for exclusive operation David G. Johnston 06:03
Re: Request to confirm which command is use for exclusive operation Yogesh Sharma 06:21
Re: Request to confirm which command is use for exclusive operation Scott Marlowe 06:55
Re: Request to confirm which command is use for exclusive operation Scott Marlowe 06:57
Re: Postgres, apps, special characters and UTF-8 encoding vinny 07:54
Re: Request to confirm which command is use for exclusive operation Yogesh Sharma 08:30
import CSV file to a table Günce Kaya 09:13
Re: Request to confirm which command is use for exclusive operation Albe Laurenz 09:24
Re: Postgres, apps, special characters and UTF-8 encoding Albe Laurenz 09:47
too may LWLocks hariprasath nallasamy 10:04
Re: Request to confirm which command is use for exclusive operation Yogesh Sharma 10:42
Re: import CSV file to a table Vick Khera 13:02
Re: import CSV file to a table John McKown 13:55
Re: import CSV file to a table Martijn Tonies (Upscene Productions) 14:13
Re: Request to confirm which command is use for exclusive operation Albe Laurenz 14:15
Re: import CSV file to a table vinny 14:45
Re: Unable to start postgresql John Iliffe 14:52
Re: import CSV file to a table John McKown 14:53
Re: Unable to start postgresql Tom Lane 15:00
Re: Unable to start postgresql Melvin Davidson 15:11
Re: Unable to start postgresql John Iliffe 15:37
Re: Unable to start postgresql John Iliffe 15:44
Re: Request to confirm which command is use for exclusive operation David G. Johnston 15:56
Re: Request to confirm which command is use for exclusive operation David G. Johnston 16:01
Re: Unable to start postgresql Adrian Klaver 16:03
Re: import CSV file to a table Karl Czajkowski 16:13
Re: Unable to start postgresql Adrian Klaver 16:18
Re: import CSV file to a table David G. Johnston 16:21
Re: import CSV file to a table Rob Sargent 16:24
Re: import CSV file to a table Karl Czajkowski 16:36
Re: Unable to start postgresql Adrian Klaver 16:37
Re: import CSV file to a table Rob Sargent 16:45
Re: Unable to start postgresql Rob Sargent 16:47
Re: import CSV file to a table Karl Czajkowski 16:52
Re: import CSV file to a table Bret Stern 16:54
Re: import CSV file to a table Rob Sargent 17:00
Re: Unable to start postgresql John Iliffe 18:12
Re: Unable to start postgresql Adrian Klaver 18:20
Re: Unable to start postgresql John Iliffe 18:25
Re: Unable to start postgresql Adrian Klaver 18:34
Re: too may LWLocks Julien Rouhaud 19:37
Re: Unable to start postgresql Tom Lane 20:13
Re: Unable to start postgresql John Iliffe 21:28
Re: Unable to start postgresql Adrian Klaver 21:40
Re: Unable to start postgresql John Iliffe 21:48
Re: Unable to start postgresql Adrian Klaver 22:11
Re: Unable to start postgresql Adrian Klaver 22:22
Seq scan X Index scan Patrick B 22:32
Re: Seq scan X Index scan David G. Johnston 22:41

March 9, 2017

Thread Author Time
Re: Unable to start postgresql John Iliffe 04:15
Re: Unable to start postgresql John Iliffe 04:21
count case when - PG 9.2 Patrick B 04:27
Re: import CSV file to a table Günce Kaya 04:35
Re: Unable to start postgresql Tom Lane 04:35
Which release does a commit end up getting into? jpap00 04:41
Re: Which release does a commit end up getting into? Michael Paquier 04:56
Re: count case when - PG 9.2 David G. Johnston 05:02
Re: Unable to start postgresql John Iliffe 05:09
Re: too may LWLocks hariprasath nallasamy 05:25
Re: Unable to start postgresql Tom Lane 05:28
Re: count case when - PG 9.2 vinny 10:15
Recovery damaged dump file mac pack 11:55
Help regarding flushing data from Shared Memory to Database Naveen Raj 13:24
Help regarding flushing data from Shared Memory to Database Naveen Raj 13:28
Re: Unable to start postgresql Adrian Klaver 14:17
Re: Unable to start postgresql John Iliffe 16:14
Re: Unable to start postgresql Tom Lane 17:08
Re: Unable to start postgresql John Iliffe 17:28
Re: Unable to start postgresql Tom Lane 17:49
Re: Unable to start postgresql John Iliffe 19:51
Re: Unable to start postgresql Adrian Klaver 20:09
Re: count case when - PG 9.2 Patrick B 21:01
Re: count case when - PG 9.2 David G. Johnston 21:05
Re: count case when - PG 9.2 Yasin Sari 21:17
Re: Unable to start postgresql Adrian Klaver 21:18
Re: count case when - PG 9.2 Patrick B 21:19
Re: Unable to start postgresql Adrian Klaver 21:37

March 10, 2017

Thread Author Time
Re: Recovery damaged dump file Michael Paquier 01:35
Re: Removing and readding bdr nodes Nathan Valentine 02:12
Re: Unable to start postgresql John Iliffe 03:01
Re: Recovery damaged dump file Adrian Klaver 05:09

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 29 30 31