[go: up one dir, main page]

pgsql-general - August 2019

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

Aug. 1, 2019

Thread Author Time
Re: adding more space to the existing server Ron 04:21
Cursors for PGJDBC queries 📎 Rashmi V Bharadwaj 07:10
Re: Cursors for PGJDBC queries Luca Ferrari 07:30
Re: Cursors for PGJDBC queries Luca Ferrari 07:32
Re: Cursors for PGJDBC queries Thomas Kellerer 07:43
Re: adding more space to the existing server Adrian Klaver 14:28
PGAdmin4.11.1 on Ubuntu 18.04 Tony Shelver 14:39
Re: PGAdmin4.11.1 on Ubuntu 18.04 Adrian Klaver 14:46
Re: PGAdmin4.11.1 on Ubuntu 18.04 Adrian Klaver 14:50
Re: PGAdmin4.11.1 on Ubuntu 18.04 Tony Shelver 15:28
Re: PGAdmin4.11.1 on Ubuntu 18.04 Tony Shelver 15:32
Re: PGAdmin4.11.1 on Ubuntu 18.04 Ron 15:34
Re: PGAdmin4.11.1 on Ubuntu 18.04 Adrian Klaver 15:42
compressing network packets farjad.farid 15:43
Re: PGAdmin4.11.1 on Ubuntu 18.04 Adrian Klaver 15:45
Re: compressing network packets Francisco Olarte 15:52
Re: PGAdmin4.11.1 on Ubuntu 18.04 Adrian Klaver 15:56
Re: PGAdmin4.11.1 on Ubuntu 18.04 Ray O'Donnell 16:01
Re: PGAdmin4.11.1 on Ubuntu 18.04 Daniele Varrazzo 16:05
Re: PGAdmin4.11.1 on Ubuntu 18.04 Adrian Klaver 16:14
Linux Mint - cannot find auto_explain extension Keith Roberts 17:53
Re: Linux Mint - cannot find auto_explain extension Julien Rouhaud 18:01

Aug. 2, 2019

Thread Author Time
Altering multiple column types Bharanee Rathna 05:41
Re: Altering multiple column types Luca Ferrari 06:49
Re: Altering multiple column types Luca Ferrari 07:43
Re: Altering multiple column types Bharanee Rathna 08:06
Re: PGAdmin4.11.1 on Ubuntu 18.04 Tony Shelver 08:32
Re: Altering multiple column types Luca Ferrari 08:58
PGSQL "macro" or "inplace subfunction"? Durumdara 11:57
SCRAM-SHA-256, is it possible to retrieve enough information from PG server (pg_authid etc) to perform authentication as a client Vladimir Soldatov 12:52
Re: Altering multiple column types Bharanee Rathna 13:18
Re: Altering multiple column types Tom Lane 13:53
Re: adding more space to the existing server Julie Nishimura 19:45
Re: SCRAM-SHA-256, is it possible to retrieve enough information from PG server (pg_authid etc) to perform authentication as a client Andrew Gierth 22:04
Re: Altering multiple column types Bharanee Rathna 23:29

Aug. 3, 2019

Thread Author Time
Re: adding more space to the existing server Adrian Klaver 00:49
Re: adding more space to the existing server Alban Hertroys 10:15

Aug. 4, 2019

Thread Author Time
Re: adding more space to the existing server Julie Nishimura 22:39
How to check if a field exists in NEW in trigger Igal @ Lucee.org 22:52

Aug. 5, 2019

Thread Author Time
Re: How to check if a field exists in NEW in trigger Adrian Klaver 00:29
Re: How to check if a field exists in NEW in trigger Thomas Kellerer 05:55
Re: How to check if a field exists in NEW in trigger Pavel Stehule 06:19
Compression In Postgresql 9.6 Shital A 06:30
Re: Compression In Postgresql 9.6 Ron 07:11
Re: How to check if a field exists in NEW in trigger Thomas Kellerer 08:09
Re: How to check if a field exists in NEW in trigger Pavel Stehule 08:34
Re: Compression In Postgresql 9.6 Shital A 10:12
Re: Compression In Postgresql 9.6 Imre Samu 11:46
Re: adding more space to the existing server Alban Hertroys 12:01
why toasted is created when domain is used ? PegoraroF10 12:07
Re: Compression In Postgresql 9.6 Kenneth Marshall 12:31
Re: Compression In Postgresql 9.6 Ron 13:22
Re: Compression In Postgresql 9.6 Kenneth Marshall 13:27
Aggregate not using BRIN index on timestamp Jeremy Finzel 13:45
Re: why toasted is created when domain is used ? Tom Lane 13:51
Re: Aggregate not using BRIN index on timestamp Tom Lane 14:20
Re: Aggregate not using BRIN index on timestamp Jeremy Finzel 15:10
Re: why toasted is created when domain is used ? PegoraroF10 15:16
Re: Aggregate not using BRIN index on timestamp Tom Lane 15:19
Re: adding more space to the existing server Julie Nishimura 15:27
Re: Aggregate not using BRIN index on timestamp Alvaro Herrera 15:42
Re: Aggregate not using BRIN index on timestamp Tom Lane 15:53
Re: Aggregate not using BRIN index on timestamp Alvaro Herrera 17:27
Re: How to check if a field exists in NEW in trigger Michael Lewis 18:34
How to make transaction delete see data from a just completed concurrent transaction? George Woodring 19:13
Re: How to make transaction delete see data from a just completed concurrent transaction? Tom Lane 19:20
Does pgadmin4 work with postgresql 8.4? Benedict Holland 20:15
Re: Does pgadmin4 work with postgresql 8.4? Adrian Klaver 20:48
Re: adding more space to the existing server Alban Hertroys 20:50
Re: Does pgadmin4 work with postgresql 8.4? Benedict Holland 20:51
Re: adding more space to the existing server Julie Nishimura 21:05
Re: Does pgadmin4 work with postgresql 8.4? Adrian Klaver 21:11

