pgsql-general - October 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 29 30 31

Oct. 1, 2018

Thread Author Time
Re: Postgres trigger side-effect is occurring out of order with row-level security select policy Charles Clavadetscher (SwissPUG) 02:56
Re: Postgres trigger side-effect is occurring out of order with row-level security select policy Carl Sverre 02:59
Re: Postgres trigger side-effect is occurring out of order with row-level security select policy Charles Clavadetscher (SwissPUG) 03:18
Re: Postgres trigger side-effect is occurring out of order with row-level security select policy Charles Clavadetscher (SwissPUG) 03:53
Re: Why my query not using index to sort? Arup Rakshit 04:26
Re: regarding bdr extension Durgamahesh Manne 08:08
libpq.dll question hamann.w 08:14
Re: libpq.dll question Dmitry Igrishin 09:24
backend_xmin in pg_stat_replication Torsten Förtsch 10:20
Re: Postgres trigger side-effect is occurring out of order with row-level security select policy Dean Rasheed 11:02
Re: libpq.dll question Adrian Klaver 13:18
Re: Why my query not using index to sort? Adrian Klaver 13:56
Re: libpq.dll question Adrian Klaver 13:59
Re: regarding bdr extension Adrian Klaver 14:04
Re: backend_xmin in pg_stat_replication Andres Freund 15:32
PostgreSQL FIPS 140-2 on Window Bradley May 15:44
Re: regarding bdr extension Durgamahesh Manne 16:00
Re: PostgreSQL FIPS 140-2 on Window Tom Lane 16:08
Re: backend_xmin in pg_stat_replication Torsten Förtsch 16:39
Re: PostgreSQL FIPS 140-2 on Window Joe Conway 17:17
Price Request MXO-PPQ-101164 Pichardo, Ari 18:02
CREATE TABLE AS SELECT hangs derek 18:35
Re: Price Request MXO-PPQ-101164 Andreas Kretschmer 19:55
Re: Postgres trigger side-effect is occurring out of order with row-level security select policy Carl Sverre 20:45
Re: CREATE TABLE AS SELECT hangs Tom Lane 21:29
Postgres 11 procedures and result sets Jan Kohnert 21:53
Re: CREATE TABLE AS SELECT hangs derek 22:20
Re: Postgres 11 procedures and result sets Tom Lane 23:57

Oct. 2, 2018

Thread Author Time
Postgres 11, partitioning with a custom hash function Harry B 04:41
how to identify the timeline of specified recovery_target_time when do multiple PITR magodo 05:46
Re: Postgres trigger side-effect is occurring out of order with row-level security select policy Dean Rasheed 08:28
pg_sleep() inside plpgsql block - pro & cons pinker 10:10
Re: pg_sleep() inside plpgsql block - pro & cons Francisco Olarte 10:26
Re: regarding bdr extension Adrian Klaver 13:29
Re: pg_sleep() inside plpgsql block - pro & cons pinker 13:44
Re: regarding bdr extension Andreas Kretschmer 13:52
Re: Postgres 11 procedures and result sets Merlin Moncure 16:33
FTS trigger works 1 at a time, but fails with bulk insert script Malik Rumi 17:34
Re: pg_sleep() inside plpgsql block - pro & cons Francisco Olarte 17:47
Re: Postgres trigger side-effect is occurring out of order with row-level security select policy 📎 Carl Sverre 19:12
metadata about creation and size of tables Martin Mueller 20:38
How can I get and handle the status of sql statements that run in plpgsql ? David Gauthier 20:47
Re: How can I get and handle the status of sql statements that run in plpgsql ? Christopher Browne 21:18
Re: How can I get and handle the status of sql statements that run in plpgsql ? Adrian Klaver 21:27
Re: metadata about creation and size of tables Adrian Klaver 21:41
Re: FTS trigger works 1 at a time, but fails with bulk insert script Adrian Klaver 23:27

Oct. 3, 2018

