pgsql-general - September 2013

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

Sept. 1, 2013

Thread Author Time
Re: Dump/Reload pg_statistic to cut time from pg_upgrade? Jeff Davis 17:35
Re: Why is NULL = unbounded for rangetypes? Jeff Davis 17:51
Re: Adding ip4r to Postgresql core? Jeff Davis 18:01

Sept. 2, 2013

Thread Author Time
store multiple rows with the SELECT INTO statement 📎 Janek Sendrowski 00:23
Re: store multiple rows with the SELECT INTO statement Adrian Klaver 00:59
Re: My Experiment of PG crash when dealing with huge amount of data 高健 01:25
Re: My Experiment of PG crash when dealing with huge amount of data Tom Lane 02:37
Re: store multiple rows with the SELECT INTO statement Pavel Stehule 07:27
Re: SSI and predicate locks - a non-trivial use case Gianni Ceccarelli 12:59
ALTER TABLE transaction isolation problem DT 13:35
psql --command option ignores --variable's Tim Kane 14:54
Re: psql --command option ignores --variable's Tom Lane 15:00
Re: psql --command option ignores --variable's Adrian Klaver 15:04
STABLE marker on functions with single select Laszlo Hornyak 15:12
Re: STABLE marker on functions with single select David Johnston 15:41
Re: psql --command option ignores --variable's Tim Kane 15:53
Re: My Experiment of PG crash when dealing with huge amount of data Jeff Janes 19:06
Re: [GENERAL] currval and DISCARD ALL 📎 Fabrízio de Royes Mello 20:35

Sept. 3, 2013

Thread Author Time
Re: My Experiment of PG crash when dealing with huge amount of data 高健 01:03
Stored Procedure table/column args Bret Stern 01:06
Re: Stored Procedure table/column args Adrian Klaver 01:20
Re: Stored Procedure table/column args Bret Stern 01:40
Re: ALTER TABLE transaction isolation problem David Johnston 02:01
Re: A QUESTION ABOUT evaluation of two-dimensional Associative Arrays BladeOfLight16 03:08
How to find out unused indexes? [email protected] 06:06
Re: How to find out unused indexes? Raghavendra 06:44
Re: How to find out unused indexes? Abdul Sayeed 09:31
Re: Dump/Reload pg_statistic to cut time from pg_upgrade? Bruce Momjian 13:31
Re: SSI and predicate locks - a non-trivial use case Kevin Grittner 14:12
Re: ALTER TABLE transaction isolation problem Kevin Grittner 14:29
Re: ALTER TABLE transaction isolation problem David Johnston 14:42
Creating a very simple extension causing: ERROR: could not open file "base/6064585/9440403": No such file or directory Robert Nix 14:44
Re: ALTER TABLE transaction isolation problem Tom Lane 15:01
Re: ALTER TABLE transaction isolation problem Kevin Grittner 15:35
Re: How to find out unused indexes? [email protected] 15:48
Re: ALTER TABLE transaction isolation problem Kevin Grittner 16:12
Re: store multiple rows with the SELECT INTO statement Kevin Grittner 16:23
Re: How to find out unused indexes? Jeff Janes 16:24
Re: store multiple rows with the SELECT INTO statement 📎 Janek Sendrowski 19:10
Re: store multiple rows with the SELECT INTO statement Adrian Klaver 20:31
uuids with btree_gist Martin Renters 20:41
Re: store multiple rows with the SELECT INTO statement Kevin Grittner 21:07
Re: ALTER TABLE transaction isolation problem David Johnston 21:30
Re: store multiple rows with the SELECT INTO statement 📎 Janek Sendrowski 21:52
Re: store multiple rows with the SELECT INTO statement Adrian Klaver 21:58
Call for design: PostgreSQL mugs Andreas 'ads' Scherbaum 22:08
Re: [GENERAL] Call for design: PostgreSQL mugs Peter Geoghegan 22:22
Generic function for partitioning function? Gregory Haase 22:38

Sept. 4, 2013