Aug. 6, 2019

Thread Author Time
Re: Does pgadmin4 work with postgresql 8.4? Melvin Davidson 01:22
Re: Does pgadmin4 work with postgresql 8.4? Murtuza Zabuawala 02:04
Re: Does pgadmin4 work with postgresql 8.4? Adrian Klaver 02:27
Re: Does pgadmin4 work with postgresql 8.4? Murtuza Zabuawala 05:02
Re: Does pgadmin4 work with postgresql 8.4? Luca Ferrari 07:20
vacuum & free space map Luca Ferrari 08:13
Re: Compression In Postgresql 9.6 Shital A 08:14
Preventing in-session 'set role' commands VO Ipfix 08:25
Re: Preventing in-session 'set role' commands Luca Ferrari 10:50
RE: Preventing in-session 'set role' commands Steven Winfield 11:04
Re: Does pgadmin4 work with postgresql 8.4? Benedict Holland 12:46
Re: Does pgadmin4 work with postgresql 8.4? Tony Shelver 12:55
Re: Preventing in-session 'set role' commands Tom Lane 13:47
Re: vacuum & free space map Tom Lane 13:50
Re: Does pgadmin4 work with postgresql 8.4? Adrian Klaver 14:31
Re: vacuum & free space map Luca Ferrari 16:08
Re: Does pgadmin4 work with postgresql 8.4? Luca Ferrari 16:11
Re: Does pgadmin4 work with postgresql 8.4? Adrian Klaver 18:01
Sorting composite types Miles Elam 18:23
Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure? Bryn Llewellyn 20:17
Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure? Adrian Klaver 21:02
Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure? Bryn Llewellyn 22:18
Guidance needed on an alternative take on common prefix SQL Laura Smith 23:25

Aug. 7, 2019

Thread Author Time
Re: Guidance needed on an alternative take on common prefix SQL Andy Colson 01:01
Re: Sorting composite types Laurenz Albe 06:22
Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure? Luca Ferrari 07:15
Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure? Kyotaro Horiguchi 07:26
Re: Guidance needed on an alternative take on common prefix SQL Laura Smith 09:36
pg_wal fills up on big update query Daniel Fink (PDF) 13:34
Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure? Adrian Klaver 14:19
Re: pg_wal fills up on big update query Rob Sargent 14:22
Re: pg_wal fills up on big update query Luca Ferrari 14:34
Input validation stan 18:07
Re: Input validation Adrian Klaver 18:18
Re: Input validation Rob Sargent 18:21
Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure? Bryn Llewellyn 18:28
Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure? Bryn Llewellyn 18:46
Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure? Adrian Klaver 18:56
Recomended front ends? stan 18:57
Re: Recomended front ends? Igor Korot 18:59
Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure? Luca Ferrari 19:17
Re: Recomended front ends? Adrian Klaver 19:38
Re: Recomended front ends? Rob Sargent 19:47
Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure? Bryn Llewellyn 19:54
Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure? Adrian Klaver 20:19
Re: Recomended front ends? Igor Korot 20:21
Re: Recomended front ends? Rich Shepard 20:38
Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure? David G. Johnston 20:40
Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure? Benedict Holland 21:36
Re: Input validation Benedict Holland 21:38
Re: How to check if a field exists in NEW in trigger Igal @ Lucee.org 22:54
Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure? Bryn Llewellyn 23:34
Re: How to check if a field exists in NEW in trigger David G. Johnston 23:51

Aug. 8, 2019

