pgsql-general - October 2009

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

Oct. 1, 2009

Thread Author Time
Re: Weird behavior with "sensitive" cursors. Alvaro Herrera 00:32
Re: Weird behavior with "sensitive" cursors. Alvaro Herrera 00:35
Re: Weird behavior with "sensitive" cursors. Tom Lane 01:02
Re: Weird behavior with "sensitive" cursors. 📎 Alvaro Herrera 01:26
Re: Weird behavior with "sensitive" cursors. Tom Lane 02:12
Time Management - Training Seminar in Cape Town Training 04:48
[OT] Relocation lookup Rakotomandimby Mihamina 09:47
Boolean storage takes up 1 byte? Thom Brown 10:37
Re: Boolean storage takes up 1 byte? Sam Mason 11:03
Re: Boolean storage takes up 1 byte? Thom Brown 11:33
error message on install [ REPOST from pgsql-novice ] Ounce Snow 13:30
pg_dump and check-constraints A. Kretschmer 13:59
Re: pg_dump and check-constraints Tom Lane 14:07
Re: I can not drop a user/role because an object depent on it. Ricky Tompu Breaky 15:37
Re: Collation in ORDER BY not lexicographical Paul Gaspar 15:46
Re: Weird behavior with "sensitive" cursors. Alvaro Herrera 16:27
Re: I can not drop a user/role because an object depent on it. Adrian Klaver 16:40
Re: error message on install [ REPOST from pgsql-novice ] Sachin Srivastava 17:05
Pg West in two weeks! Joshua D. Drake 17:55
Vacuumdb Fails: Huge Tuple APseudoUtopia 19:10
Re: Vacuumdb Fails: Huge Tuple APseudoUtopia 19:12
Re: Weird behavior with "sensitive" cursors. 📎 Alvaro Herrera 19:40
Re: Vacuumdb Fails: Huge Tuple Scott Marlowe 20:21
Re: Vacuumdb Fails: Huge Tuple APseudoUtopia 20:27
Re: Weird behavior with "sensitive" cursors. Tom Lane 20:34
Re: Vacuumdb Fails: Huge Tuple Scott Marlowe 20:37
Re: Vacuumdb Fails: Huge Tuple Alvaro Herrera 20:59
Re: Vacuumdb Fails: Huge Tuple Tom Lane 21:02
Re: Weird behavior with "sensitive" cursors. Alvaro Herrera 23:04
Procedure for feature requests? Tim Landscheidt 23:35
Re: Procedure for feature requests? Alvaro Herrera 23:44
Programming interfaces when using MD5 authentication Preston de Guise 23:48
Re: Weird behavior with "sensitive" cursors. 📎 Alvaro Herrera 23:51

Oct. 2, 2009

