pgsql-general since 2017-02-27 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

Feb. 27, 2017

Thread Author Time
Re: Re: Causeless CPU load waves in backend, on windows, 9.5.5 (EDB binary). Nikolai Zhubr 07:08
Re: Full Text Search combined with Fuzzy Oleg Bartunov 09:32
Re: Foreign key references a unique index instead of a primary key Arjen Nienhuis 10:22
Re: ERROR: functions in index expression must be marked IMMUTABLE Sven R. Kunze 10:52
Re: ERROR: functions in index expression must be marked IMMUTABLE Geoff Winkless 11:10
Re: via psycopg2 or pg2pg? Move rows from one database to other Thomas Güttler 11:47
hight cpu %sy usage [email protected] 14:13
Re: ERROR: functions in index expression must be marked IMMUTABLE Sven R. Kunze 15:03
cpu hight sy% usage [email protected] 15:13
Re: ERROR: functions in index expression must be marked IMMUTABLE Adrian Klaver 15:37
Re: ERROR: functions in index expression must be marked IMMUTABLE Sven R. Kunze 17:08
Re: ERROR: functions in index expression must be marked IMMUTABLE Adrian Klaver 17:17
Re: hight cpu %sy usage Jeff Janes 18:00
Re: via psycopg2 or pg2pg? Move rows from one database to other Francisco Olarte 18:37
Question about TOAST table - PostgreSQL 9.2 Patrick B 19:44
Conferences for a DBA? Nathan Stocks 23:25
Re: Conferences for a DBA? cen 23:36
Re: Conferences for a DBA? Joe Conway 23:37
Re: Conferences for a DBA? Joshua D. Drake 23:39

Feb. 28, 2017

Thread Author Time
Re: Conferences for a DBA? Nathan Stocks 00:00
Shared WAL archive between master and standby: WALs not always identical Sasa Vilic 00:40
Re: Shared WAL archive between master and standby: WALs not always identical Adrian Klaver 00:57
Re: Shared WAL archive between master and standby: WALs not always identical David G. Johnston 01:10
Re: Shared WAL archive between master and standby: WALs not always identical Sasa Vilic 01:29
Re: Shared WAL archive between master and standby: WALs not always identical Sasa Vilic 01:33
Re: Shared WAL archive between master and standby: WALs not always identical Sasa Vilic 01:45
Re: Shared WAL archive between master and standby: WALs not always identical David G. Johnston 01:46
Re: Shared WAL archive between master and standby: WALs not always identical Adrian Klaver 01:48
Re: Shared WAL archive between master and standby: WALs not always identical David G. Johnston 01:50
Re: Shared WAL archive between master and standby: WALs not always identical Sasa Vilic 01:52
Re: Shared WAL archive between master and standby: WALs not always identical David G. Johnston 02:01
Re: Shared WAL archive between master and standby: WALs not always identical Sasa Vilic 02:32
Re: Shared WAL archive between master and standby: WALs not always identical David G. Johnston 02:55
pg_xlog keeps growing dhanuj hippie 03:33
Re: pg_xlog keeps growing Rob Sargent 03:46
Re: pg_xlog keeps growing dhanuj hippie 04:17
Re: pg_xlog keeps growing dhanuj hippie 04:20
Re: cpu hight sy% usage Tom Lane 04:37
Re: pg_xlog keeps growing Michael Paquier 04:38
Re: Shared WAL archive between master and standby: WALs not always identical Adrian Klaver 05:14
Re: pg_xlog keeps growing dhanuj hippie 05:49
Re: pg_xlog keeps growing David G. Johnston 06:17
Re: Shared WAL archive between master and standby: WALs not always identical Sasa Vilic 07:14
is (not) distinct from Johann Spies 08:08
Re: ERROR: functions in index expression must be marked IMMUTABLE Sven R. Kunze 09:35
Re: GMT FATAL: remaining connection slots are reserved for non-replication superuser connections, but I'm using pgBouncer for connection pooling Lisandro 14:01
Re: Re: GMT FATAL: remaining connection slots are reserved for non-replication superuser connections, but I'm using pgBouncer for connection pooling Tom Lane 14:07
Re: Question about TOAST table - PostgreSQL 9.2 Albe Laurenz 14:33
Re: ERROR: functions in index expression must be marked IMMUTABLE Adrian Klaver 14:40
Re: is (not) distinct from Adrian Klaver 15:06
Re: ERROR: functions in index expression must be marked IMMUTABLE Sven R. Kunze 15:30
Re: Shared WAL archive between master and standby: WALs not always identical Adrian Klaver 15:41
Re: Shared WAL archive between master and standby: WALs not always identical Jon Nelson 15:57
Re: ERROR: functions in index expression must be marked IMMUTABLE Adrian Klaver 15:59
Re: GMT FATAL: remaining connection slots are reserved for non-replication superuser connections, but I'm using pgBouncer for connection pooling Steve Crawford 16:06
Re: Re: GMT FATAL: remaining connection slots are reserved for non-replication superuser connections, but I'm using pgBouncer for connection pooling Adrian Klaver 16:14
json aggregation question Chris Withers 16:21
json aggregation question Chris Withers 16:21
Re: ERROR: functions in index expression must be marked IMMUTABLE David G. Johnston 16:32
Re: Querying JSON Lists Adrian Klaver 16:33
Re: ERROR: functions in index expression must be marked IMMUTABLE Geoff Winkless 16:35
Re: ERROR: functions in index expression must be marked IMMUTABLE David G. Johnston 16:50
Making a unique constraint deferrable? Ivan Voras 16:50
Re: Making a unique constraint deferrable? Adrian Klaver 16:58
Re: Making a unique constraint deferrable? David G. Johnston 16:59
Re: Making a unique constraint deferrable? David G. Johnston 16:59
Re: GMT FATAL: remaining connection slots are reserved for non-replication superuser connections, but I'm using pgBouncer for connection pooling Lisandro 17:00
Re: Making a unique constraint deferrable? David G. Johnston 17:03
Re: Making a unique constraint deferrable? Ivan Voras 17:05
Re: Making a unique constraint deferrable? David G. Johnston 17:10
Re: json aggregation question Yasin Sari 17:19
Re: json aggregation question Chris Withers 17:28
Re: Re: GMT FATAL: remaining connection slots are reserved for non-replication superuser connections, but I'm using pgBouncer for connection pooling Scott Marlowe 19:50
Re: Configuring ssl_crl_file Bruce Momjian 20:51
Re: Configuring ssl_crl_file Frazer McLean 21:50
Understanding pg_last_xlog_receive_location Zach Walton 21:51
Re: Configuring ssl_crl_file Bruce Momjian 22:00
Re: Shared WAL archive between master and standby: WALs not always identical Sasa Vilic 22:20
Re: Conferences for a DBA? Jaime Soler 22:42
Re: Shared WAL archive between master and standby: WALs not always identical Sasa Vilic 22:55
Re: json aggregation question Paul Jungwirth 22:59

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

Browse Archives

Prev | Next