pgsql-general - May 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)
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

May 1, 2013

Thread Author Time
Re: OK to put temp tablespace on volatile storage or to omit it from backups? Darren Duncan 00:31
Re: OK to put temp tablespace on volatile storage or to omit it from backups? Yang Zhang 00:51
Re: OK to put temp tablespace on volatile storage or to omit it from backups? Ian Lawrence Barwick 02:14
Unformatted view DDL in pg_dump mattk 02:22
Re: OK to put temp tablespace on volatile storage or to omit it from backups? Yang Zhang 02:27
Re: Unformatted view DDL in pg_dump mattk 02:46
Re: OK to put temp tablespace on volatile storage or to omit it from backups? Darren Duncan 03:00
Re: OK to put temp tablespace on volatile storage or to omit it from backups? Tom Lane 03:13
Re: OK to put temp tablespace on volatile storage or to omit it from backups? Julian Glass 03:19
Re: Save postgresql node to catch only DML except delete queries roshan2013 03:47
Re: OK to put temp tablespace on volatile storage or to omit it from backups? Yang Zhang 05:47
Re: OK to put temp tablespace on volatile storage or to omit it from backups? Yang Zhang 06:14
Re: OK to put temp tablespace on volatile storage or to omit it from backups? Darren Duncan 06:21
Re: OK to put temp tablespace on volatile storage or to omit it from backups? Yang Zhang 06:34
Update links C. H. D. for PostgreSQL Questions 07:40
Re: Simple SQL INSERT to avoid duplication failed: why? Carlo Stonebanks 12:16
Re: [GENERAL] Update links Stefan Kaltenbrunner 12:36
Re: [GENERAL] Update links Magnus Hagander 12:41
Re: zLinux Load Testing Experience Andrew Hastie 13:01
Created a PostgreSQL test, what do you think? Jsmarterer 14:16
Re: Created a PostgreSQL test, what do you think? Andrew Sullivan 14:27
Re: zLinux Load Testing Experience Merlin Moncure 14:34
Re: Created a PostgreSQL test, what do you think? Shaun Thomas 15:05
LONG delete with LOTS of FK's Larry Rosenman 15:17
Re: LONG delete with LOTS of FK's Shaun Thomas 15:23
Re: LONG delete with LOTS of FK's Larry Rosenman 15:31
Re: Simple SQL INSERT to avoid duplication failed: why? Merlin Moncure 15:36
Re: OK to put temp tablespace on volatile storage or to omit it from backups? Christophe Pettus 16:13
Re: OK to put temp tablespace on volatile storage or to omit it from backups? Christophe Pettus 16:17
Re: zLinux Load Testing Experience Andrew Hastie 16:34
Re: Simple SQL INSERT to avoid duplication failed: why? Carlo Stonebanks 16:36
Re: OK to put temp tablespace on volatile storage or to omit it from backups? Christophe Pettus 16:40
Re: Simple SQL INSERT to avoid duplication failed: why? Steven Schlansker 16:48
Re: Save postgresql node to catch only DML except delete queries Jerry Sievers 17:30
Re: zLinux Load Testing Experience Merlin Moncure 18:21
Re: Created a PostgreSQL test, what do you think? Gavin Flower 20:06
Re: Simple SQL INSERT to avoid duplication failed: why? Gavin Flower 20:24
Re: zLinux Load Testing Experience Merlin Moncure 20:24
Re: Created a PostgreSQL test, what do you think? Merlin Moncure 20:57
tstzrange with ... 'infinity'] + upper_inf() using 9.2.4 Ralph Graulich 21:53
Re: tstzrange with ... 'infinity'] + upper_inf() using 9.2.4 Tom Lane 22:41
Re: LONG delete with LOTS of FK's Tom Lane 22:45
Re: zLinux Load Testing Experience Tom Lane 22:56
Re: tstzrange with ... 'infinity'] + upper_inf() using 9.2.4 Ralph Graulich 23:28
MKDIR_P@: Command not found error in regression test Karthik GP 23:34
Re: Basic question on recovery and disk snapshotting Jeff Janes 23:56

May 2, 2013

Thread Author Time
Re: MKDIR_P@: Command not found error in regression test Tom Lane 00:03
Re: Basic question on recovery and disk snapshotting Yang Zhang 02:40
Confusing comment in xlog.c or am I missing something? Amit Langote 04:12
Re: zLinux Load Testing Experience Andrew Hastie 09:41
Re: PostgreSQL registry entries for apt-get/yum/rpm install dinesh kumar 12:03
Position() Bug ? In PostgreSQL 9.2 dinesh kumar 12:09
Position() Bug ? In PostgreSQL 9.2 Amit Langote 13:25
Re: Position() Bug ? In PostgreSQL 9.2 Amit Langote 13:32
Re: Position() Bug ? In PostgreSQL 9.2 Tom Lane 13:49
Re: Position() Bug ? In PostgreSQL 9.2 dinesh kumar 14:10
Re: LONG delete with LOTS of FK's Larry Rosenman 14:50
Re: LONG delete with LOTS of FK's Tom Lane 15:08
Re: LONG delete with LOTS of FK's Larry Rosenman 15:33
Re: [GENERAL] Update links Josh Berkus 20:03