Thread Author Time
Re: Generic function for partitioning function? Martin Collins 00:04
Re: store multiple rows with the SELECT INTO statement Adrian Klaver 02:06
Re: Generic function for partitioning function? Jeff Janes 02:10
Re: store multiple rows with the SELECT INTO statement Adrian Klaver 02:12
Re: uuids with btree_gist Joe Van Dyk 05:24
Re: Generic function for partitioning function? Gudmundur Johannesson 08:34
Re: [GENERAL] Call for design: PostgreSQL mugs Eduardo Morras 10:47
FETCH FORWARD 0 and "cursor can only scan forward" error Trigve Siver 13:06
Spurious error messages from pg_restore Evan Martin 14:02
Re: Spurious error messages from pg_restore Adrian Klaver 14:20
Problems with vacuum JotaComm 14:31
Re: FETCH FORWARD 0 and "cursor can only scan forward" error Giuseppe Broccolo 16:26
Re: FETCH FORWARD 0 and "cursor can only scan forward" error Trigve Siver 16:57
Re: FETCH FORWARD 0 and "cursor can only scan forward" error Tom Lane 17:04
Re: Spurious error messages from pg_restore Evan Martin 17:08
Re: FETCH FORWARD 0 and "cursor can only scan forward" error Trigve Siver 17:10
pg_catalog question: Sequence attributes. Raphael Araújo e Silva 18:33
Re: pg_catalog question: Sequence attributes. Alvaro Herrera 19:16
Re: Spurious error messages from pg_restore David Johnston 19:26
Re: Spurious error messages from pg_restore David Johnston 19:31
Re: [GENERAL] Call for design: PostgreSQL mugs Gavin Flower 20:02
Re: [GENERAL] Call for design: PostgreSQL mugs Marc Balmer 20:13
Re: FETCH FORWARD 0 and "cursor can only scan forward" error David Johnston 20:15
Re: [GENERAL] Call for design: PostgreSQL mugs Stefan Kaltenbrunner 20:17
Re: [pgeu-general] Call for design: PostgreSQL mugs Andreas 'ads' Scherbaum 20:26
Re: [GENERAL] Call for design: PostgreSQL mugs patrick keshishian 20:40
Re: [pgeu-general] Call for design: PostgreSQL mugs Erik Rijkers 20:55
Re: [GENERAL] Call for design: PostgreSQL mugs Gavin Flower 20:58
Re: [pgeu-general] Call for design: PostgreSQL mugs John Meyer 20:58
Re: [pgeu-general] Call for design: PostgreSQL mugs Andreas 'ads' Scherbaum 20:59
Re: [pgeu-general] Call for design: PostgreSQL mugs Richard Sickler 21:04
Re: Call for design: PostgreSQL mugs John R Pierce 21:10

Sept. 5, 2013