Thread Author Time
Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure? Bryn Llewellyn 00:02
Re: Guidance needed on an alternative take on common prefix SQL Rob Sargent 00:36
Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure? Luca Ferrari 08:19
lead() with arrays - strange behaviour Thomas Kellerer 09:06
Re: Recomended front ends? Tim Clarke 09:16
Having the issue in while selecting the data and feltering in order by. nikhil raj 09:19
Re: Having the issue in while selecting the data and feltering in order by. Luca Ferrari 10:32
Re: Having the issue in while selecting the data and feltering in order by. Francisco Olarte 10:51
Re: Having the issue in while selecting the data and feltering in order by. Francisco Olarte 10:57
Re: lead() with arrays - strange behaviour David Rowley 11:03
Re: lead() with arrays - strange behaviour Thomas Kellerer 11:59
Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure? Daniel Verite 13:53
Re: lead() with arrays - strange behaviour Tom Lane 14:10
Re: lead() with arrays - strange behaviour Thomas Kellerer 14:27
Re: Recomended front ends? Tony Shelver 16:05
Re: Recomended front ends? Stuart McGraw 16:55
Re: Recomended front ends? Adrian Klaver 17:22
Re: Recomended front ends? Rich Shepard 17:34
Re: Recomended front ends? Adrian Klaver 17:40
Re: Recomended front ends? Rich Shepard 17:47
Re: Recomended front ends? Tim Clarke 18:30
Re: Recomended front ends? Andrew Kerber 18:35
Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure? Bryn Llewellyn 18:35
Re: Recomended front ends? Rich Shepard 19:10
Re: Recomended front ends? Basques, Bob (CI-StPaul) 19:26
Re: Recomended front ends? DiasCosta 20:09
Re: Why must AUTOCOMMIT be ON to do txn control in plpgsql procedure? Adrian Klaver 21:25

Aug. 9, 2019

Thread Author Time
PostgreSQL 8.4 Tablespace Inconsistency Harold Falkmeyer 04:33
Understanding PostgreSQL installer debug log Ramesh Maddi 06:28
Understanding PostgreSQL installer debug log Ramesh Maddi 06:45
Re: Understanding PostgreSQL installer debug log Luca Ferrari 07:16
Re: Understanding PostgreSQL installer debug log Luca Ferrari 09:56
... Daniel Vos 10:10
Re: ... Luca Ferrari 11:02
Re: Understanding PostgreSQL installer debug log Benedict Holland 11:03
Generate test data inserts - 1GB Shital A 11:12
Re: Understanding PostgreSQL installer debug log Ramesh Maddi 11:25
pglogical replication dies hubert depesz lubaczewski 11:49
Re: Recomended front ends? Paolo Saudin 12:28
Updating 3-table dataset Moreno Andreo 12:29
PostgreSQL lock file Олег Самойлов 13:56
Re: ... Daniel Vos 14:10
Re: PostgreSQL 8.4 Tablespace Inconsistency Tom Lane 14:15
Re: PostgreSQL lock file Tom Lane 14:31
Re: Generate test data inserts - 1GB Adrian Klaver 14:38
Re: Understanding PostgreSQL installer debug log Adrian Klaver 14:45
Re: Updating 3-table dataset Luca Ferrari 14:50
Re: Understanding PostgreSQL installer debug log Benedict Holland 14:57
RE: pg_wal fills up on big update query Daniel Fink (PDF) 15:03
RE: pg_wal fills up on big update query Daniel Fink (PDF) 15:04
Re: Generate test data inserts - 1GB Shital A 15:14
Re: Generate test data inserts - 1GB Adrian Klaver 15:32
Re: pg_wal fills up on big update query Rob Sargent 15:44
Re: Generate test data inserts - 1GB Adrian Klaver 15:55
Re: Generate test data inserts - 1GB Shital A 16:51
Re: Generate test data inserts - 1GB Rob Sargent 16:59
Re: Generate test data inserts - 1GB Adrian Klaver 16:59
Re: Updating 3-table dataset Moreno Andreo 17:05
Re: DRY up GUI wiki pages Roger Pack 17:05
Re: Understanding PostgreSQL installer debug log Peter J. Holzer 17:41
Re: PostgreSQL 8.4 Tablespace Inconsistency Harold Falkmeyer 17:57
Re: How to check if a field exists in NEW in trigger Peter J. Holzer 18:30
Bulk Inserts Souvik Bhattacherjee 22:06
Re: Bulk Inserts Adrian Klaver 23:25

Aug. 10, 2019

Thread Author Time
FW: Undelivered Mail Returned to Sender stan 18:53
Probably a newbie question stan 18:57
Re: Probably a newbie question Ron 19:10
Re: Probably a newbie question Rob Sargent 19:42
Re: FW: Undelivered Mail Returned to Sender Melvin Davidson 20:11
Re: Probably a newbie question Melvin Davidson 20:13
Re: Probably a newbie question David G. Johnston 20:46

Aug. 11, 2019

Thread Author Time
Re: Bulk Inserts Souvik Bhattacherjee 02:47
Re: Bulk Inserts Rob Sargent 03:01
Re: Bulk Inserts Souvik Bhattacherjee 03:35
Re: FW: Undelivered Mail Returned to Sender rob stone 04:20

Browse Archives

Prev | Next