pgsql-general since 2009-10-06 00:00

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. 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
Re: numeric field overflow David W Noon 10:05
Re: Wishlist of PL/Perl Enhancements for PostgreSQL 8.5 David Fetter 11:44
adding another node to our pitr config Geoffrey 12:51
Re: Wishlist of PL/Perl Enhancements for PostgreSQL 8.5 Stephen Frost 13:19
Re: attempted to lock invisible tuple - PG 8.4.1 Alvaro Herrera 13:28
Re: Wishlist of PL/Perl Enhancements for PostgreSQL 8.5 Alvaro Herrera 13:34
Re: attempted to lock invisible tuple - PG 8.4.1 Stuart Bishop 13:43
Re: attempted to lock invisible tuple - PG 8.4.1 Alvaro Herrera 14:45
LF PostgreSQL virtual Linux host provider in India and/or Asia Pac Alan McKay 15:25
Re: attempted to lock invisible tuple - PG 8.4.1 📎 Alvaro Herrera 16:12
Re: Wishlist of PL/Perl Enhancements for PostgreSQL 8.5 David Fetter 16:18
Re: Wishlist of PL/Perl Enhancements for PostgreSQL 8.5 Richard Huxton 16:27
Re: attempted to lock invisible tuple - PG 8.4.1 Alvaro Herrera 16:46
is it possible to do an update with a nested select that references the outer update ? Jonathan Vanasco 16:57
Re: attempted to lock invisible tuple - PG 8.4.1 📎 Alvaro Herrera 17:21
Re: attempted to lock invisible tuple - PG 8.4.1 Alvaro Herrera 17:36
Re: Wishlist of PL/Perl Enhancements for PostgreSQL 8.5 Filip Rembiałkowski 17:41
Re: is it possible to do an update with a nested select that references the outer update ? Alban Hertroys 17:48
initdb failing Sachin Srivastava 18:00
Re: initdb failing Raymond O'Donnell 18:11
Re: Wishlist of PL/Perl Enhancements for PostgreSQL 8.5 Alvaro Herrera 18:18
Re: initdb failing Sachin Srivastava 19:09
Re: attempted to lock invisible tuple - PG 8.4.1 Alvaro Herrera 19:16
Re: Wishlist of PL/Perl Enhancements for PostgreSQL 8.5 Richard Huxton 19:45
interface for "non-SQL people" pere roca 19:47
Re: initdb failing Scott Mead 19:54
contrib/plantuner - enable PostgreSQL planner hints Oleg Bartunov 19:57
Re: attempted to lock invisible tuple - PG 8.4.1 📎 Alvaro Herrera 20:09
Re: initdb failing Sachin Srivastava 20:10
Re: Fatal error on start Andrew Bartley 20:23
Re: Wishlist of PL/Perl Enhancements for PostgreSQL 8.5 Tim Bunce 20:34
Composite types and tables - when to use? Postgres User 20:43
Composite types and tables - when to use? Postgres User 20:49
Re: interface for "non-SQL people" Postgres User 20:56
pg_dumpall asking for password for each database Krzysztof Barlik 20:59
Re: Composite types and tables - when to use? Merlin Moncure 20:59
Re: pg_dumpall asking for password for each database Scott Mead 21:11
Re: pg_dumpall asking for password for each database Joshua D. Drake 21:45
Re: Postgres won't start. Nothing in the log. Tim Uckun 22:14
Re: pg_dumpall asking for password for each database Alvaro Herrera 22:59
Re: interface for "non-SQL people" Alvaro Herrera 23:08

Oct. 7, 2009

Thread Author Time
Re: Vacuumdb Fails: Huge Tuple APseudoUtopia 01:12
Need help in spi_prepare errors paresh masani 05:48
Re: attempted to lock invisible tuple - PG 8.4.1 Stuart Bishop 06:53
SSIS and Postgres Jamie Lawrence-Jenner 08:26
problems with encoding Karina Guardado 09:44
pg_dump with 1100 schemas being a bit slow Loic d'Anterroches 10:51
current_query stat is idle mezgani ali 11:47
Re: Need help in spi_prepare errors Tom Lane 14:16
Re: pg_dump with 1100 schemas being a bit slow Tom Lane 14:23
Re: Need help in spi_prepare errors Alvaro Herrera 14:24
How to troubleshoot authentication failure? Kynn Jones 14:57
Re: How to troubleshoot authentication failure? Alvaro Herrera 15:17
Re: LF PostgreSQL virtual Linux host provider in India and/or Asia Pac Alan McKay 15:20
Re: pg_dump with 1100 schemas being a bit slow Loic d'Anterroches 15:48
Re: pg_dump with 1100 schemas being a bit slow Bill Moran 15:54
Re: pg_dump with 1100 schemas being a bit slow Massa, Harald Armin 16:00
Re: pg_dump with 1100 schemas being a bit slow Loic d'Anterroches 16:20
Re: pg_dump with 1100 schemas being a bit slow Loic d'Anterroches 16:25
Re: pg_dump with 1100 schemas being a bit slow Joshua D. Drake 16:29
Re: automated row deletion Dave Huber 16:49
Re: automated row deletion John R Pierce 17:01
Re: pg_dump with 1100 schemas being a bit slow Loic d'Anterroches 17:52
Re: automated row deletion Dave Huber 18:20
Re: How to troubleshoot authentication failure? Greg Smith 18:35
Using complex PRIMARY KEY Zsolt 19:19
Re: Using complex PRIMARY KEY Sam Mason 20:34
Re: How to troubleshoot authentication failure? Kynn Jones 20:59