Thread Author Time
Re: how to identify the timeline of specified recovery_target_time when do multiple PITR Laurenz Albe 06:06
Re: pg_sleep() inside plpgsql block - pro & cons Laurenz Albe 06:12
Re: regarding bdr extension Durgamahesh Manne 07:30
DB size difference after restore Sonam Sharma 12:42
Re: DB size difference after restore Benjamin Scherrey 12:46
Re: DB size difference after restore Sonam Sharma 12:51
Re: DB size difference after restore Fabio Pardi 12:58
Re: DB size difference after restore Sonam Sharma 12:59
Re: DB size difference after restore Chris Travers 13:03
GIN multi-column index Floris Van Nee 13:10
Re: How can I get and handle the status of sql statements that run in plpgsql ? David Gauthier 15:46
Re: How can I get and handle the status of sql statements that run in plpgsql ? David Gauthier 16:25
Re: How can I get and handle the status of sql statements that run in plpgsql ? David G. Johnston 16:34
Re: How can I get and handle the status of sql statements that run in plpgsql ? Pavel Stehule 16:35
Re: Postgres 11, partitioning with a custom hash function Harry B 16:37

Oct. 4, 2018

Thread Author Time
Re: Postgres 11, partitioning with a custom hash function Harry B 03:22
Re: Postgres 11, partitioning with a custom hash function David Rowley 03:42
Using RETURNING with INSERT TRIGGER on 9.6 partitioned table Satoshi Nagayasu 08:25
We are facing "PANIC: could not read from control file:Success error while starting the database. Raghavendra Rao J S V 15:29
Re: We are facing "PANIC: could not read from control file:Success error while starting the database. Andreas Kretschmer 15:50
Re: Postgres 11, partitioning with a custom hash function Harry B 17:18
Re: Postgres 11, partitioning with a custom hash function David Rowley 19:39
Re: Postgres 11, partitioning with a custom hash function Harry B 20:43

Oct. 5, 2018

Thread Author Time
Re: Postgres 11, partitioning with a custom hash function David Rowley 00:39
Re: We are facing "PANIC: could not read from control file:Success error while starting the database. Thomas Munro 01:35
pg_pass and pg_service Tim Uckun 04:47
Re: pg_pass and pg_service David G. Johnston 05:17
Re: We are facing "PANIC: could not read from control file:Success error while starting the database. Raghavendra Rao J S V 05:33
Re: We are facing "PANIC: could not read from control file:Success error while starting the database. Laurenz Albe 06:38
Barman issue Rijo Roy 09:50
Does postgreSQL community edition supports data distribution across nodes deepikags 09:54
Re: Does postgreSQL community edition supports data distribution across nodes Fabio Pardi 11:34
Re: Does postgreSQL community edition supports data distribution across nodes James Keener 12:45
Prevent locked state (row lock + alter table) Durumdara 12:55
COPY from a remote machine in Datastage Ravi Krishna 14:05
Re: COPY from a remote machine in Datastage Josef Šimánek 14:12
Re: COPY from a remote machine in Datastage Ravi Krishna 14:18
Re: COPY from a remote machine in Datastage Josef Šimánek 14:24
Re: COPY from a remote machine in Datastage Ron 14:35
Re: COPY from a remote machine in Datastage Ravi Krishna 14:37
Re: COPY from a remote machine in Datastage Edmundo Robles 15:15
Regarding varchar max length in postgres Durgamahesh Manne 15:18
Re: Regarding varchar max length in postgres Adrian Klaver 15:25
Re: survey: pg_stat_statements total_time and entry deallocation Jeremy Schneider 20:47
Re: survey: pg_stat_statements total_time and entry deallocation legrand legrand 22:33

Oct. 6, 2018

Thread Author Time
Why the index is not used ? ROS Didier 09:57
Re: Why the index is not used ? Pavel Stehule 10:13
Re: Why the index is not used ? Vladimir Ryabtsev 16:51
Text-indexing UTF-8 bytea, convert_from() immutability, null bytes... Phil Endecott 21:56

Oct. 7, 2018

