pgsql-general since 2009-09-18 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

Sept. 18, 2009

Thread Author Time
Re: NAS Scott Marlowe 01:28
Re: haversine formula with postgreSQL Jonathan Harahush 02:37
Re: haversine formula with postgreSQL Scott Marlowe 03:35
PostgreSQL nonstandard use of escape in a string literal Johnson, Trevor 04:05
Re: PostgreSQL nonstandard use of escape in a string literal Jeff Davis 04:11
Re: PostgreSQL nonstandard use of escape in a string literal Peter Eisentraut 04:24
Re: Substitutes for some Oracle packages Albe Laurenz 07:04
Re[3]: Problems with pg_dump for PG8.4 for WinXP (MinGW build) el dorado 11:17
Build PG 8 el dorado 11:24
Re: Build PG 8 el dorado 11:39
Build PG 8.4 (MinGW vs. MSVC) el dorado 11:41
Re: Build PG 8.4 (MinGW vs. MSVC) Magnus Hagander 13:05
Re: Does PG cache results of an aggregate function, (and results of non-volatile functions)? Merlin Moncure 13:08
gap in sequence numbers Picavet Vincent 14:00
Re: Does PG cache results of an aggregate function, (and results of non-volatile functions)? Tom Lane 14:16
Re: pgadmin is changing pgpass.conf Howard Cole 15:07
Re: gap in sequence numbers Merlin Moncure 15:23
Re: pgadmin is changing pgpass.conf Raymond O'Donnell 15:28
concatenation issue ( 8.4 ) Jonathan Vanasco 15:52
Re: pgadmin is changing pgpass.conf Richard Huxton 15:56
Re: concatenation issue ( 8.4 ) Raymond O'Donnell 16:25
Repetitive fields ekekakos 16:44
Re: concatenation issue ( 8.4 ) Alban Hertroys 17:51
Re: NAS Merlin Moncure 19:16
Re: Repetitive fields Scott Bailey 20:25
Re: NAS Greg Smith 20:39
Re: haversine formula with postgreSQL Greg Smith 20:51
Return 30% of results? Nick 21:31
Re: haversine formula with postgreSQL Scott Bailey 21:50
Re: PostgreSQL on Windows Server 2003 for Moodle vikram 22:21
Re: Return 30% of results? Thomas Kellerer 22:40
MD5 sum mismatch in source rpm Clodoaldo Neto 22:42
Re: MD5 sum mismatch in source rpm Devrim GÜNDÜZ 22:57
Re: Return 30% of results? Martin Gainty 23:54
Re: Return 30% of results? David Fetter 23:58

Sept. 19, 2009

Thread Author Time
Re: MD5 sum mismatch in source rpm Clodoaldo Neto 01:38
Re: Return 30% of results? nick 07:27
Re: Regarding initdb & pg_ctl chris_watcher 08:44
Re: Does PG cache results of an aggregate function, (and results of non-volatile functions)? 纪晓曦 13:06
Re: haversine formula with postgreSQL Merlin Moncure 15:00
Re: Return 30% of results? David Fetter 15:05
Open Positions in Ph.D. Studies in Open Source at the University of Erlangen, Germany Dirk Riehle 15:10
The best agile methods and open source books Dirk Riehle 15:10
Re: Return 30% of results? Merlin Moncure 15:10
Re: Regarding initdb & pg_ctl Inigo Barandiaran 15:20
SIGSEGV when trying to start in single user mode Björn Häuser 15:24
Re: haversine formula with postgreSQL Rob Wultsch 15:33
Re: haversine formula with postgreSQL Tom Lane 16:19
Re: SIGSEGV when trying to start in single user mode Tom Lane 17:04
Re: SIGSEGV when trying to start in single user mode Björn Häuser 18:41

Sept. 20, 2009