Thread Author Time
Query not using the indexes properly. Tim Uckun 01:47
Re: Query not using the indexes properly. Chris 02:04
Re: Query not using the indexes properly. David Wilson 02:18
Re: Query not using the indexes properly. Tim Uckun 02:19
Re: Query not using the indexes properly. Tim Uckun 02:21
Re: Query not using the indexes properly. David Wilson 02:25
PGDay.EU 2009 - Call for lighting talks Dave Page 09:08
Re: Limit of bgwriter_lru_maxpages of max. 1000? Greg Smith 09:17
Re: PostgreSQL reads each 8k block - no larger blocks are used - even on sequential scans Greg Smith 09:48
Re: PostgreSQL reads each 8k block - no larger blocks are used - even on sequential scans Greg Smith 09:56
Re: PGDay.EU 2009 - Call for lighting talks Hans-Juergen Schoenig 10:13
Re: Programming interfaces when using MD5 authentication Willy-Bas Loos 10:22
Re: PGDay.EU 2009 - Call for lighting talks David Fetter 12:17
Re: PGDay.EU 2009 - Call for lighting talks Hans-Juergen Schoenig 12:30
Adding modified and creation datetime to system catalogs Thom Brown 13:30
Re: Adding modified and creation datetime to system catalogs Tom Lane 13:39
Re: PGDay.EU 2009 - Call for lighting talks Cédric Villemain 13:40
Re: PGDay.EU 2009 - Call for lighting talks Dave Page 13:44
Re: Programming interfaces when using MD5 authentication Tom Lane 13:47
Re: Procedure for feature requests? Sam Mason 14:10
Re: Adding modified and creation datetime to system catalogs Thom Brown 14:42
Re: Vacuumdb Fails: Huge Tuple 📎 Teodor Sigaev 15:19
Re: Vacuumdb Fails: Huge Tuple Tom Lane 15:30
Re: Understanding 'could not read block' Joshua D. Drake 16:23
Re: Vacuumdb Fails: Huge Tuple Teodor Sigaev 17:16
Re: Vacuumdb Fails: Huge Tuple Tom Lane 17:25
Re: Weird behavior with "sensitive" cursors. Alvaro Herrera 18:01
Re: PostgreSQL reads each 8k block - no larger blocks are used - even on sequential scans Gerhard Wiesinger 18:46
Re: PostgreSQL reads each 8k block - no larger blocks are used - even on sequential scans Gerhard Wiesinger 18:57
Re: Limit of bgwriter_lru_maxpages of max. 1000? Gerhard Wiesinger 19:16
Re: Performance evaluation of PostgreSQL's historic releases Simon Riggs 19:26
Re: Time Management - Training Seminar in Cape Town Simon Riggs 19:32
Re: Boolean storage takes up 1 byte? Simon Riggs 19:42
Re: PostgreSQL reads each 8k block - no larger blocks are used - even on sequential scans Simon Riggs 19:52
Re: Time Management - Training Seminar in Cape Town David Fetter 20:16
Re: Limit of bgwriter_lru_maxpages of max. 1000? Greg Smith 20:19
Re: PostgreSQL reads each 8k block - no larger blocks are used - even on sequential scans Greg Smith 20:29
Re: Limit of bgwriter_lru_maxpages of max. 1000? Scott Marlowe 21:16
Re: Vacuumdb Fails: Huge Tuple Tom Lane 21:23
Re: Procedure for feature requests? Tim Landscheidt 21:37
Re: Boolean storage takes up 1 byte? Tom Lane 21:47
Re: Procedure for feature requests? Tim Landscheidt 21:48
Re: Procedure for feature requests? Joshua D. Drake 21:48
Re: Limit of bgwriter_lru_maxpages of max. 1000? Tom Lane 21:55
Re: Limit of bgwriter_lru_maxpages of max. 1000? Bruce Momjian 22:05
Re: Limit of bgwriter_lru_maxpages of max. 1000? Tom Lane 22:16
Re: Limit of bgwriter_lru_maxpages of max. 1000? Scott Marlowe 22:41
Re: Limit of bgwriter_lru_maxpages of max. 1000? Greg Smith 23:24

Oct. 3, 2009

