pgsql-general - August 2012

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

Aug. 1, 2012

Thread Author Time
Re: Installing on IBM AIX 7.1 Tom Lane 05:00
Append second slave to Warm Standby running on postgresql v8.4 master->slave cluster Капралов Александр 07:22
Threads With Libpq Issue dinesh kumar 09:19
Threads With Libpq dinesh kumar 12:32
Re: Threads With Libpq Alban Hertroys 13:09
Re: Where should I start for learn development AI Rumman 13:59
Re: Threads With Libpq Merlin Moncure 14:03
Re: Threads With Libpq dinesh kumar 15:04
Streaming replication and high query cancellation values Christophe Pettus 20:03
Need help with SQL query and finding NULL array_agg Condor 20:16
Re: File system level backup Kevin Grittner 20:48
Re: Need help with SQL query and finding NULL array_agg David Johnston 20:59
Re: Streaming replication and high query cancellation values Michael Nolan 20:59
Async replication: how to get an alert on failure Edson Richter 22:29

Aug. 2, 2012

Thread Author Time
Async replication: how to get an alert on failure Edson Richter 00:04
Re: Threads With Libpq Issue Craig Ringer 00:48
Re: Threads With Libpq Issue Craig Ringer 00:50
Re: Async replication: how to get an alert on failure Toby Corkindale 02:50
答复: 答复: [GENERAL] how to calculate or know seq_scan scan how many blocks every time leoxu 03:03
How to get results with zero count from this query? dud 03:14
Re: Async replication: how to get an alert on failure Karl Denninger 03:22
Re: How to get results with zero count from this query? John R Pierce 03:44
subscribe Micah R Ledbetter 03:58
"seeking help to collect some postgres meta data" mithun 06:39
Re: Threads With Libpq Issue dinesh kumar 07:23
Re: Need help with SQL query and finding NULL array_agg Condor 08:34
Re: Threads With Libpq dinesh kumar 12:30
Re: Problem running "ALTER TABLE...", ALTER TABLE waiting Sergey Konoplev 12:57
How to don't update sequence on rollback of a transaction Frank Lanitz 15:08
Re: How to don't update sequence on rollback of a transaction Andrew Hastie 15:15
Re: "seeking help to collect some postgres meta data" Bruce Momjian 16:07
Re: How to don't update sequence on rollback of a transaction Chris Angelico 16:30
The semantics of (NULL,NULL) vs NULL Ingmar Brouns 16:47
Re: The semantics of (NULL,NULL) vs NULL Peter Geoghegan 17:15
Re: The semantics of (NULL,NULL) vs NULL Kevin Grittner 17:34
Re: Need help with SQL query and finding NULL array_agg David Johnston 18:32
Error: [Custom Archiver]: Out of memory Edison So 19:25
Re: Error: [Custom Archiver]: Out of memory John R Pierce 20:00

Aug. 3, 2012