Thread Author Time
Re: [GENERAL] Call for design: PostgreSQL mugs Adrian Klaver 00:48
Re: Frontend/backend protocol improvements proposal (request). Noah Misch 01:17
LogStash For Analysing Postgres DB server Logs Adarsh Sharma 04:43
Re: LogStash For Analysing Postgres DB server Logs M Tarkeshwar Rao 05:10
Can you please suggest me some links where I can learn: M Tarkeshwar Rao 05:13
Re: FETCH FORWARD 0 and "cursor can only scan forward" error Trigve 05:21
Re: Can you please suggest me some links where I can learn: John R Pierce 05:25
Re: LogStash For Analysing Postgres DB server Logs Adarsh Sharma 06:07
Old record migration to another table made the db slower Arun P.L 06:52
Re: [pgeu-general] Call for design: PostgreSQL mugs Jean-Paul Argudo 06:55
Re: [pgeu-general] Call for design: PostgreSQL mugs Heikki Linnakangas 07:00
Re: [pgeu-general] Call for design: PostgreSQL mugs Atri Sharma 07:03
Re: [GENERAL] Call for design: PostgreSQL mugs Jean-Paul Argudo 07:21
Re: [pgeu-general] Call for design: PostgreSQL mugs Atri Sharma 07:24
Re: [GENERAL] Call for design: PostgreSQL mugs Alban Hertroys 07:58
Re: [GENERAL] Call for design: PostgreSQL mugs Atri Sharma 08:00
How to check if any WAL file is missing in archive folder [email protected] 08:52
Re: [GENERAL] Call for design: PostgreSQL mugs Marc Balmer 08:56
Re: Old record migration to another table made the db slower Tomas Vondra 09:05
Re: Spurious error messages from pg_restore Evan Martin 09:27
Question About WAL filename and its time stamp [email protected] 13:19
Re: Spurious error messages from pg_restore Evan Martin 13:49
EF / npgsql and VIEWs Mike Blackwell 14:04
Re: Call for design: PostgreSQL mugs Merlin Moncure 15:22
Re: EF / npgsql and VIEWs Joshua D. Drake 15:34
Re: [PERFORM] Can you please suggest me some links where I can learn: Kevin Grittner 15:39
Re: [GENERAL] Call for design: PostgreSQL mugs Stéphane Schildknecht 15:57
Re: Call for design: PostgreSQL mugs Vincent Veyron 18:25
Re: [GENERAL] Call for design: PostgreSQL mugs Steve Crawford 18:49
invalid frontend message type 136 Steve Crawford 18:59
Re: invalid frontend message type 136 David Johnston 19:04
Re: [GENERAL] Call for design: PostgreSQL mugs Marc Balmer 19:05
Re: [GENERAL] Call for design: PostgreSQL mugs Atri Sharma 19:37
Re: [GENERAL] Call for design: PostgreSQL mugs Richard Sickler 19:52
Re: [GENERAL] Call for design: PostgreSQL mugs Marc Balmer 19:53
Re: [pgeu-general] Call for design: PostgreSQL mugs patrick keshishian 20:05
Re: Call for design: PostgreSQL mugs CS DBA 20:36
Re: [GENERAL] Call for design: PostgreSQL mugs Dimitri Fontaine 21:10
Re: [pgeu-general] Call for design: PostgreSQL mugs Eduardo Morras 22:38
Re: [PERFORM] Can you please suggest me some links where I can learn: Merlin Moncure 22:42
Re: [PERFORM] Can you please suggest me some links where I can learn: John R Pierce 22:53
Levenshtein Distance with more than 255 characters 📎 Janek Sendrowski 23:00

Sept. 6, 2013

Thread Author Time
Is this a bug in ECPG? Wang, Jing 00:57
Re: Question About WAL filename and its time stamp Suzuki Hironobu 02:17
Re: Question About WAL filename and its time stamp Haribabu kommi 05:22
Re: Levenshtein Distance with more than 255 characters Szymon Guz 06:40
Re: Levenshtein Distance with more than 255 characters Tom Lane 06:47
Re: How to check if any WAL file is missing in archive folder Albe Laurenz 07:04
Re: Levenshtein Distance with more than 255 characters Szymon Guz 07:30
Re: Is this a bug in ECPG? Boszormenyi Zoltan 07:57
Failed to autoconvert '1' to text. Szymon Guz 08:13
Re: Failed to autoconvert '1' to text. Richard Huxton 08:33
Re: Failed to autoconvert '1' to text. Szymon Guz 08:39
Re: My Experiment of PG crash when dealing with huge amount of data 高健 08:58
Re: pg_dump question (exclude schemas) vinayak 11:41
psql client memory usage Tim Kane 12:06
Re: psql client memory usage Daniel Verite 12:49
Re: Old record migration to another table made the db slower Michael Paquier 13:08
Re: psql client memory usage Suzuki Hironobu 13:11
Re: How to check if any WAL file is missing in archive folder Michael Paquier 13:16
Re: psql client memory usage Tim Kane 13:19
PK referenced function Agustin Larreinegabe 13:26
Re: PK referenced function Serge Fonville 13:29
Re: PK referenced function Michael Paquier 13:51
Re: psql client memory usage Merlin Moncure 13:56
Re: PK referenced function Agustin Larreinegabe 14:17
Re: SQL Path in psql miles 17:05
Re: SQL Path in psql Rob Sargentg 17:17
Re: SQL Path in psql David Johnston 17:45
Re: SQL Path in psql David Kerr 17:58
Re: SQL Path in psql Miles Pomeroy 19:14
are WAL file segment boundaries a point of consistency? John Lumby 20:26
select DISTINCT pg noob 20:54
Re: Levenshtein Distance with more than 255 characters janek12 21:00
Re: Levenshtein Distance with more than 255 characters John R Pierce 21:19
Re: Levenshtein Distance with more than 255 characters 📎 Janek Sendrowski 21:28
Re: Call for design: PostgreSQL mugs Peter Geoghegan 23:06

