pgsql-general - January 2010

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

Jan. 1, 2010

Thread Author Time
Error during make when installing geos for postgis install...still trying Nick 00:35
Save MySQL? HA Andrew Lardinois 02:20
Re: Migration of db Thomas Kellerer 02:24
Re: Save MySQL? HA Peter Geoghegan 04:23
Re: Save MySQL? HA Dann Corbit 04:27
Re: Save MySQL? HA John R Pierce 05:08
Re: Save MySQL? HA Scott Marlowe 05:50
Re: Save MySQL? HA Joshua D. Drake 07:03
Looking for professionals for a PG server move Phoenix Kiula 08:01
Re: Error during make when installing geos for postgis install...still trying John R Pierce 08:17
Re: Save MySQL? HA Joshua D. Drake 08:52
Re: please help Craig Ringer 11:54
Re: Query very slow when in plpgsql function Chris McDonald 16:04
Re: Looking for professionals for a PG server move Andy Colson 16:06
Re: Error during make when installing geos for postgis install...still trying Andy Colson 16:13
Re: please help Rilindo Foster 17:08
Re: Error during make when installing geos for postgis install...still trying Tom Lane 17:28
Benetl, a free ETL tool for files using postgreSQL, is out in version 3.3 benoît carpentier 20:30
Re: Looking for professionals for a PG server move Phoenix Kiula 23:42

Jan. 2, 2010

Thread Author Time
Re: Looking for professionals for a PG server move Tom Lane 00:00
Re: set-level update fails with unique constraint violation Roman Neuhauser 08:40
Re: Error during make when installing geos for postgis install...still trying Mark Cave-Ayland 09:33
Re: Visual DATA editor for PostgreSQL? Dimitri Fontaine 10:41
Re: pg_dump excluding tables content but not table schema Dimitri Fontaine 10:44
Using autogenerated primary key in transaction Andrus 16:40
SELECT does not find table created by itself Andrus 16:46
FM format modifier does not remove leading zero from year Andrus 18:14
Re: set-level update fails with unique constraint violation Scott Marlowe 18:23
please help Shu Ho 19:35
Re: please help Raymond O'Donnell 20:43
Re: please help Adrian Klaver 20:46
Re: Comparing 2 databases Sualeh Fatehi 21:54
Permission; select currval('seq') Ivan K 22:44
Re: please help John R Pierce 22:55
Re: Permission; select currval('seq') Adrian Klaver 23:14
Re: Permission; select currval('seq') Tom Lane 23:18
Re: Permission; select currval('seq') Ivan K 23:57

Jan. 3, 2010

Thread Author Time
Re: Permission; select currval('seq') Adrian Klaver 00:20
split to table by space Jamie Kahgee 01:35
Deadlocks On Demand David Fetter 02:43
Re: split to table by space Brian Modra 06:30
Re: split to table by space Allan Kamau 06:37
Re: split to table by space Allan Kamau 06:40
WEIRD! postmaster: segfault with sub select??! Reto 08:31
Re: set-level update fails with unique constraint violation Roman Neuhauser 09:16
Innotop for postgresl Alexis Michon 12:10
Re: Innotop for postgresl Emanuel Calvo Franco 12:44
Re: Deadlocks On Demand Allan Kamau 16:18
Re: set-level update fails with unique constraint violation David Fetter 18:02
Re: WEIRD! postmaster: segfault with sub select??! Alban Hertroys 18:50
Re: WEIRD! postmaster: segfault with sub select??! Greg Stark 18:58
Curious index selection when using a date range Robert Gravsjö 20:10
Re: Curious index selection when using a date range Scott Marlowe 21:03
Re: Curious index selection when using a date range Robert Gravsjö 21:16
Re: Curious index selection when using a date range Scott Marlowe 21:30
Re: Curious index selection when using a date range Tom Lane 21:53

Jan. 4, 2010