Thread Author Time
Re: How to don't update sequence on rollback of a transaction Craig Ringer 00:00
Re: Singleton table (was Re: How to don't update sequence on rollback of a transaction) Craig Ringer 05:36
Re: Need help with SQL query and finding NULL array_agg Condor 07:19
Re: How to don't update sequence on rollback of a transaction Frank Lanitz 07:54
Re: How to don't update sequence on rollback of a transaction Frank Lanitz 07:56
Re: Async replication: how to get an alert on failure Edson Richter 11:12
Re: How to don't update sequence on rollback of a transaction Julian 12:59
Range-Types in 9.2 Andreas Kretschmer 15:06
Re: Range-Types in 9.2 Jeff Davis 17:42
Re: Range-Types in 9.2 Marc Mamin 18:08
Re: Range-Types in 9.2 Tom Lane 18:25
Another question about Range types Mike Christensen 20:00
strategies for segregating client data when using PostgreSQL in a web app Menelaos PerdikeasSemantix 20:05
Re: How to don't update sequence on rollback of a transaction Scott Marlowe 20:07
Re: Another question about Range types Francisco Figueiredo Jr. 20:11
Re: strategies for segregating client data when using PostgreSQL in a web app Chris Angelico 20:18
Re: Another question about Range types Mike Christensen 20:25
Re: strategies for segregating client data when using PostgreSQL in a web app Rory Campbell-Lange 21:08
Re: Another question about Range types Francisco Figueiredo Jr. 21:23
Re: Another question about Range types David Johnston 21:52
Re: Another question about Range types Mike Christensen 22:03
Re: strategies for segregating client data when using PostgreSQL in a web app David Johnston 22:25
Re: Another question about Range types David Johnston 22:38
Re: Another question about Range types Mike Christensen 22:55
Re: Another question about Range types David Johnston 23:43

Aug. 4, 2012

Thread Author Time
Installer problem report with interesting solution Craig Ringer 01:39
Character validation with DB2 Fed Server and Optim Alexander Gataric 03:02
Re: Debian upgrade with PostgreSQL Jasen Betts 05:07
Re: Postgresql Developer Privileges Jasen Betts 06:27
Re: Installer problem report with interesting solution Thomas Kellerer 07:08
Re: Range-Types in 9.2 Andreas Kretschmer 07:14
Re: Smaller data types use same disk space Jasen Betts 08:52
Re: Installer problem report with interesting solution Craig Ringer 09:05
Re: can we avoid pg_basebackup on planned switches? Ben Chobot 13:14
maximum number of databases and / or schemas in a single database instance Menelaos PerdikeasSemantix 19:24
Re: Range-Types in 9.2 Scott Bailey 20:10
Pgadmin3 v1.14.2 foreign keys Mary F. Masterson 20:10
Re: Pgadmin3 v1.14.2 foreign keys Adrian Klaver 20:44
Pgadmin3 v1.14.2 foreign keys Mary F. Masterson 20:56

Aug. 5, 2012

Thread Author Time
Re: maximum number of databases and / or schemas in a single database instance Tom Lane 04:05
Re: maximum number of databases and / or schemas in a single database instance Chris Angelico 04:34
Is this a Postgres Bug? Mike Christensen 05:14
Re: Is this a Postgres Bug? Xiong He 09:13
Re: Is this a Postgres Bug? Tomas Vondra 12:29
Re: Is this a Postgres Bug? Mike Christensen 15:58
Re: can we avoid pg_basebackup on planned switches? Fujii Masao 18:12
Re: can we avoid pg_basebackup on planned switches? Ben Chobot 18:29

Aug. 6, 2012

Thread Author Time
Re: Is this a Postgres Bug? Mike Christensen 02:56
Is it possible to create row-wise indexable condition for special case... Maxim Boguk 05:39
Streaming replication failover with 3 servers Stuart Bishop 07:55
Hi,Frirends, are there any commands in pgsql/bin/ corresponding "create tablespace"? sunpeng 09:22
Re: Where is diskchecker.pl ? Magnus Hagander 09:26
Re: Hi,Frirends, are there any commands in pgsql/bin/ corresponding "create tablespace"? Magnus Hagander 09:31
Re: postgres 9 bind address for replication Magnus Hagander 09:53
Re: Clogging problem (was: Schema-only dump dumps no constraints, no triggers) Marek Kielar 12:08
Re: Is it possible to create row-wise indexable condition for special case... François Beausoleil 13:09
How to analyze load average ? Condor 14:23
Re: How to analyze load average ? Tomas Vondra 14:38
Re: How to analyze load average ? Mark Felder 14:54
Re: Clogging problem Adrian Klaver 15:00
Re: How to analyze load average ? Tomas Vondra 15:27
Re: How to analyze load average ? Mark Felder 15:42
Re: Where is diskchecker.pl ? Bruce Momjian 16:31
Re: Where is diskchecker.pl ? Rodrigo Gonzalez 16:54
Re: How to analyze load average ? Condor 17:06
Mailsystem maintenance/migration announcement Stefan Kaltenbrunner 17:21
Re: How to analyze load average ? Kevin Grittner 17:25
Re: maximum number of databases and / or schemas in a single database instance Ben Chobot 17:26
Re: Hi,Frirends, are there any commands in pgsql/bin/ corresponding "create tablespace"? David Salisbury 17:47
Re: Range-Types in 9.2 Jeff Davis 17:51
Re: Range-Types in 9.2 David Johnston 18:09
Re: How to analyze load average ? Tomas Vondra 18:30
Re: Range-Types in 9.2 Misa Simic 19:30
Re: How to analyze load average ? Martijn van Oosterhout 21:08

Aug. 7, 2012

Thread Author Time
How does connect privilege works? Shridhar Daithankar 03:51
timestamp with timezone and time zone name Shridhar Daithankar 03:53
Re: timestamp with timezone and time zone name Tom Lane 04:21
Re: How does connect privilege works? Craig Ringer 08:07
JSON in 9.2: limitations Craig Ringer 08:20
Re: How does connect privilege works? Albe Laurenz 08:34
warnings about invalid "search_path" Samba 10:55
Re: warnings about invalid "search_path" Gabriele Bartolini 11:23
Memory error in user-defined aggregation function Adriaan Joubert 12:04
Interval "1 month" is equals to interval "30 days" - WHY? Dmitry Koterov 12:42
Re: Clogging problem Marek Kielar 12:49
Re: Interval "1 month" is equals to interval "30 days" - WHY? Dmitry Koterov 12:52
Re: Where is diskchecker.pl ? Magnus Hagander 13:00
pg_xlog growth on slave with streaming replication Mike Roest 13:08
Re: warnings about invalid "search_path" Samba 13:15
Pg_ctl promote -- wait for slave to be promoted fully ? Magnus Hagander 13:22
Are stored procedures always kept in memory? Roman Golis 14:12
Re: Are stored procedures always kept in memory? Pavel Stehule 14:19
Re: warnings about invalid "search_path" Tom Lane 14:19
Re: warnings about invalid "search_path" Albe Laurenz 14:20
Re: warnings about invalid "search_path" Samba 14:35
Re: warnings about invalid "search_path" Scott Marlowe 15:00
Re: Memory error in user-defined aggregation function Tom Lane 15:03
Re: Memory error in user-defined aggregation function Adriaan Joubert 15:06
Interval to months Aram Fingal 15:41
Re: JSON in 9.2: limitations Merlin Moncure 16:31
Re: can we avoid pg_basebackup on planned switches? Fujii Masao 16:32
Installation faillure version 8.4.12 Segato Luca 16:48
Re: Feature Request - Postgres FDW Kevin Grittner 17:04
Re: Feature Request - Postgres FDW Andreas Kretschmer 17:06
Re: Pg_ctl promote -- wait for slave to be promoted fully ? Fujii Masao 17:09
Re: Feature Request - Postgres FDW David Greco 17:16
Re: Re: BUG #6742: pg_dump doesn't convert encoding of DB object names to OS encoding Robert Haas 17:24
Re: can we avoid pg_basebackup on planned switches? Ben Chobot 17:44
Re: JSON in 9.2: limitations Merlin Moncure 19:45
Re: Pg_ctl promote -- wait for slave to be promoted fully ? Robert Haas 20:37
Using Insert with case Bob Pawley 22:26
Re: Using Insert with case Chris Angelico 22:34
Re: Using Insert with case Alban Hertroys 22:40
Re: Using Insert with case Bob Pawley 22:45
Re: Using Insert with case David Johnston 22:51
Re: Problem running "ALTER TABLE...", ALTER TABLE waiting Brian McNally 23:03

Aug. 8, 2012

Thread Author Time
PostgreSQL 9.1 product code Haiming Zhang 00:17
Re: Problem running "ALTER TABLE...", ALTER TABLE waiting Sergey Konoplev 00:19
Re: JSON in 9.2: limitations Craig Ringer 00:26
Re: PostgreSQL 9.1 product code Craig Ringer 01:14
Re: timestamp with timezone and time zone name Shridhar Daithankar 03:36
Re: Installation faillure version 8.4.12 John R Pierce 07:46
Re: Interval "1 month" is equals to interval "30 days" - WHY? Albe Laurenz 09:54
Re: File system level backup Manoj Agarwal 10:43
Re: postgis and pgpool gwainer 11:27
Re: Interval "1 month" is equals to interval "30 days" - WHY? Dmitry Koterov 11:27
Re: Interval "1 month" is equals to interval "30 days" - WHY? Craig Ringer 11:57
Re: Interval "1 month" is equals to interval "30 days" - WHY? Anthony 12:27
Re: Interval "1 month" is equals to interval "30 days" - WHY? Albe Laurenz 12:51
Re: Interval "1 month" is equals to interval "30 days" - WHY? Albe Laurenz 12:56
pgAgent job keeps running mwkhan 13:20
Re: Interval "1 month" is equals to interval "30 days" - WHY? Craig Ringer 13:39
Re: warnings about invalid "search_path" Samba 13:54
Fwd: Re: Interval "1 month" is equals to interval "30 days" - WHY? Michael Trausch 14:16
Using contains operator on arrays that have duplicate elements: feedback request. Seref Arikan 14:34
Re: Using contains operator on arrays that have duplicate elements: feedback request. David Johnston 14:45
Re: Using contains operator on arrays that have duplicate elements: feedback request. Seref Arikan 15:04
Re: File system level backup Kevin Grittner 16:45
Re: timestamp with timezone and time zone name Steve Crawford 17:13
Re: Problem running "ALTER TABLE...", ALTER TABLE waiting Brian McNally 18:52
processing large amount of rows with plpgsql Geert Mak 19:41
postgresql service stoped Fanbin Meng 20:35

Aug. 9, 2012

Thread Author Time
Re: Problem running "ALTER TABLE...", ALTER TABLE waiting Tom Lane 00:58
Re: processing large amount of rows with plpgsql Geert Mak 05:57
Re: processing large amount of rows with plpgsql Marc Mamin 07:19
Re: Problem running "ALTER TABLE...", ALTER TABLE waiting Sergey Konoplev 07:30
Expression alias not recognized in WHERE clause (ERROR: relation "p" does not exist) Stefan Keller 11:32
Re: Expression alias not recognized in WHERE clause (ERROR: relation "p" does not exist) Alban Hertroys 12:23
Re: Expression alias not recognized in WHERE clause (ERROR: relation "p" does not exist) Tomas Vondra 12:33
Re: Expression alias not recognized in WHERE clause (ERROR: relation "p" does not exist) David Johnston 12:38
Re: JSON in 9.2: limitations Merlin Moncure 13:58
Slow query Nicholas Wieland 15:47
Re: Slow query David Johnston 16:11
Re: Slow query Kevin Grittner 16:35
Function to dump function ddl Little, Douglas 17:06
documentation — version switch Geert Mak 17:09
Re: Revoking table & function creation privileges Mike Blackwell 18:02
Full-text search: Problems with dictionaries and periods Theron Luhn 20:57

Aug. 10, 2012

Thread Author Time
change column data type of a big table Anibal David Acosta 05:31
Re: change column data type of a big table John R Pierce 06:05
Re: Function to dump function ddl Albe Laurenz 08:51
Postgres and Upstart Chris Angelico 10:32

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