Thread Author Time
[ANN] VTD-XML 2.7 jimmy Zhang 03:34
Re: Where can I get the number of plans that considered by Planner? 纪晓曦 06:20
Re: PostgreSQL reads each 8k block - no larger blocks are used - even on sequential scans Gerhard Wiesinger 07:11
Re: PostgreSQL reads each 8k block - no larger blocks are used - even on sequential scans Gerhard Wiesinger 07:40
How useful is the money datatype? Thom Brown 10:33
Re: How useful is the money datatype? Peter Geoghegan 10:43
Re: How useful is the money datatype? Grzegorz Jaśkiewicz 10:53
Re: How useful is the money datatype? Thom Brown 11:10
Re: How useful is the money datatype? Raymond O'Donnell 11:20
Re: How useful is the money datatype? Peter Eisentraut 11:34
Re: How useful is the money datatype? Raymond O'Donnell 11:37
Re: How useful is the money datatype? Thom Brown 11:47
Re: How useful is the money datatype? Filip Rembiałkowski 12:45
Re: How useful is the money datatype? Peter Geoghegan 13:10
Re: Procedure for feature requests? Sam Mason 15:23
Re: How useful is the money datatype? Sam Mason 15:40
Re: How useful is the money datatype? Merlin Moncure 15:49
Re: How useful is the money datatype? Greg Stark 16:05
Re: Procedure for feature requests? Martin Gainty 16:14
Re: PostgreSQL reads each 8k block - no larger blocks are used - even on sequential scans Greg Stark 16:19
Re: How useful is the money datatype? Sam Mason 16:19
Embarassing GROUP question Corey Tisdale 16:25
Re: Procedure for feature requests? Sam Mason 16:32
Re: Procedure for feature requests? Tom Lane 16:48
Re: Embarassing GROUP question Tom Lane 17:05
Re: Procedure for feature requests? Sam Mason 17:24
Re: Embarassing GROUP question Sam Mason 17:31
Re: Procedure for feature requests? Tom Lane 20:14
Re: Embarassing GROUP question Tom Lane 20:39
Re: Embarassing GROUP question Corey Tisdale 21:56
Re: Embarassing GROUP question Martin Gainty 22:18
Re: Embarassing GROUP question Tom Lane 22:53
Re: Embarassing GROUP question Corey Tisdale 23:12
Re: Procedure for feature requests? Sam Mason 23:47

Oct. 4, 2009

Thread Author Time
Re: Embarassing GROUP question Sam Mason 00:13
Re: How useful is the money datatype? V S P 02:14
Re: query is taking longer time after a while tomrevam 08:44
Re: Where can I get the number of plans that considered by Planner? Martijn van Oosterhout 11:35
Re: query is taking longer time after a while Sam Mason 11:59
Re: query is taking longer time after a while tomrevam 12:16
Re: query is taking longer time after a while Tom Lane 15:08
Re: query is taking longer time after a while Tom Lane 15:27
Compilate problems Yadisnel Galvez Velazquez 15:39
Re: query is taking longer time after a while Sam Mason 15:56
Re: How useful is the money datatype? Sam Mason 16:12
Re: How useful is the money datatype? Rich Shepard 16:31
Compilate problems Yadisnel Galvez Velazquez 16:51
Re: Compilate problems David Fetter 16:51
Compilate problems Yadisnel Galvez Velazquez 17:17
Re: Compilate problems Alvaro Herrera 17:27
Re: Compilate problems 📎 David Fetter 18:10
PANIC: hash table "LOCK" hash corrupted Gerhard Heift 18:30
Re: PANIC: hash table "LOCK" hash corrupted Tom Lane 19:10
Re: How useful is the money datatype? Sam Mason 19:38
Re: Limit of bgwriter_lru_maxpages of max. 1000? Gerhard Wiesinger 20:19
Re: How useful is the money datatype? justin 22:29

Oct. 5, 2009

