pgsql-general - July 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

July 1, 2012

Thread Author Time
Re: how to return results from code block Misa Simic 00:17
Re: Complex database infrastructure - how to? Misa Simic 01:02
ARD update warning (Mac stuff) Scott Ribe 01:13
Re: Complex database infrastructure - how to? Edson Richter 01:46
Re: Conversion of columns during CSV Import Jasen Betts 07:33
Re: Complex database infrastructure - how to? Jasen Betts 07:50
Re: Complex database infrastructure - how to? Jasen Betts 07:56
is there any query so that I may find the list of columns those have rules? AI Rumman 08:33
Re: How to insert record only if primary key does not exist Craig Ringer 14:19
Re: How to insert record only if primary key does not exist Chris Angelico 15:09
PostgreSQL Slony-I Replication Iqbal Aroussi 16:48
Re: How to insert record only if primary key does not exist Edson Richter 22:56
Re: Complex database infrastructure - how to? Edson Richter 23:01

July 2, 2012

Thread Author Time
Test, please ignore. David Fetter 03:17
difference between implicit/explicit cast of integer to interval raf 04:25
Re: difference between implicit/explicit cast of integer to interval Tom Lane 04:54
Do I need archive_mode = on for hot standby? Janne H 07:33
Re: PostgreSQL Slony-I Replication raghu ram 08:32
Re: PostgreSQL Slony-I Replication Albe Laurenz 08:43
Re: PostgreSQL Slony-I Replication Iqbal Aroussi 09:27
Re: PostgreSQL Slony-I Replication Iqbal Aroussi 09:30
Is there a way to recover deleted records if database has not been vacuumed? Frank Church 09:51
Re: Is there a way to recover deleted records if database has not been vacuumed? raghu ram 10:06
Re: is there any query so that I may find the list of columns those have rules? Albe Laurenz 10:46
Re: Is there a way to recover deleted records if database has not been vacuumed? hubert depesz lubaczewski 14:21
Re: Postgresql 9.0.6 alway run VACUUM ANALYZE pg_catalog.pg_attribute Kevin Grittner 15:35
Re: Postgresql 9.0.6 alway run VACUUM ANALYZE pg_catalog.pg_attribute Kevin Grittner 16:14
Query ordering question ajmcello 23:22

July 3, 2012

Thread Author Time
Re: Query ordering question David Johnston 00:11
Re: Query ordering question ajmcello 00:25
Re: Query ordering question David Johnston 01:14
Re: Query ordering question Alban Hertroys 06:40
errors with high connections rate Pawel Veselov 07:19
Re: errors with high connections rate Craig Ringer 07:34
Re: errors with high connections rate John R Pierce 07:54
Re: errors with high connections rate Pawel S. Veselov 08:16
Re: errors with high connections rate Pawel S. Veselov 08:26
Re: Notiffy problem adasko98 09:08
Where should I start for learn development AI Rumman 11:50
Re: Where should I start for learn development Achilleas Mantzios 12:23
Re: Where should I start for learn development Rob Richardson 12:30
Re: Notiffy problem Kevin Grittner 12:44
Re: errors with high connections rate Kevin Grittner 13:01
Re: Where should I start for learn development Kevin Grittner 13:21
Re: Where should I start for learn development Chris Angelico 13:23
Re: errors with high connections rate Craig Ringer 13:27
Re: Where should I start for learn development Craig Ringer 13:32
Re: errors with high connections rate Craig Ringer 13:40
ERROR: function crosstab(unknown, unknown) does not exist Stefan Schwarzer 13:48
Re: ERROR: function crosstab(unknown, unknown) does not exist Adrian Klaver 14:00
Re: ERROR: function crosstab(unknown, unknown) does not exist Tom Lane 14:10
seq-scan or index-scan Andreas Kretschmer 15:58
Re: seq-scan or index-scan Tomas Vondra 16:07
Re: seq-scan or index-scan Tom Lane 16:13
function ave(integer) does not exist Benedict Holland 18:07
Re: function ave(integer) does not exist hubert depesz lubaczewski 18:13
Re: function ave(integer) does not exist Benedict Holland 18:15
TG_COLUMNS_UPDATED david.sahagian 18:31
Re: TG_COLUMNS_UPDATED Bartosz Dmytrak 21:47
The need for clustered indexes to boost TPC-V performance Reza Taheri 23:13

July 4, 2012

Thread Author Time
Cancel a pg_ctl stop Andy Chambers 00:38
Re: The need for clustered indexes to boost TPC-V performance Craig Ringer 05:43
Re: The need for clustered indexes to boost TPC-V performance Thomas Kellerer 07:57
: Postgresql Error after recovery Venkat Balaji 08:30
Re: The need for clustered indexes to boost TPC-V performance Craig Ringer 08:31
Re: : Postgresql Error after recovery Raghavendra 08:41
Re: : Postgresql Error after recovery Raghavendra 08:42
Re: : Postgresql Error after recovery Venkat Balaji 09:46
Re: : Postgresql Error after recovery Raghavendra 10:05
Re: : Postgresql Error after recovery Venkat Balaji 10:29
Re: The need for clustered indexes to boost TPC-V performance Daniel Farina 13:39
Re: View parsing Bartosz Dmytrak 14:20
Re: The need for clustered indexes to boost TPC-V performance Claudio Freire 14:26
Re: TG_COLUMNS_UPDATED Josh Kupershmidt 18:33