Thread Author Time
Re: Innotop for postgresl Baron Schwartz 00:04
Re: Innotop for postgresl Chris 00:08
Re: Innotop for postgresl Alvaro Herrera 02:51
Re: set-level update fails with unique constraint violation Jayadevan M 04:33
Re: Using autogenerated primary key in transaction John R Pierce 08:25
Re: SELECT does not find table created by itself Magnus Hagander 08:29
Re: Using autogenerated primary key in transaction A. Kretschmer 08:29
Re: stats collector process: WRDSK = WRDSK_CANCEL? Magnus Hagander 08:29
how do I disable automatic start on mac os x? Chris Withers 08:43
Insert Data Into Tables Linked by Foreign Key Yan Cheng Cheok 08:53
8.5 Alpha3 - broken downloadlink Thomas Kellerer 10:20
why non-greedy modifier for one atom changes greediness of other atoms? hubert depesz lubaczewski 10:30
Re: why non-greedy modifier for one atom changes greediness of other atoms? hubert depesz lubaczewski 10:49
Some issues about data type convert donniehan 11:04
Re: Insert Data Into Tables Linked by Foreign Key Alban Hertroys 11:57
Re: how do I disable automatic start on mac os x? Naoko Reeves 11:57
Re: Insert Data Into Tables Linked by Foreign Key A. Kretschmer 12:15
Re: 8.5 Alpha3 - broken downloadlink Dave Page 12:15
Re: set-level update fails with unique constraint violation Daniel Verite 12:40
Re: SELECT does not find table created by itself Albe Laurenz 12:41
Re: Migration of db Greg Sabino Mullane 12:48
Re: Insert Data Into Tables Linked by Foreign Key Yan Cheng Cheok 12:53
Re: Insert Data Into Tables Linked by Foreign Key Sam Mason 12:59
Re: Insert Data Into Tables Linked by Foreign Key Alban Hertroys 13:03
Re: Insert Data Into Tables Linked by Foreign Key A. Kretschmer 13:23
Re: Insert Data Into Tables Linked by Foreign Key Grzegorz Jaśkiewicz 13:38
Re: how do I disable automatic start on mac os x? Chris Withers 13:38
Re: how do I disable automatic start on mac os x? Dave Page 13:40
Re: how do I disable automatic start on mac os x? Chris Withers 13:42
Re: how do I disable automatic start on mac os x? Dave Page 13:43
Re: how do I disable automatic start on mac os x? Chris Withers 14:32
Re: how do I disable automatic start on mac os x? Sachin Srivastava 14:33
Re: how do I disable automatic start on mac os x? Dave Page 14:33
Re: how do I disable automatic start on mac os x? Chris Withers 14:37
Re: how do I disable automatic start on mac os x? Sachin Srivastava 14:38
Re: why non-greedy modifier for one atom changesgreediness of other atoms? Albe Laurenz 14:38
Re: how do I disable automatic start on mac os x? Chris Withers 14:45
Re: Some issues about data type convert Albe Laurenz 14:55
Re: Some issues about data type convert Sam Mason 15:10
converting tables to XML and back shulkae 15:46
Re: Save MySQL? HA Chris Browne 16:23
Re: Save MySQL? HA Alvaro Herrera 16:58
Re: Save MySQL? HA Bill Moran 17:36
Re: Save MySQL? HA Joshua D. Drake 17:38
Re: Save MySQL? HA Mark Williamson 17:41
Re: Some issues about data type convert Tom Lane 17:45
Re: how do I disable automatic start on mac os x? John DeSoi 18:28
Upgraded from Leopard to Snow Leopard - PostgreSQL won't start anymore Matthias Dietrich 21:17
Upgraded from Leopard to Snow Leopard - PostgreSQL won't start anymore Matthias Dietrich 21:35
Re: Innotop for postgresl Erik Jones 21:59
Re: Upgraded from Leopard to Snow Leopard - PostgreSQL won't start anymore Greg Smith 22:02
Question on how to conditionally commit or rollback a sql-request Bergbom Staffan 22:14
ERROR in createlang / ERROR en createlang erobles 22:51
ERROR in createlang erobles 22:55

Jan. 5, 2010