Thread Author Time
Re: Procedure for feature requests? Tim Landscheidt 00:03
ERROR: column "id" inherits conflicting default values Scott Ribe 01:27
Re: ERROR: column "id" inherits conflicting default values Tom Lane 01:43
Re: ERROR: column "id" inherits conflicting default values Scott Ribe 02:06
Re: How useful is the money datatype? Guy Rouillier 02:09
Re: ERROR: column "id" inherits conflicting default values Tom Lane 02:30
Re: How useful is the money datatype? Christophe Pettus 02:34
Postgres won't start. Nothing in the log. Tim Uckun 04:39
attempted to lock invisible tuple - PG 8.4.1 Stuart Bishop 06:58
Re: Postgres won't start. Nothing in the log. Markus Wollny 08:13
Re: attempted to lock invisible tuple - PG 8.4.1 Alban Hertroys 09:22
Re: Postgres won't start. Nothing in the log. Thom Brown 09:48
Errors regarding transporting database using pg_dump Chun-fan Ivan Liao 10:07
Re: Procedure for feature requests? Sam Mason 10:27
Re: How to have ant's <sql> task insert special chars appropriately? agostonbejo 11:12
connection failure Miklosi Attila 13:06
Re: connection failure Sam Mason 13:22
Re: connection failure Allan Kamau 13:23
Re: Postgres won't start. Nothing in the log. Tom Lane 14:07
object dependency workaround Little, Douglas 14:12
Re: Postgres won't start. Nothing in the log. Devrim GÜNDÜZ 14:16
Re: attempted to lock invisible tuple - PG 8.4.1 Stuart Bishop 14:30
Re: Postgres won't start. Nothing in the log. Martin Gainty 14:32
Re: Errors regarding transporting database using pg_dump Martijn van Oosterhout 14:34
Re: Errors regarding transporting database using pg_dump Tom Lane 14:52
Limiting the impact of schema additions/poor queries made by clients on production machines Joshua Berry 15:04
Re: attempted to lock invisible tuple - PG 8.4.1 Alvaro Herrera 16:00
Looking for interest in an Irish PUG Raymond O'Donnell 16:16
Re: Looking for interest in an Irish PUG Joshua D. Drake 16:20
Re: Postgres won't start. Nothing in the log. Andreas Kretschmer 16:21
Re: Limit of bgwriter_lru_maxpages of max. 1000? Greg Smith 16:24
Re: Errors regarding transporting database using pg_dump Chun-fan Ivan Liao 17:36
[No subject] 📎 233242661002 17:36
Re: John R Pierce 18:27
Re: Limit of bgwriter_lru_maxpages of max. 1000? Gerhard Wiesinger 18:28
Re: How useful is the money datatype? Guy Rouillier 19:48
Re: How useful is the money datatype? Bruce Momjian 19:55
Re: How useful is the money datatype? Christophe Pettus 20:07
Re: Limit of bgwriter_lru_maxpages of max. 1000? Greg Smith 20:40
Re: How useful is the money datatype? Sam Mason 21:23
Version upgrade with tablespace Bill Todd 21:49
Wishlist of PL/Perl Enhancements for PostgreSQL 8.5 Tim Bunce 22:25
Re: 8.3.6 build error on Debian Lenny donald63 22:32
Re: Limiting the impact of schema additions/poor queries made by clients on production machines Scott Marlowe 22:39
Re: Limiting the impact of schema additions/poor queries made by clients on production machines Steve Atkins 22:52
Re: Programming interfaces when using MD5 authentication Preston de Guise 23:02
Documentation on standard conforming strings? Preston de Guise 23:09
Re: Version upgrade with tablespace Bill Todd 23:14
Re: How useful is the money datatype? Guy Rouillier 23:42

Oct. 6, 2009

Thread Author Time
Re: How useful is the money datatype? John R Pierce 00:25
Re: ERROR: column "id" inherits conflicting default values 📎 Tom Lane 01:20
Re: Errors regarding transporting database using pg_dump Adrian Klaver 02:18
Re: Errors regarding transporting database using pg_dump Greg Stark 03:36
Fatal error on start Andrew Bartley 04:23
Triggers and SQL Yadisnel Galvez Velazquez 04:24
numeric field overflow Nurzhan Kirbassov 06:20
Re: numeric field overflow Christophe Pettus 06:26
Re: attempted to lock invisible tuple - PG 8.4.1 Stuart Bishop 06:29
Re: numeric field overflow Scott Marlowe 06:30
Re: Documentation on standard conforming strings? Albe Laurenz 07:00
Re: numeric field overflow Scott Ribe 07:01
Re: connection failure Miklosi Attila 08:04
Re: Wishlist of PL/Perl Enhancements for PostgreSQL 8.5 Tim Bunce 08:57

Browse Archives

Prev | Next