May 3, 2013

Thread Author Time
Curious why planner can't handle NOT IN Yang Zhang 06:44
SPI_execute_with_args call Yuriy Rusinov 09:19
Re: SPI_execute_with_args call Gavin Flower 10:31
Re: Simple, free PG GUI/query tool wanted mark_r 10:33
Re: SPI_execute_with_args call Yuriy Rusinov 10:56
Re: Curious why planner can't handle NOT IN Tom Lane 14:29
Re: SPI_execute_with_args call Tom Lane 14:42
Re: Curious why planner can't handle NOT IN pradeep singh 15:30
How to monitor recovery on Windows? Doug Gorley 17:41
Re: SPI_execute_with_args call Yuriy Rusinov 17:44
How to INSERT INTO one table from another table, WHERE Kirk Wythers 17:51
Re: How to INSERT INTO one table from another table, WHERE Igor Neyman 18:00
"Unlogged indexes" Yang Zhang 20:06
Re: "Unlogged indexes" Thom Brown 20:46
Re: "Unlogged indexes" Yang Zhang 20:53

May 4, 2013

Thread Author Time
Associative array in Pl/PgSQL Karel Riveron Escobar 23:40
Re: Simple SQL INSERT to avoid duplication failed: why? Jasen Betts 23:44
Re: Associative array in Pl/PgSQL John R Pierce 23:50

May 5, 2013

Thread Author Time
Re: Associative array in Pl/PgSQL Karel Riveron Escobar 00:02
Re: Associative array in Pl/PgSQL Jasen Betts 00:13
Re: Associative array in Pl/PgSQL Darren Duncan 01:57
Composite fields and the query planner Steve Rogerson 13:05
Re: Composite fields and the query planner Tom Lane 14:06
Re: SPI_execute_with_args call Yuriy Rusinov 20:22

May 6, 2013

Thread Author Time
Shortcut evaluation in OR or IN Tim Uckun 02:16
Re: Shortcut evaluation in OR or IN Jasen Betts 08:43
Re: Shortcut evaluation in OR or IN Richard Poole 08:43
Re: Associative array in Pl/PgSQL Merlin Moncure 16:03
Re: Simple SQL INSERT to avoid duplication failed: why? Carlo Stonebanks 16:19
Re: Simple SQL INSERT to avoid duplication failed: why? Merlin Moncure 16:24
Temp files and process memory footprint Erik Jones 20:03
Re: "Unlogged indexes" Michael Paquier 23:43

May 7, 2013

Thread Author Time
Re: Composite fields and the query planner Steve Rogerson 08:49
Insert not finishing Johann Spies 09:38
Re: Insert not finishing Alban Hertroys 09:45
Re: Insert not finishing Albe Laurenz 10:15
replication breaks with CentOS 6.4 upgrade John DeSoi 14:58
Re: replication breaks with CentOS 6.4 upgrade Tom Lane 16:19
help with log entries during restart Sahagian, David 21:03

May 8, 2013

Thread Author Time
Need an explanation Alan Nilsson 01:53
Re: Need an explanation Tom Lane 02:30
Re: Need an explanation Alan Nilsson 02:33
Re: Shortcut evaluation in OR or IN Tim Uckun 02:49
Re: help with log entries during restart Takashi Ohnishi 02:52
PAM implementation in PG 9.2.3 Raghavendra 06:23
Postgresql stuck at open connection S H 08:52
Design advice requested Johann Spies 11:21
Re: PAM implementation in PG 9.2.3 Amit Langote 11:25
Does it make sense to break a large query into separate functions? Seref Arikan 13:40
question on most efficient way to increment a column Tyson Maly 13:45
Re: question on most efficient way to increment a column Merlin Moncure 14:02
Re: question on most efficient way to increment a column Albe Laurenz 14:02
Re: Does it make sense to break a large query into separate functions? Tom Lane 14:05
Re: Does it make sense to break a large query into separate functions? Seref Arikan 14:09
Re: Design advice requested Julian 14:17
Re: Does it make sense to break a large query into separate functions? Julian 14:40
SELECT count(*) differs from result in pgadmin Tobias Larsen 14:44
Re: Does it make sense to break a large query into separate functions? Merlin Moncure 14:47
Re: SELECT count(*) differs from result in pgadmin Tobias Larsen 15:07
Re: PAM implementation in PG 9.2.3 Raghavendra 16:03
Re: Does it make sense to break a large query into separate functions? Tom Lane 16:12
Re: SELECT count(*) differs from result in pgadmin Jerry Sievers 16:23
Re: Segmentation fault with core dump Joshua Berry 16:39
pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4 Evan D. Hoffman 18:27
Re: pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4 Igor Neyman 18:35
Re: Does it make sense to break a large query into separate functions? Merlin Moncure 18:41
Re: Does it make sense to break a large query into separate functions? Tom Lane 19:04
Re: question on most efficient way to increment a column Tyson Maly 19:14
Trigger function on Warm Standby ning chan 19:38
Re: pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4 Igor Neyman 20:12
Re: pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4 Evan D. Hoffman 20:21
Re: Trigger function on Warm Standby Jerry Sievers 20:25
Re: pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4 Tom Lane 20:30
Re: pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4 Igor Neyman 20:31
Re: Does it make sense to break a large query into separate functions? Gavin Flower 21:03
pg_upgrade -u Ray Stell 21:05
refactoring a database owner without "reassign owned" Jeff Janes 21:11
Re: Does it make sense to break a large query into separate functions? Merlin Moncure 21:35
Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4 Bruce Momjian 21:35
Re: Does it make sense to break a large query into separate functions? Gavin Flower 21:47
Normal errors codes in serializable transactions Jon Smark 23:03
Re: question on most efficient way to increment a column Alban Hertroys 23:30
Re: Normal errors codes in serializable transactions Tatsuo Ishii 23:34