Sept. 7, 2013

Thread Author Time
Re: [GENERAL] Call for design: PostgreSQL mugs Berend Tober 00:34
Re: select DISTINCT Kevin Grittner 00:51
Re: select DISTINCT Jeff Janes 02:48
Constraint exclusion and overlapping range checks Steve Atkins 04:29
Re: Constraint exclusion and overlapping range checks François Beausoleil 04:37
Re: Constraint exclusion and overlapping range checks Steve Atkins 04:54
Re: Constraint exclusion and overlapping range checks Alban Hertroys 08:32
Re: [GENERAL] Call for design: PostgreSQL mugs Raymond O'Donnell 10:01
Hash Support Function Soroosh Sardari 11:16
Re: [GENERAL] Call for design: PostgreSQL mugs Michael Paquier 11:33
Re: Levenshtein Distance with more than 255 characters Michael Paquier 11:39
Re: Constraint exclusion and overlapping range checks Tom Lane 14:20
Re: Hash Support Function Tom Lane 14:27
Re: Is this a bug in ECPG? Boszormenyi Zoltan 19:09
Re: Constraint exclusion and overlapping range checks Steve Atkins 21:47

Sept. 8, 2013

Thread Author Time
Re: Hash Support Function Marc Mamin 10:24
Re: Stored Procedure table/column args Sameer Thakur 11:42
Re: Call for design: PostgreSQL mugs Andreas 'ads' Scherbaum 13:27
Re: [pgeu-general] Call for design: PostgreSQL mugs Erik Rijkers 15:50
Re: Call for design: PostgreSQL mugs Gavin Flower 21:16
Re: Call for design: PostgreSQL mugs Bret Stern 23:51

Sept. 9, 2013

Thread Author Time
Sum of columns 📎 janek12 01:12
Re: Sum of columns Chris Curvey 01:29
Re: Sum of columns Tomas Vondra 02:16
Re: Sum of columns Rob Sargentg 02:27
Re: SQL Path in psql BladeOfLight16 04:10
Re: [pgeu-general] Call for design: PostgreSQL mugs Jayadevan M 04:12
PostgreSQL and cgroup 高健 10:07
Making substrings uppercase Oliver Kohll - Mailing Lists 11:34
Re: Sum of columns Marc Mamin 12:12
Hello, fumihisa.suzuki 12:55
Re: PK referenced function Agustin Larreinegabe 13:07
Re: Hello, Adrian Klaver 13:24
Re: Making substrings uppercase David Johnston 13:41
Re: [GENERAL] Call for design: PostgreSQL mugs Marc Mamin 13:46
Re: Making substrings uppercase Oliver Kohll - Mailing Lists 13:50
help getting a backtrace from 9.2 on Ubuntu 13.04? Chris Curvey 14:00
Re: select DISTINCT pg noob 14:10
Re: Call for design: PostgreSQL mugs Karsten Hilbert 15:22
Re: Call for design: PostgreSQL mugs Mike Christensen 16:09
Re: are WAL file segment boundaries a point of consistency? Amador Alvarez 16:51
Re: are WAL file segment boundaries a point of consistency? Jeff Janes 17:22
Re: Call for design: PostgreSQL mugs Quentin Hartman 17:25

Browse Archives

Prev | Next