Thread Author Time
How can I make a two arch libpq for snow leopard? Jerry LeVan 02:39
Re: Idle processes chewing up CPU? Brendan Hill 10:37
Re: Idle processes chewing up CPU? Tom Lane 19:24
Re: MD5 sum mismatch in source rpm Devrim GÜNDÜZ 21:24
How to get variable out to shell script Alex Gadea 21:49
Re: How to get variable out to shell script Scott Marlowe 22:10
Re: How to get variable out to shell script Devrim GÜNDÜZ 22:10
Re: How to get variable out to shell script Sam Mason 22:21
Re: How to get variable out to shell script Alex Gadea 22:42
Re: How to get variable out to shell script Scott Marlowe 23:23
Re: How to get variable out to shell script Brent Wood 23:41
Re: How can I make a two arch libpq for snow leopard? Scott Ribe 23:47
Re: How to get variable out to shell script Abel Camarillo 23:49

Sept. 21, 2009

Thread Author Time
Re: How can I make a two arch libpq for snow leopard? Jerry LeVan 01:41
Re: Substitutes for some Oracle packages abhishekgautam009 02:19
Re[2]: Build PG 8.4 (MinGW vs. MSVC) el dorado 07:57
Storage of Foreign Keys Christian Koetschan 12:04
Re: anyone have experience with using Talend ETL tool Tguru 13:26
Re: Storage of Foreign Keys Alan Hodgson 17:09
VMWare file system / database corruption Tom Duffey 17:09
Re: VMWare file system / database corruption Scott Marlowe 17:40
Re: Storage of Foreign Keys Scott Marlowe 17:44
Re: VMWare file system / database corruption Vick Khera 17:53
Re: VMWare file system / database corruption Scott Marlowe 18:01
Re: VMWare file system / database corruption Alex Gadea 18:10
Re: VMWare file system / database corruption Tom Duffey 18:46
Re: VMWare file system / database corruption Scott Marlowe 19:04
Insert unique fails, still increments ID in a lookup table Mark Felegyhazi 19:33
DDL with Reference on them. Michael Gould 19:56
Re: VMWare file system / database corruption Scot Kreienkamp 20:03
Re: DDL with Reference on them. Alvaro Herrera 20:12
Re: Benetl, a free ETL tool for files using postgreSQL, is out in version 3.0 Benoît Carpentier 20:15
Re: VMWare file system / database corruption John R Pierce 20:23
Re: VMWare file system / database corruption Scot Kreienkamp 21:26
Re: Insert unique fails, still increments ID in a lookup table Scott Ribe 22:03
Re: 8.4 installer Christine Penner 22:13

Sept. 22, 2009

Thread Author Time
Re: 8.4 installer David Spadea 00:27
Re: Insert unique fails, still increments ID in a lookup table Chris 07:27
How to have ant's <sql> task insert special chars appropriately? agostonbejo 10:10
citext like query and index usage Tore Halvorsen 10:11
PLJava not installed for PostgreSQL 8.4 on Solaris 10 x86 64 Arnold, Sandra 13:10
Re: VMWare file system / database corruption Merlin Moncure 13:40
Re: VMWare file system / database corruption Bill Moran 13:51
Re: citext like query and index usage Emanuel Calvo Franco 17:23
Re: Storage of Foreign Keys Lew 17:32
Resources for learning PostgreSQL dan06 17:43
Re: Resources for learning PostgreSQL Paul M Foster 18:20
Re: citext like query and index usage Alvaro Herrera 18:49
Re: PLJava not installed for PostgreSQL 8.4 on Solaris 10 x86 64 Joshua D. Drake 18:52
Re: citext like query and index usage Tore Halvorsen 18:58
Logging statements longer than 1000ms doesn't appear to work Chris Barnes 18:58
Re: citext like query and index usage Tom Lane 19:06
Re: Logging statements longer than 1000ms doesn't appear to work Tom Lane 19:08
Re: Logging statements longer than 1000ms doesn't appear to work Chris Barnes 19:18
Re: PLJava not installed for PostgreSQL 8.4 on Solaris 10 x86 64 John R Pierce 20:35
Re: PLJava not installed for PostgreSQL 8.4 on Solaris 10 x86 64 Joshua D. Drake 20:40
Re: Graphical representation of query plans Emi Lu 20:48
Re: Graphical representation of query plans Raymond O'Donnell 21:20
Re: Logging statements longer than 1000ms doesn't appear to work Chris Barnes 21:43
Re: Logging statements longer than 1000ms doesn't appear to work Gurjeet Singh 21:55
Re: VMWare file system / database corruption Greg Smith 22:50
Re: Logging statements longer than 1000ms doesn't appear to work Scott Marlowe 23:26

