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

Browse Archives

Prev | Next

Sept. 1, 2012

Thread Author Time
Re: CASE/WHEN behavior with NULLS David Johnston 00:25
Re: CASE/WHEN behavior with NULLS Tom Lane 01:52
Re: CASE/WHEN behavior with NULLS David Johnston 02:07
Re: CASE/WHEN behavior with NULLS Chris Angelico 02:41
Re: CASE/WHEN behavior with NULLS Tom Lane 02:49
Re: CASE/WHEN behavior with NULLS David Johnston 03:19
Re: "Too far out of the mainstream" Andrew Sullivan 03:54
Getting random rows from a table 📎 Gurjeet Singh 04:23
Re: CASE/WHEN behavior with NULLS Thalis Kalfigkopoulos 06:07
Re: [GENERAL] RE: [GENERAL] UPDATE RULE to be invoked when UPDATE .. WHERE fails the WHERE predicate ?‏ Dean Rasheed 07:46
Re: "Too far out of the mainstream" Peter Bex 11:24
Re: "Too far out of the mainstream" Edson Richter 12:42
Re: "Too far out of the mainstream" Chris Travers 13:25
Re: "Too far out of the mainstream" David Boreham 13:35
Re: "Too far out of the mainstream" Chris Travers 13:50
Re: Getting random rows from a table Raymond O'Donnell 14:17
Re: "Too far out of the mainstream" Scott Marlowe 14:45
Re: "Too far out of the mainstream" Chris Travers 14:53
Re: "Too far out of the mainstream" Tom Lane 15:01
Re: "Too far out of the mainstream" Scott Marlowe 15:27
Re: "Too far out of the mainstream" Pavel Stehule 15:33
Re: "Too far out of the mainstream" Pavel Stehule 15:45
Re: "Too far out of the mainstream" Stefan Kaltenbrunner 18:13
Re: [HACKERS] Date conversion using day of week 📎 Bruce Momjian 21:11
Re: [HACKERS] Date conversion using day of week Bruce Momjian 21:11
Re: [GENERAL] Date conversion using day of week 📎 Bruce Momjian 21:14

Sept. 2, 2012

Thread Author Time
Re: Estimated rows question Tom Lane 00:47
Re: "Too far out of the mainstream" Johan Nel 06:32
Re: CASE/WHEN behavior with NULLS Jasen Betts 07:02
Re: "Too far out of the mainstream" Chris Travers 07:06
Re: C locale versus en_US.UTF8. (Was: String comparision in PostgreSQL) Jasen Betts 07:25
Re: GRANT SELECT Jasen Betts 07:54
Re: CASE/WHEN behavior with NULLS Craig Ringer 11:41
Re: [GENERAL] Multiple Slave Failover with PITR Bruce Momjian 12:12
Re: Naming conventions 📎 Bruce Momjian 12:42
Re: Dtrace for tracing PostgreSQL link not working 📎 Bruce Momjian 13:16
[No subject] Steve Haresnape 20:56
RE: [GENERAL] UPDATE RULE to be invoked when UPDATE .. WHERE fails the WHERE predicate ?‏ johnlumby 21:42

Sept. 3, 2012

Thread Author Time
Re: fast-archiver tool, useful for pgsql DB backups Peter Eisentraut 05:04
Re: C locale versus en_US.UTF8. (Was: String comparision in PostgreSQL) Peter Eisentraut 05:08
Reduce the time to know trigger_fi​le's existence Harshitha S 06:22
Reduce the time to know trigger_file's existence togetinfo mail 06:24
Reduce the time to know trigger_fi​le's existence Harshitha S 06:30
Re: [GENERAL] Multiple Slave Failover with PITR Daniel Farina 06:58
Postgres not getting logged in from command prompt Himanshu Joshi 07:43
Re: Postgres not getting logged in from command prompt Albe Laurenz 08:10
Re: [GENERAL] UPDATE RULE to be invoked when UPDATE .. WHERE fails the WHERE predicate ?‏ Dean Rasheed 08:31
Re: [GENERAL] Multiple Slave Failover with PITR 📎 Sergey Konoplev 09:07
Re: Postgres not getting logged in from command prompt Magnus Hagander 10:59
Create loop in postgresql Robert Buckley 15:30
Re: Create loop in postgresql salah jubeh 15:45
Re: Create loop in postgresql Rainer Pruy 15:56
Re: Create loop in postgresql Robert Buckley 16:06
Re: Create loop in postgresql Rainer Pruy 16:12
Re: Create loop in postgresql Raymond O'Donnell 16:16
Re: Create loop in postgresql salah jubeh 16:23
Re: Create loop in postgresql Robert Buckley 16:33
Re: Create loop in postgresql Robert Buckley 17:30
Re: Create loop in postgresql Robert Buckley 17:42
Re: Create loop in postgresql Raymond O'Donnell 18:28
Re: Create loop in postgresql Raymond O'Donnell 18:29
Re: Create loop in postgresql salah jubeh 18:42
Re: "Too far out of the mainstream" Geert Mak 22:38
Re: "Too far out of the mainstream" Gavin Flower 22:45