Thread Author Time
Re: Question on how to conditionally commit or rollback a sql-request Daniel Verite 00:34
Shall I use PostgreSQL Array Type in The Following Case Yan Cheng Cheok 01:12
Re: Some issues about data type convert donniehan 01:57
timestams in the the pg_standby output Tim Uckun 02:20
Re: Insert Data Into Tables Linked by Foreign Key Yan Cheng Cheok 03:26
Re: ERROR in createlang Adrian Klaver 03:31
PostgreSQL Write Performance Yan Cheng Cheok 03:36
Re: PostgreSQL Write Performance Scott Marlowe 03:45
Re: ERROR in createlang Tom Lane 04:23
Re: PostgreSQL Write Performance Yan Cheng Cheok 05:04
Re: timestams in the the pg_standby output Fujii Masao 05:17
Re: PostgreSQL Write Performance Greg Smith 05:56
Re: PostgreSQL Write Performance Dann Corbit 06:03
Re: timestams in the the pg_standby output Greg Smith 06:13
Re: timestams in the the pg_standby output Tim Uckun 07:22
Re: PostgreSQL Write Performance Yan Cheng Cheok 07:30
Re: PostgreSQL Write Performance Dann Corbit 07:34
Re: timestams in the the pg_standby output Greg Smith 07:37
Large tables, ORDER BY and sequence/index scans Milan Zamazal 09:19
Re: PostgreSQL Write Performance Alban Hertroys 11:04
Re: Insert Data Into Tables Linked by Foreign Key Alban Hertroys 11:19
Re: PostgreSQL Write Performance Craig Ringer 11:20
Re: Large tables, ORDER BY and sequence/index scans Filip Rembiałkowski 12:02
Re: Large tables, ORDER BY and sequence/index scans Pavel Stehule 12:12
Re: Large tables, ORDER BY and sequence/index scans Milan Zamazal 13:24
Re: Large tables, ORDER BY and sequence/index scans Milan Zamazal 13:31
Re: Large tables, ORDER BY and sequence/index scans Albe Laurenz 13:35
Re: Large tables, ORDER BY and sequence/index scans Grzegorz Jaśkiewicz 13:38
Re: Large tables, ORDER BY and sequence/index scans Pavel Stehule 13:45
access computed field of RECORD variable 📎 Steve White 13:53
Re: converting tables to XML and back Dimitri Fontaine 13:56
Re: converting tables to XML and back Sam Mason 14:06
Re: Looking for advice on working with revisions Alvaro Herrera 14:08
Re: access computed field of RECORD variable Alvaro Herrera 14:13
Re: Shall I use PostgreSQL Array Type in The Following Case Sam Mason 14:24
zic error to install 8.4.0 erobles 14:35
Re: Shall I use PostgreSQL Array Type in The Following Case Grzegorz Jaśkiewicz 14:37
Re: zic error to install 8.4.0 Grzegorz Jaśkiewicz 14:38
Re: set-level update fails with unique constraint violation Dean Rasheed 14:47
Re: Some issues about data type convert Sam Mason 14:51
Re: access computed field of RECORD variable Merlin Moncure 14:53
Re: Shall I use PostgreSQL Array Type in The Following Case Gauthier, Dave 15:00
Re: Large tables, ORDER BY and sequence/index scans Milan Zamazal 15:08
Re: Large tables, ORDER BY and sequence/index scans Milan Zamazal 15:14
Re: Large tables, ORDER BY and sequence/index scans Milan Zamazal 15:18
unsubscribe Nicola Farina 15:20
Re: access computed field of RECORD variable Steve White 15:22
Using regex to update a table howardnews@selestial.com 15:24
optimisations to aggregates Sam Mason 15:26
Re: FM format modifier does not remove leading zero from year Adrian Klaver 15:27
Using table name in column for joining Antonio Goméz Soto 15:30
Re: zic error to install 8.4.0 Tom Lane 15:34
8.4.1 & 8.4.2 require map=... for ident in the pg_hba.conf file, will this be the new way? Claudio Eichenberger 15:35
Re: Using table name in column for joining Grzegorz Jaśkiewicz 15:38
Re: Large tables, ORDER BY and sequence/index scans Pavel Stehule 15:43
Re: Large tables, ORDER BY and sequence/index scans Milan Zamazal 15:53
Re: FM format modifier does not remove leading zero from year Tom Lane 15:54
Re: Large tables, ORDER BY and sequence/index scans Pavel Stehule 16:03
Re: Using regex to update a table Howard Cole 16:16
Re: Large tables, ORDER BY and sequence/index scans Milan Zamazal 16:20
Re: converting tables to XML and back Scott Bailey 16:44
Re: how do I disable automatic start on mac os x? Scott Ribe 16:49
Re: Using table name in column for joining sabrina miller 17:00
reason for default PGSTAT_ACTIVITY_SIZE frank joerdens 17:02
Re: Large tables, ORDER BY and sequence/index scans John R Pierce 17:16
pl/perl not rethrowing pl/pgsql exceptions Merlin Moncure 17:49
Re: reason for default PGSTAT_ACTIVITY_SIZE Guillaume Lelarge 18:24
Re: pl/perl not rethrowing pl/pgsql exceptions Merlin Moncure 18:48
Re: reason for default PGSTAT_ACTIVITY_SIZE Frank Joerdens 19:36
Re: set-level update fails with unique constraint violation Roman Neuhauser 19:52
Re: Using table name in column for joining Antonio Goméz Soto 19:56
Re: reason for default PGSTAT_ACTIVITY_SIZE Guillaume Lelarge 20:00
Re: Large tables, ORDER BY and sequence/index scans Milan Zamazal 20:05
Re: timestams in the the pg_standby output Tim Uckun 22:14
Re: PostgreSQL Write Performance Tim Uckun 22:21
Re: timestams in the the pg_standby output Greg Smith 22:30
using a function Andy Colson 22:31
Re: PostgreSQL Write Performance Greg Smith 22:34
using a function Andy Colson 22:39
Re: PostgreSQL Write Performance Andres Freund 22:49
pgbench out of memory error Jeff Ross 22:49
Re: PostgreSQL Write Performance Craig Ringer 23:33
Re: PostgreSQL Write Performance Tim Uckun 23:46
Re: pgbench out of memory error Greg Smith 23:54
Re: PostgreSQL Write Performance Christophe Pettus 23:55

Jan. 6, 2010

Thread Author Time
XML Type validates against xml schema? Andrew Lardinois 00:06
Re: PostgreSQL Write Performance Craig Ringer 01:15
Re: conditional rule not applied Seb 02:20
Re: PostgreSQL Write Performance Tim Uckun 02:30
Re: PostgreSQL Write Performance Craig Ringer 02:56

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