Thread Author Time
Re: Why the index is not used ? Paul McGarry 02:20
Re: Text-indexing UTF-8 bytea, convert_from() immutability, null bytes... Andrew Gierth 02:52
Re: Text-indexing UTF-8 bytea, convert_from() immutability, null bytes... Phil Endecott 12:45
RE: Why the index is not used ? ROS Didier 13:13
RE: Why the index is not used ? ROS Didier 13:20
Re: Why the index is not used ? Francisco Olarte 15:58
RE: Why the index is not used ? ROS Didier 18:32
RE: Why the index is not used ? Kumar, Virendra 18:41
Re: Why the index is not used ? Vladimir Ryabtsev 18:48
RE: Why the index is not used ? Phil Endecott 19:17
Re: Why the index is not used ? Vladimir Ryabtsev 19:32
Re: Why the index is not used ? Tomas Vondra 20:07
Re: Why the index is not used ? Paul McGarry 22:10

Oct. 8, 2018

Thread Author Time
pg_controldata: could not read file "/opt/postgres/9.2/data//global/pg_control": Success Raghavendra Rao J S V 05:39
RE: Why the index is not used ? ROS Didier 06:29
Re: pg_controldata: could not read file "/opt/postgres/9.2/data//global/pg_control": Success Rajni Baliyan 07:10
pg9.6: no backup history file (*.backup) created on hot standby magodo 07:23
RE: Why the index is not used ? ROS Didier 08:32
Re: Why the index is not used ? Jean-Paul Argudo 08:44
Re: pg9.6: no backup history file (*.backup) created on hot standby Michael Paquier 09:24
RE: Why the index is not used ? ROS Didier 11:47
RE: Why the index is not used ? ROS Didier 12:02
RE: Why the index is not used ? ROS Didier 12:07
RE: Why the index is not used ? Phil Endecott 13:14
RE: Why the index is not used ? ROS Didier 14:10
RE: Why the index is not used ? ROS Didier 14:29
RE: Why the index is not used ? ROS Didier 15:32
Re: FTS trigger works 1 at a time, but fails with bulk insert script Malik Rumi 19:29
Re: FTS trigger works 1 at a time, but fails with bulk insert script Adrian Klaver 19:56
Re: Why the index is not used ? Tomas Vondra 20:00
Re: FTS trigger works 1 at a time, but fails with bulk insert script Malik Rumi 20:25
Re: FTS trigger works 1 at a time, but fails with bulk insert script Adrian Klaver 20:32
Re: survey: pg_stat_statements total_time and entry deallocation Jeremy Schneider 20:49
Re: FTS trigger works 1 at a time, but fails with bulk insert script Malik Rumi 20:58
Re: Why the index is not used ? Paul McGarry 21:34
Re: FTS trigger works 1 at a time, but fails with bulk insert script Adrian Klaver 22:54
Re: FTS trigger works 1 at a time, but fails with bulk insert script Adrian Klaver 23:36

Oct. 9, 2018

Thread Author Time
Re: pg9.6: no backup history file (*.backup) created on hot standby Michael Paquier 02:45
Re: pg9.6: no backup history file (*.backup) created on hot standby magodo 03:45
Re: pg9.6: no backup history file (*.backup) created on hot standby Michael Paquier 03:53
pg_dump: [archiver (db)] query failed: FATAL: semop(id=10649641) failed: Identifier removed Raghavendra Rao J S V 05:31
Re: pg_dump: [archiver (db)] query failed: FATAL: semop(id=10649641) failed: Identifier removed Tom Lane 05:43
Re: pg9.6: no backup history file (*.backup) created on hot standby magodo 07:26
Re: pg9.6: no backup history file (*.backup) created on hot standby Michael Paquier 07:55
Re: pg9.6: no backup history file (*.backup) created on hot standby magodo 11:44
SELECT UNION into a text[] Alexander Farber 16:32
Re: SELECT UNION into a text[] David G. Johnston 16:39
RHEL 7 (systemd) reboot Bryce Pepper 18:06
tds_fdw binary column Aleš Zelený 19:07
Privilege mess? Thiemo Kellner 19:26
Re: Privilege mess? Christoph Moench-Tegeder 20:56
Re: tds_fdw binary column Adrian Klaver 22:08
Re: FTS trigger works 1 at a time, but fails with bulk insert script Malik Rumi 22:25
Re: FTS trigger works 1 at a time, but fails with bulk insert script Adrian Klaver 22:41
Pg_logical without subscription. Can we log the operations ? Dilshan 22:45
COPY threads Rob Sargent 22:45
Re: Privilege mess? Thiemo Kellner 22:47
Re: Privilege mess? David G. Johnston 22:59