Sept. 4, 2012

Thread Author Time
Re: Reduce the time to know trigger_fi​le's existence Craig Ringer 00:58
Re: Reduce the time to know trigger_fi​le's existence Craig Ringer 01:01
Re: [GENERAL] Date conversion using day of week Bruce Momjian 02:53
Null-terminated log entries? Chris Angelico 03:52
Re: [GENERAL] Reduce the time to know trigger_fi​le's existence Harshitha S 04:15
Re: [GENERAL] Multiple Slave Failover with PITR Robert Haas 04:31
recovering databases Yvon Thoraval 06:31
Re: [GENERAL] Reduce the time to know trigger_fi​le's existence Magnus Hagander 07:29
SEPostgreSQL alive? Johannes Segitz 07:49
Re: SEPostgreSQL alive? Devrim GÜNDÜZ 07:54
Re: Would my postgresql 8.4.12 profit from doubling RAM? Alexander Farber 08:59
Re: recovering databases Albe Laurenz 09:05
Re: Would my postgresql 8.4.12 profit from doubling RAM? Alexander Farber 09:14
R: I: Installation faillure version 8.4.12 📎 Segato Luca 09:19
Re: I: Installation faillure version 8.4.12 Ashesh Vashi 09:29
I want your opinion on how to do something. Herouth Maoz 09:57
Databas has no Object Identifier Types & Functions Rebecca Clarke 10:28
Re: Databas has no Object Identifier Types & Functions Pavan Deolasee 10:41
Re: Databas has no Object Identifier Types & Functions Rebecca Clarke 11:57
Re: Postgres not getting logged in from command prompt himanshu.joshi 12:21
Re: Reduce the time to know trigger_fi​le's existence Craig Ringer 13:42
Re: Databas has no Object Identifier Types & Functions Chris Travers 14:16
No Default Text Search Parser Rebecca Clarke 14:19
Re: Would my postgresql 8.4.12 profit from doubling RAM? Scott Marlowe 14:43
Re: Databas has no Object Identifier Types & Functions Merlin Moncure 14:58
crosstab punnoose 15:39
Re: crosstab dinesh kumar 16:02
Re: "Too far out of the mainstream" Steve Crawford 17:03
Re: crosstab Aram Fingal 17:15
Re: "Too far out of the mainstream" Mike Christensen 17:28
Re: "Too far out of the mainstream" Scott Marlowe 17:35
A next logical step after index-only scans? Mike Christensen 17:47
Re: "Too far out of the mainstream" Kevin Grittner 18:13
Re: crosstab Vincent Veyron 18:51
Re: crosstab dinesh kumar 19:01
Re: crosstab Aram Fingal 19:17
Re: crosstab Joe Conway 19:26
Re: crosstab Aram Fingal 19:48
Re: crosstab Joe Conway 19:56
Re: "Too far out of the mainstream" Gavin Flower 20:03
Re: crosstab Misa Simic 20:18
Re: crosstab Aram Fingal 20:23
Re: crosstab Aram Fingal 20:30
Re: crosstab A.M. 20:36
Re: "Too far out of the mainstream" Scott Marlowe 20:38
Re: crosstab Misa Simic 20:51
Re: crosstab Merlin Moncure 20:56
Re: crosstab Joe Conway 21:06
Re: "Too far out of the mainstream" Gavin Flower 21:13
Re: Maintaining a materialized view only on a replica Craig Ringer 21:52
Re: crosstab Aram Fingal 21:59
MS Sync framework sync SQL Server 2012 to PostgreSQL 9 Claire Chang 23:11
Re: crosstab Joe Conway 23:21
Re: crosstab Misa Simic 23:45
Re: crosstab Misa Simic 23:49
Re: MS Sync framework sync SQL Server 2012 to PostgreSQL 9 Craig Ringer 23:59
Re: "Too far out of the mainstream" Scott Marlowe 23:59
Re: crosstab Joe Conway 23:59

Sept. 5, 2012