Oct. 8, 2009

Thread Author Time
Re: Need help in spi_prepare errors paresh masani 04:07
Re: Using complex PRIMARY KEY A. Kretschmer 05:31
Re: Using complex PRIMARY KEY Gurjeet Singh 07:32
Re: Using complex PRIMARY KEY A. Kretschmer 07:54
How to reduce WAL file Size Mitesh51 08:57
Re: interface for "non-SQL people" ssmagin 10:53
Need info on PQfmod() shrikant hanagodimath 12:53
Query inside RTF Leonardo M. Ramé 13:58
cost of query done - recorded anywhere? Massa, Harald Armin 14:56
Tips/Hacks to create minial DB from the execution of several (simple) SQL requests. Daniel Shane 15:24
Re: Query inside RTF Merlin Moncure 15:28
Re: Query inside RTF Leonardo M. Ramé 15:35
Re: Query inside RTF Sam Mason 15:43
Give me a HINT or I'll got crazy ;) wstrzalka 16:11
Re: How to reduce WAL file Size Emanuel Calvo Franco 16:58
Re: Give me a HINT or I'll got crazy ;) Tom Lane 17:38
Re: Tips/Hacks to create minial DB from the execution of several (simple) SQL requests. Scott Bailey 17:39
Re: Tips/Hacks to create minial DB from the execution of several (simple) SQL requests. Daniel Shane 18:07
Broken WAL recovery, resetting to base timeline David Jantzen 18:08
Remote connection timed out Barbara Stephenson 18:12
Renaming constraints Andreas Kalsch 18:24
Re: Renaming constraints David Fetter 18:37
Re: Remote connection timed out Steve Crawford 18:38
Re: Renaming constraints Andreas Kalsch 19:07
Re: Query inside RTF Emanuel Calvo Franco 20:01
Re: Renaming constraints Tom Lane 20:07
Re: Renaming constraints Thom Brown 20:20
Re: interface for "non-SQL people" Merlin Moncure 20:22
Using pg_catalog to define things across schemas Andreas Kalsch 20:30
Re: Query inside RTF Leonardo M. Ramé 20:41
Re: Query inside RTF Emanuel Calvo Franco 20:51
Re: Query inside RTF Leonardo M. Ramé 21:01
Re: Query inside RTF Alvaro Herrera 21:09
Best data type to use for sales tax percent Mike Christensen 22:04
Re: Best data type to use for sales tax percent Steve Crawford 22:36
Re: Best data type to use for sales tax percent Christophe Pettus 22:39
Re: Best data type to use for sales tax percent Merlin Moncure 23:38
Re: Best data type to use for sales tax percent Mike Christensen 23:50
Re: How to reduce WAL file Size Alban Hertroys 23:54

Oct. 9, 2009