May 9, 2013

Thread Author Time
Re: pg_upgrade -u Bruce Momjian 00:52
Re: question on most efficient way to increment a column Scott Marlowe 02:10
Re: Normal errors codes in serializable transactions Kevin Grittner 02:31
Upgrading postgresql from version 7.4.3 Arun P.L 09:02
Re: Upgrading postgresql from version 7.4.3 John R Pierce 09:24
Re: Normal errors codes in serializable transactions Jon Smark 10:53
Re: Normal errors codes in serializable transactions Jon Smark 11:02
Views itishree sukla 11:03
FATAL: database "a/system_data" does not exist sumita 11:28
Re: Views Raghavendra 12:02
Re: Upgrading postgresql from version 7.4.3 Ian Lawrence Barwick 12:37
pg_upgrade error Ramesh naik 12:46
Re: question on most efficient way to increment a column Tyson Maly 12:50
Re: FATAL: database "a/system_data" does not exist Adrian Klaver 13:07
Re: Does it make sense to break a large query into separate functions? Merlin Moncure 13:47
Re: Composite fields and the query planner Steve Rogerson 13:49
Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4 Evan D. Hoffman 14:20
Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4 Bruce Momjian 14:45
Storing small image files Nelson Green 15:04
Re: Does it make sense to break a large query into separate functions? Tom Lane 15:15
Re: Storing small image files Achilleas Mantzios 15:20
Re: Does it make sense to break a large query into separate functions? Merlin Moncure 15:30
Re: Storing small image files Nelson Green 15:34
Re: Does it make sense to break a large query into separate functions? Tom Lane 15:43
Re: Storing small image files Achilleas Mantzios 15:51
Re: Storing small image files Karl Denninger 16:12
Re: Storing small image files Karl Denninger 16:21
Re: Storing small image files Alvaro Herrera 16:34
Re: Storing small image files Karl Denninger 16:41
Re: Storing small image files Nelson Green 17:05
Re: Storing small image files Nelson Green 17:08
Re: pg_upgrade error Bruce Momjian 17:11
Re: Storing small image files Misa Simic 17:31
Re: Storing small image files Nelson Green 18:40
Re: Storing small image files Nelson Green 18:42
Re: Storing small image files Misa Simic 18:49
Re: Storing small image files Nelson Green 19:21
Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4 Evan D. Hoffman 19:23
Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4 Bruce Momjian 19:29
Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4 Evan D. Hoffman 19:52
Re: Storing small image files Karl Denninger 19:53
Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4 Bruce Momjian 20:15
Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4 Evan D. Hoffman 20:21
Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4 Tom Lane 20:24
Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4 Evan D. Hoffman 20:40
Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4 Bruce Momjian 20:42
Re: LONG delete with LOTS of FK's Larry Rosenman 20:50
Re: LONG delete with LOTS of FK's Larry Rosenman 20:58
Re: Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4 Tom Lane 21:11
Re: LONG delete with LOTS of FK's Shaun Thomas 21:20
Re: LONG delete with LOTS of FK's Tom Lane 21:22
Re: LONG delete with LOTS of FK's Larry Rosenman 21:22
Re: LONG delete with LOTS of FK's Larry Rosenman 21:23
Re: LONG delete with LOTS of FK's Shaun Thomas 21:26
Re: Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4 Bruce Momjian 21:29
Re: LONG delete with LOTS of FK's Tom Lane 21:40
Re: Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4 Evan D. Hoffman 21:41

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