Thread Author Time
Re: crosstab Misa Simic 00:21
Re: "Too far out of the mainstream" Geert Mak 00:30
postgres process got stuck in "notify interrupt waiting" status Aleksey Tsalolikhin 01:21
regexp_matches question Sergio Basurto 01:39
Re: regexp_matches question David Johnston 01:58
Re: postgres process got stuck in "notify interrupt waiting" status Aleksey Tsalolikhin 02:09
Re: "Too far out of the mainstream" Chris Travers 02:14
Re: postgres process got stuck in "notify interrupt waiting" status John R Pierce 02:21
Re: postgres process got stuck in "notify interrupt waiting" status Aleksey Tsalolikhin 02:25
Re: "Too far out of the mainstream" Ondrej Ivanič 04:06
Re: Are there any options to parallelize queries? Michael Paquier 05:21
Re: Are there any options to parallelize queries? Aleksey Tsalolikhin 05:27
Re: "Too far out of the mainstream" Chris Travers 05:51
Re: postgres process got stuck in "notify interrupt waiting" status Albe Laurenz 07:22
Re: Are there any options to parallelize queries? Seref Arikan 07:23
Re: "Too far out of the mainstream" Oliver Kohll - Mailing Lists 08:19
Re: "Too far out of the mainstream" Ivan Sergio Borgonovo 08:51
Re: postgres process got stuck in "notify interrupt waiting" status Craig Ringer 09:27
Re: "Too far out of the mainstream" Achilleas Mantzios 09:40
Re: Maintaining a materialized view only on a replica Herouth Maoz 12:08
Re: Error stopping postgresql service on a standby server. Dipti Bharvirkar 12:14
Re: "Too far out of the mainstream" Chris Angelico 13:44
pgBadger 2.0 released damien clochard 13:46
Re: "Too far out of the mainstream" Achilleas Mantzios 14:01
alter view, add/drop column Gauthier, Dave 14:16
Re: postgres process got stuck in "notify interrupt waiting" status Tom Lane 14:38
Re: alter view, add/drop column Johan Nel 15:15
Re: postgres process got stuck in "notify interrupt waiting" status Aleksey Tsalolikhin 15:17
Re: postgres process got stuck in "notify interrupt waiting" status Kevin Grittner 15:29
Re: postgres process got stuck in "notify interrupt waiting" status Tom Lane 15:33
Where is the char and varchar length in pg_catalog for function input variables jam3 15:40
Re: Where is the char and varchar length in pg_catalog for function input variables Tom Lane 16:05
Re: Where is the char and varchar length in pg_catalog for function input variables Pavan Deolasee 16:19
Re: Where is the char and varchar length in pg_catalog for function input variables jam3 16:25
Re: Where is the char and varchar length in pg_catalog for function input variables Pavel Stehule 16:33
Re: postgres process got stuck in "notify interrupt waiting" status Aleksey Tsalolikhin 16:36
Re: postgres process got stuck in "notify interrupt waiting" status Tom Lane 17:03
values from txid_current() Sahagian, David 17:23
Re: values from txid_current() Pavan Deolasee 17:46
Re: values from txid_current() Sahagian, David 18:04
Moving several databases into one database with several schemas Edson Richter 18:30
Re: postgres process got stuck in "notify interrupt waiting" status Aleksey Tsalolikhin 18:44
Re: Where is the char and varchar length in pg_catalog for function input variables jam3 18:49
Re: "Too far out of the mainstream" jam3 19:08
Re: Where is the char and varchar length in pg_catalog for function input variables jam3 19:25
Re: Where is the char and varchar length in pg_catalog for function input variables jam3 19:33
Re: Would my postgresql 8.4.12 profit from doubling RAM? jam3 20:16
max_connections Modumudi, Sireesha 20:30
Re: max_connections Scott Marlowe 20:34
When does Postgres cache query plans? Mike Christensen 20:38
Re: "Too far out of the mainstream" Magnus Hagander 20:40
Re: max_connections Kevin Grittner 20:42
Re: max_connections jam3 20:51
Re: Where is the char and varchar length in pg_catalog for function input variables Kevin Grittner 21:02
Re: Re: Where is the char and varchar length in pg_catalog for function input variables David Johnston 21:05
Re: Would my postgresql 8.4.12 profit from doubling RAM? Scott Marlowe 21:10
Re: Re: Where is the char and varchar length in pg_catalog for function input variables David Johnston 21:27
Re: Re: Where is the char and varchar length in pg_catalog for function input variables Kevin Grittner 21:41
Re: Moving several databases into one database with several schemas Edson Richter 22:47
Re: When does Postgres cache query plans? Tom Lane 22:51
Re: regexp_matches question Sergio Basurto 23:02
Re: When does Postgres cache query plans? Mike Christensen 23:06

Sept. 6, 2012

Thread Author Time
Re: regexp_matches question David Johnston 01:15
Re: "Too far out of the mainstream" David Boreham 02:20
Re: "Too far out of the mainstream" Chris Travers 02:41
Re: "Too far out of the mainstream" Chris Travers 02:49
Re: "Too far out of the mainstream" Damian Carey 02:55
Re: "Too far out of the mainstream" Edson Richter 02:56
Re: "Too far out of the mainstream" Scott Marlowe 03:39
Re: "Too far out of the mainstream" Edson Richter 04:43
pivot functions with variable number of columns punnoose 05:14
Re: "Too far out of the mainstream" Chris Travers 05:34
Re: pivot functions with variable number of columns Raghavendra 07:27
Re: pivot functions with variable number of columns Chris Travers 07:40
Re: Moving several databases into one database with several schemas Albe Laurenz 08:12
Re: max_connections Albe Laurenz 08:20
Re: pivot functions with variable number of columns Vincent Veyron 10:40
Re: Moving several databases into one database with several schemas Edson Richter 12:03

Browse Archives

Prev | Next