Sept. 23, 2009

Thread Author Time
Help! Database restored with disabled triggers Joe Kramer 02:28
Re: Resources for learning PostgreSQL Scott Bailey 02:52
Re: Graphical representation of query plans Guillaume Lelarge 06:48
PL/PG SQL: select count(*) into <var> from <tab> where <cond> - does not compute the where cond Abraham, Danny 07:39
Re: PL/PG SQL: select count(*) into <var> from <tab> where <cond> - does not compute the where cond Pavel Stehule 08:13
Re: PL/PG SQL: select count(*) into <var> from <tab> where <cond> - does not compute the where cond A. Kretschmer 08:15
Re: PL/PG SQL: select count(*) into <var> from <tab> where <cond> - does not compute the where cond Pavel Stehule 08:18
Re: PL/PG SQL: select count(*) into <var> from <tab> where <cond> - does not compute the where cond Abraham, Danny 08:33
Re: How to have ant's <sql> task insert special chars appropriately? Richard Huxton 09:29
Re: How to have ant's <sql> task insert special chars appropriately? J. Roeleveld 09:35
Re: PL/PG SQL: select count(*) into <var> from <ANY VIEW> where <cond> - does not compute the where cond - returns always total count Abraham, Danny 10:04
Re: How to have ant's <sql> task insert special chars appropriately? Richard Huxton 10:22
Where can I find detail information about constraint ? 纪晓曦 10:23
Re: Re: PL/PG SQL: select count(*) into <var> from <ANY VIEW> where <cond> - does not compute the where cond - returns always total count A. Kretschmer 10:25
Re: Where can I find detail information about constraint ? Raymond O'Donnell 10:28
multiple calls to dblink_connect from within pl/pgSQL function exhaust connection limit Peter Geoghegan 11:11
Re: Re: PL/PG SQL: select count(*) into <var> from <ANY VIEW> where <cond> - does not compute the where cond - returns always total count Martin Gainty 11:26
Advance SQL subquery AnthonyV 12:13
Re: Graphical representation of query plans Emi Lu 13:34
Re: Where can I find detail information about constraint ? Albe Laurenz 13:35
Re: How to have ant's <sql> task insert special chars appropriately? Tom Lane 13:58
Re: Help! Database restored with disabled triggers Adrian Klaver 14:02
Re: Help! Database restored with disabled triggers Tom Lane 14:53
Re: Help! Database restored with disabled triggers Joe Kramer 15:12
Re: Help! Database restored with disabled triggers Joe Kramer 15:14
[No subject] Ms swati chande 15:21
Re: Help! Database restored with disabled triggers Tom Lane 15:24
Re: Advance SQL subquery Merlin Moncure 15:32
Re: Help! Database restored with disabled triggers Tom Lane 15:33
Re: Advance SQL subquery AnthonyV 15:37
Re: Tom Lane 16:07
Re: Help! Database restored with disabled triggers Joe Kramer 16:12
Source for CreatedSharedMemoryAndSemaphores Martin Gainty 16:12
Re: Help! Database restored with disabled triggers Adrian Klaver 16:19
Re: Source for CreatedSharedMemoryAndSemaphores Tom Lane 16:33
Re: Advance SQL subquery David Fetter 16:40
Re: Help! Database restored with disabled triggers Scott Marlowe 17:05
Looking for way to replicate master db to multiple mobile databases Bryan Montgomery 17:11
Re: Source for CreatedSharedMemoryAndSemaphores Martin Gainty 17:23
Re: Source for CreatedSharedMemoryAndSemaphores Tom Lane 17:31
Re: multiple calls to dblink_connect from within pl/pgSQL function exhaust connection limit Tom Lane 17:52
Re: pgadmin is changing pgpass.conf Howard Cole 18:08
Re: Source for CreatedSharedMemoryAndSemaphores Martin Gainty 18:15
Re: multiple calls to dblink_connect from within pl/pgSQL function exhaust connection limit Peter Geoghegan 18:27
grants on pg_stats_activity JC Praud 19:28
More straight forward method to convert seconds::bigint to interval Shane R. Spencer 20:31
Re: More straight forward method to convert seconds::bigint to interval Tom Lane 20:41
Re: More straight forward method to convert seconds::bigint to interval Adam Rich 20:48
Re: Looking for way to replicate master db to multiple mobile databases Scott Marlowe 20:58
Possible Bug - error creating a tablespace Kevin Kempter 21:14
Re: Possible Bug - error creating a tablespace Tom Lane 21:30
Re: More straight forward method to convert seconds::bigint to interval Shane Spencer 21:41
Re: How to get variable out to shell script Greg Smith 21:54
Re: Looking for way to replicate master db to multiple mobile databases Bryan Montgomery 22:00
lazy vacuum and AccessExclusiveLock Jaromír Talíř 22:04
Log File Melancholy Jerry LeVan 22:57
Re: Log File Melancholy Tom Lane 23:46