July 5, 2012

Thread Author Time
question about source download site. Tomonari Katsumata 05:11
Re: question about source download site. Tatsuo Ishii 06:15
Re: seq-scan or index-scan Andreas Kretschmer 06:16
Re: ERROR: function crosstab(unknown, unknown) does not exist Stefan Schwarzer 06:20
Re: question about source download site. Magnus Hagander 09:06
Re: The need for clustered indexes to boost TPC-V performance Robert Klemme 12:30
Re: ERROR: function crosstab(unknown, unknown) does not exist Adrian Klaver 14:35
Re: ERROR: function crosstab(unknown, unknown) does not exist Stefan Schwarzer 14:46
Re: ERROR: function crosstab(unknown, unknown) does not exist Tom Lane 14:51
Re: ERROR: function crosstab(unknown, unknown) does not exist Adrian Klaver 15:02
Re: ERROR: function crosstab(unknown, unknown) does not exist Alban Hertroys 15:09
Re: Cancel a pg_ctl stop Magnus Hagander 16:12
Re: ERROR: function crosstab(unknown, unknown) does not exist Thomas Munro 18:00
Re: The need for clustered indexes to boost TPC-V performance Reza Taheri 19:10
Re: The need for clustered indexes to boost TPC-V performance Reza Taheri 19:13
Re: The need for clustered indexes to boost TPC-V performance Samuel Gendler 19:46
Re: The need for clustered indexes to boost TPC-V performance Reza Taheri 20:37
Re: The need for clustered indexes to boost TPC-V performance Samuel Gendler 20:52
Packt's PostgreSQL 9 Administration Cookbook: LITE Editions? James Hartley 21:09
Server writing short WAL files beamsplitter 21:31
Re: Packt's PostgreSQL 9 Administration Cookbook: LITE Editions? Steve Atkins 21:47
Suboptimal query plan fixed by replacing OR with UNION Steven Schlansker 21:57
Re: Server writing short WAL files Tom Lane 22:00
Re: Suboptimal query plan fixed by replacing OR with UNION Tom Lane 22:51
Re: Packt's PostgreSQL 9 Administration Cookbook: LITE Editions? Simon Riggs 22:53
Re: Packt's PostgreSQL 9 Administration Cookbook: LITE Editions? James Hartley 23:03
Re: Suboptimal query plan fixed by replacing OR with UNION Steven Schlansker 23:16

July 6, 2012

Thread Author Time
Issue with extension updates to pg_extension table Keith Fiske 00:07
Re: The need for clustered indexes to boost TPC-V performance Andy Colson 00:41
Re: The need for clustered indexes to boost TPC-V performance Craig Ringer 00:46
Re: The need for clustered indexes to boost TPC-V performance Craig Ringer 00:57
Re: The need for clustered indexes to boost TPC-V performance Reza Taheri 01:00
Re: The need for clustered indexes to boost TPC-V performance Craig Ringer 01:04
Re: Suboptimal query plan fixed by replacing OR with UNION Jasen Betts 01:35
Re: The need for clustered indexes to boost TPC-V performance Greg Smith 01:42
Re: [PERFORM] The need for clustered indexes to boost TPC-V performance Craig Ringer 03:02
Re: The need for clustered indexes to boost TPC-V performance Craig Ringer 03:08
build model from existing db ssylla 03:13
Draw Model from existing DB ssylla 03:28
Re: The need for clustered indexes to boost TPC-V performance Reza Taheri 03:33
Re: The need for clustered indexes to boost TPC-V performance Reza Taheri 04:19
Re: build model from existing db Craig Ringer 04:36
Re: Draw Model from existing DB Robert Gravsjö 07:04
Dynamic query execution using array ChoonSoo Park 14:02
Re: Dynamic query execution using array Pavel Stehule 15:45
Re: Primary key vs unique index rverghese 16:07
Re: Dynamic query execution using array ChoonSoo Park 16:21
Re: Dynamic query execution using array Pavel Stehule 16:40
Re: Dynamic query execution using array Pavel Stehule 16:41
Re: Primary key vs unique index hubert depesz lubaczewski 17:01
index and data tablespaces on two separate drives or one RAID 0? ach 17:05
Re: Primary key vs unique index Gurjeet Singh 17:54
Re: Primary key vs unique index rverghese 18:07
Re: index and data tablespaces on two separate drives or one RAID 0? John R Pierce 18:11
BUG? Regular expression matching of optional character group at beginning of RE Viktor Rosenfeld 18:49
Query runtime strongly dependent on generated statistics (and fewer statistics are better?) Viktor Rosenfeld 18:53
Tutorial On Connecting LibreOffice to PostgreSQL Available Don Parris 19:13
Re: Primary key vs unique index Gurjeet Singh 19:25
Weird "LIKE" behaviour Andy Chambers 20:16
Re: Weird "LIKE" behaviour David Johnston 20:26
Re: Weird "LIKE" behaviour Andy Chambers 20:34
Re: Weird "LIKE" behaviour David Johnston 20:50
Help with sql Perry Smith 21:34
Re: Suboptimal query plan fixed by replacing OR with UNION Steven Schlansker 23:25