Thread Author Time
Re: Best data type to use for sales tax percent Rich Shepard 00:23
Re: interface for "non-SQL people" Scott Marlowe 01:16
Re: Best data type to use for sales tax percent Lew 03:34
Re: Tips/Hacks to create minial DB from the execution of several (simple) SQL requests. Scott Bailey 05:24
Re: How to reduce WAL file Size Mitesh51 06:48
Re: Best data type to use for sales tax percent Mike Christensen 07:10
Re: Give me a HINT or I'll got crazy ;) Wojciech Strzałka 07:56
pg_stat_statements and slony Tore Halvorsen 08:34
Re: How to reduce WAL file Size Alban Hertroys 09:24
Re: Best data type to use for sales tax percent Peter Eisentraut 10:38
Posgresql to MSsql encoding problem Pedro Doria Meunier 10:39
Re: PostgreSQL reads each 8k block - no larger blocks are used - even on sequential scans Greg Smith 11:02
Re: Best data type to use for sales tax percent Sam Mason 11:13
Re: How to reduce WAL file Size Sam Mason 11:18
Re: Best data type to use for sales tax percent Rich Shepard 12:45
Re: Posgresql to MSsql encoding problem Merlin Moncure 13:11
Re: Posgresql to MSsql encoding problem Sam Mason 13:38
Re: Posgresql to MSsql encoding problem Pedro Doria Meunier 14:49
Re: Posgresql to MSsql encoding problem Scott Marlowe 15:02
Re: Posgresql to MSsql encoding problem Leif B. Kristensen 15:11
Re: interface for "non-SQL people" Joshua D. Drake 15:15
Re: How to reduce WAL file Size Alvaro Herrera 15:41
Re: PostgreSQL reads each 8k block - no larger blocks are used - even on sequential scans Gerhard Wiesinger 15:57
what is the best way to concat fields that may contain null as if they were empty strings Reid Thompson 16:06
Re: interface for "non-SQL people" Andrew Gould 16:06
array question Whit Armstrong 16:17
Re: what is the best way to concat fields that may contain null as if they were empty strings Andreas Kretschmer 16:18
Re: array question Raymond O'Donnell 16:29
Re: numeric field overflow Bruce Momjian 16:29
Re: array question Whit Armstrong 16:41
Integer range? Scott Ribe 16:46
How to identify nested level of trigger Naoko Reeves 16:47
Re: interface for "non-SQL people" Tim Bruce - Postgres 16:52
Inheritance on foreign key Takeichi Kanzaki Cabrera 16:57
Re: [GENERAL] contrib/plantuner - enable PostgreSQL planner hints Bruce Momjian 17:02
Re: interface for "non-SQL people" Joshua D. Drake 17:18
Re: Integer range? Steve Atkins 17:24
full text + snowball + ispell? Dominic Bevacqua 17:31
Re: interface for "non-SQL people" Stephan Szabo 17:32
Re: interface for "non-SQL people" Joshua D. Drake 17:45
Re: Best data type to use for sales tax percent Mike Christensen 18:35
Re: Best data type to use for sales tax percent Mike Christensen 18:36
Re: Best data type to use for sales tax percent Christophe Pettus 18:46
Re: interface for "non-SQL people" Andrew Gould 19:03
Re: [GENERAL] contrib/plantuner - enable PostgreSQL planner hints Oleg Bartunov 19:04
Re: Best data type to use for sales tax percent Mike Christensen 19:14
Re: Best data type to use for sales tax percent Peter Eisentraut 19:18
Re: Best data type to use for sales tax percent Christophe Pettus 19:36
Stuck vacuum... Mike Diehl 19:53
Re: array question Andreas Kretschmer 20:17
array_agg performance Spotts, Christopher 20:27
Regexp confusion Doug Gorley 21:36
Re: interface for "non-SQL people" Merlin Moncure 21:56
transaction ID wraparound - should I use 'VACUUM' or 'VACUUM FULL' ? Michal Szymanski 23:01
Wiki consisting of rows in a db table Kelly Jones 23:07
Re: Regexp confusion Alvaro Herrera 23:37
Re: transaction ID wraparound - should I use 'VACUUM' or 'VACUUM FULL' ? Alvaro Herrera 23:39

Oct. 10, 2009

Thread Author Time
Re: PostgreSQL reads each 8k block - no larger blocks are used - even on sequential scans Tom Lane 02:11
Re: Stuck vacuum... Tom Lane 02:22
Access dynamic NEW.column_name in trigger? Nick 02:23
Re: Regexp confusion Tom Lane 02:31
Re: transaction ID wraparound - should I use 'VACUUM' or 'VACUUM FULL' ? Tom Lane 02:38
Re: Regexp confusion Tom Lane 03:56
Volunteers needed to help staff the PostgreSQL Booth at LISA 2009 Robert Treat 04:01
Re: array_agg performance Tom Lane 04:21
Re: Stuck vacuum... Mike Diehl 06:54
Re: Access dynamic NEW.column_name in trigger? Scott Marlowe 07:40
Re: automated row deletion Jasen Betts 10:12
Re: Best data type to use for sales tax percent Jasen Betts 10:20
Re: Best data type to use for sales tax percent Jasen Betts 10:33
Re: bulk inserts Jasen Betts 10:42
Re: Best data type to use for sales tax percent Roderick A. Anderson 14:53
Re: transaction ID wraparound - should I use 'VACUUM' or 'VACUUM FULL' ? Michal Szymanski 15:05
Re: Best data type to use for sales tax percent Christophe Pettus 16:22
Building PG 8.4.1 with ossp-uuid on Centos 5.3 Christophe Pettus 16:46
Prepared statements with a variable number of parameters Raymond O'Donnell 17:24
Re: Prepared statements with a variable number of parameters Pavel Stehule 17:52
Re: Building PG 8.4.1 with ossp-uuid on Centos 5.3 Tom Lane 18:53
How to send multiple SQL commands from Python? Kynn Jones 19:09

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