Sept. 24, 2009

Thread Author Time
Re: Possible Bug - error creating a tablespace Gabriel Ramirez 02:54
Re: Idle processes chewing up CPU? Brendan Hill 03:47
pg_toast record in table pg_class Mihail Nasedkin 05:45
pg_toast record in table pg_class Mihail Nasedkin 08:52
Re: Looking for way to replicate master db to multiple mobile databases Sam Mason 11:04
Understanding 'could not read block' stevesub 12:14
Re: Looking for way to replicate master db to multiple mobile databases Alexey Klyukin 12:55
SqlDataSource and npsql Keller, Oliver 13:12
primary key and foreign keys Grzegorz Jaśkiewicz 13:47
Re: Understanding 'could not read block' Grzegorz Jaśkiewicz 13:58
Intermediate values and unprivileged users Mark Morgan Lloyd 14:04
What is the difference of foreign key? 纪晓曦 14:18
Re: Intermediate values and unprivileged users Grzegorz Jaśkiewicz 14:18
What is the difference of foreign key? sheepjxx 14:19
Re: What is the difference of foreign key? serge.fonville 14:26
repeatedly process termination in PG 8.2 Michael Molz 14:31
Re: Ms swati chande 14:33
Re: Looking for way to replicate master db to multiple mobile databases Selena Deckelmann 14:37
Re: Understanding 'could not read block' Tom Lane 14:38
What is the difference of these two kinds of foreign key defination? sheepjxx 14:48
Re: Looking for way to replicate master db to multiple mobile databases Cédric Villemain 15:09
Re: Looking for way to replicate master db to multiple mobile databases Joshua Tolley 15:27
Re: How to have ant's <sql> task insert special chars appropriately? agostonbejo 15:35
Exception 0xC0000005 Ms swati chande 16:22
Re: Exception 0xC0000005 mmoncure 16:28
generic modelling of data models; enforcing constraints dynamically... InterRob 16:28
Re: Exception 0xC0000005 Grzegorz Jaśkiewicz 16:28
Re: Exception 0xC0000005 Ms swati chande 16:34
Re: Exception 0xC0000005 Grzegorz Jaśkiewicz 16:45
Re: generic modelling of data models; enforcing constraints dynamically... Ben Chobot 16:52
Re: generic modelling of data models; enforcing constraints dynamically... Sam Mason 16:52

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