Oct. 10, 2018

Thread Author Time
Re: RHEL 7 (systemd) reboot Adrian Klaver 00:38
pg9.6: PITR paused just after failover, need manual resume magodo 03:24
Re: Privilege mess? Thiemo Kellner 06:11
Re: pg9.6: PITR paused just after failover, need manual resume magodo 06:42
how to cleanup archive based on datetime magodo 07:00
Question about advance confirmed_flush_lsn using logic replication slot when there is no modification. mo jia 07:46
Re: how to identify the timeline of specified recovery_target_time when do multiple PITR magodo 07:52
Re: SELECT UNION into a text[] Andrew Gierth 08:29
Re: tds_fdw binary column Aleš Zelený 08:31
Re: Pg_logical without subscription. Can we log the operations ? Steve Atkins 10:33
RE: RHEL 7 (systemd) reboot Bryce Pepper 12:32
RE: RHEL 7 (systemd) reboot Bryce Pepper 12:45
Re: RHEL 7 (systemd) reboot Adrian Klaver 13:24
Re: tds_fdw binary column Adrian Klaver 13:30
Re: Barman issue Martin Marques 14:06
Re: how to cleanup archive based on datetime Adrian Klaver 14:14
Re: how to cleanup archive based on datetime Martin Marques 14:23
RE: RHEL 7 (systemd) reboot Bryce Pepper 14:37
Pgbouncer discard all Nicola Contu 15:03
Re: Pgbouncer discard all Fabio Pardi 15:31
Re: how to identify the timeline of specified recovery_target_time when do multiple PITR Laurenz Albe 16:21
Re: COPY threads Laurenz Albe 16:50
Re: COPY threads Rob Sargent 17:14
Re: RHEL 7 (systemd) reboot Adrian Klaver 19:10
Re: tds_fdw binary column Aleš Zelený 19:20
Re: COPY threads Andres Freund 19:24
Re: COPY threads Rob Sargent 19:41
Re: COPY threads Ravi Krishna 20:21
Re: COPY threads Christopher Browne 20:32
Re: COPY threads Ravi Krishna 21:02
Re: COPY threads Andres Freund 21:07
Re: COPY threads Ravi Krishna 21:15
Re: COPY threads Andres Freund 21:18
Re: COPY threads Ravi Krishna 21:19

Oct. 11, 2018

Thread Author Time
Re: tds_fdw binary column Adrian Klaver 00:48
Re: how to identify the timeline of specified recovery_target_time when do multiple PITR magodo 02:23
Please let me know which configuration setting we need to modify to speedup the pg_dump backup. Raghavendra Rao J S V 02:32
Re: Please let me know which configuration setting we need to modify to speedup the pg_dump backup. Pavan Teja 02:35
Re: Please let me know which configuration setting we need to modify to speedup the pg_dump backup. Ron 02:42
Re: Please let me know which configuration setting we need to modify to speedup the pg_dump backup. Christopher Browne 03:11
Re: Please let me know which configuration setting we need to modify to speedup the pg_dump backup. Raghavendra Rao J S V 03:14
Re: Please let me know which configuration setting we need to modify to speedup the pg_dump backup. Raghavendra Rao J S V 03:16
Re: how to identify the timeline of specified recovery_target_time when do multiple PITR Laurenz Albe 04:35
Re: Please let me know which configuration setting we need to modify to speedup the pg_dump backup. Laurenz Albe 04:44
Re: how to identify the timeline of specified recovery_target_time when do multiple PITR magodo 06:01
Want to acquire lock on tables where primary of one table is foreign key on othere Abhishek Tripathi 09:48
Fwd: Want to acquire lock on tables where primary of one table is foreign key on othere Abhishek Tripathi 09:49

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