July 7, 2012

Thread Author Time
Re: Help with sql Rob Sargent 00:43
Re: index and data tablespaces on two separate drives or one RAID 0? ach 00:51
Re: Help with sql Steve Crawford 00:56
Re: Re: index and data tablespaces on two separate drives or one RAID 0? John R Pierce 01:03
two-column primary key (not the typical question) Chip Nowacek 02:00
Re: two-column primary key (not the typical question) Chris Travers 02:09
Re: two-column primary key (not the typical question) Gurjeet Singh 02:17
Re: Suboptimal query plan fixed by replacing OR with UNION Gurjeet Singh 04:24
Re: Re: index and data tablespaces on two separate drives or one RAID 0? Joe Miller 13:15
Re: Help with sql Perry Smith 13:48
Re: Help with sql Chris Angelico 14:39
Re: BUG? Regular expression matching of optional character group at beginning of RE Tom Lane 16:09

July 8, 2012

Thread Author Time
recover as much as possible (xlog flush request not satisfied) Wim Goedertier 10:59
Re: recover as much as possible (xlog flush request not satisfied) Tom Lane 16:06

July 9, 2012

Thread Author Time
Re: recover as much as possible (xlog flush request not satisfied) Wim Goedertier 13:02
Re: recover as much as possible (xlog flush request not satisfied) Tom Lane 14:07
Re: Suboptimal query plan fixed by replacing OR with UNION Steven Schlansker 17:35
Re: Tutorial On Connecting LibreOffice to PostgreSQL Available Willy-Bas Loos 22:04
Finding Duplicate Rows during INSERTs Rich Shepard 22:48

July 10, 2012

Thread Author Time
Re: Finding Duplicate Rows during INSERTs Rob Sargent 00:01
Re: Tutorial On Connecting LibreOffice to PostgreSQL Available Don Parris 00:20
Re: Finding Duplicate Rows during INSERTs Rich Shepard 01:03
Re: Finding Duplicate Rows during INSERTs Darren Duncan 02:54
Re: ERROR: function crosstab(unknown, unknown) does not exist Stefan Schwarzer 05:31
Ignore hash indices on replicas Steven Schlansker 07:09
PL/Python error fetching next item from iterator tuanhoanganh 07:27
Pg CRUD for joined tables gvim 14:10
Re: C-Functions using SPI - Missing Magic Block eugeniotapias 15:54
Re: The need for clustered indexes to boost TPC-V performance Merlin Moncure 19:05
Re: The need for clustered indexes to boost TPC-V performance Reza Taheri 19:35
Transaction question Jeff Ross 20:06
Error with plpython Efraín Déctor 21:59
Re: BUG? Regular expression matching of optional character group at beginning of RE Tom Lane 22:03
Error with plpython Efraín Déctor 22:16
Sequence moves forward when failover is triggerred Andy Chambers 22:17
Re: Do I need archive_mode = on for hot standby? Andy Chambers 22:26
Re: Sequence moves forward when failover is triggerred Tom Lane 22:48
Python + listen/notify Filipe Brandão 22:56
Re: Sequence moves forward when failover is triggerred Andy Chambers 23:23

July 11, 2012

Thread Author Time
Re: Transaction question Adrian Klaver 00:21
Re: Error with plpython Adrian Klaver 00:24
Re: Error with plpython Efraín Déctor 00:34
Re: Error with plpython Adrian Klaver 01:57
Re: Transaction question Jeff Ross 02:30
Re: Transaction question Adrian Klaver 02:39
Re: Python + listen/notify Josh Kupershmidt 03:20
Re: Error with plpython Craig Ringer 03:43
Re: Sequence moves forward when failover is triggerred Craig Ringer 03:47
Re: Sequence moves forward when failover is triggerred Berend Tober 05:01
Bug? Prepared queries continue to use search_path from their preparation time Toby Corkindale 07:43
foreign keys with constant part Marc Mamin 10:41
Fulltext Search Function Jeremaine Johnson 11:20
question about installation martin soethof 12:58
Key not present in table, but it is. Emanuel Calvo 13:20
Re: Error with plpython Efraín Déctor 13:32
Re: Transaction question Jeff Ross 14:01
Re: Bug? Prepared queries continue to use search_path from their preparation time Tom Lane 14:07
Re: Bug? Prepared queries continue to use search_path from their preparation time Jerry Sievers 14:34
Re: Bug? Prepared queries continue to use search_path from their preparation time Jerry Sievers 14:34
installation problem with postgres password KOTa 14:47
Please Post Gregorio, Albert 15:13
Fulltext Search Function Jeremaine Johnson 15:17

Browse Archives

Prev | Next