[go: up one dir, main page]

pgsql-general since 2008-09-03 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. 3, 2008

Thread Author Time
Re: Foreign Key normalization question Matthew Wilson 00:02
Re: Subqueries in Check() -- Still Intentionally Omitted? Richard Broersma 00:07
Re: Subqueries in Check() -- Still Intentionally Omitted? Tom Lane 00:26
vacuum analyze hurts performance aderose 00:37
Re: vacuum analyze hurts performance aderose 00:38
Re: Index non-usage problem in 8.2.9 Joseph S 02:40
Re: Oracle and Postgresql Robert Treat 02:56
Re: Oracle and Postgresql Ow Mun Heng 03:06
Re: Index non-usage problem in 8.2.9 Tom Lane 03:38
Re: Index non-usage problem in 8.2.9 Joseph S 03:51
Re: Index non-usage problem in 8.2.9 Tom Lane 03:59
Re: Oracle and Postgresql Artacus 04:09
Re: Index non-usage problem in 8.2.9 Joseph S 04:10
Re: Index non-usage problem in 8.2.9 Tom Lane 04:31
Re: plpgsql returning resultset Thomas Finneid 09:42
Postgresql optimisator deoptimise queries sometime... Maxim Boguk 11:19
Re: Oracle and Postgresql Asko Oja 13:17
Re: immutable functions and enumerate type casts in indexes Edoardo Panfili 13:42
Re: immutable functions and enumerate type casts in indexes Tom Lane 14:53
Re: vacuum analyze hurts performance Tom Lane 15:17
Re: immutable functions and enumerate type casts in indexes Edoardo Panfili 15:23
Re: Oracle and Postgresql SCassidy 15:36
Case sensitive full text searching Fco. Mario Barcala Rodríguez 16:21
hash partitioning David West 16:24
Re: Oracle and Postgresql Scott Marlowe 16:53
Re: hash partitioning Scott Marlowe 16:57
Re: Backslash Escape Sequences Alvaro Herrera 16:59
Re: Case sensitive full text searching Oleg Bartunov 17:10
Simple query not using index: why? William Garrison 17:17
Re: hash partitioning Tom Lane 17:21
Re: hash partitioning William Garrison 17:36
Re: Simple query not using index: why? Adrian Klaver 17:47
Testers: 8.4 snapshot RPMs are available Devrim GÜNDÜZ 18:31
offtopic, about subject prefix Fernando Moreno 18:33
Re: offtopic, about subject prefix brian 18:36
Postgres does not start, gives no error Akhtar Yasmin-B05532 19:11
Re: hash partitioning Ian Harding 19:14
Re: SELECT INTO returns incorrect values Tony Caduto 19:54
Re: Simple query not using index: why? William Garrison 19:55
Re: Simple query not using index: why? Joshua Drake 20:01
Re: Oracle and Postgresql Tony Caduto 20:07
Re: Conflict between MVCC and manual locking Erik Jones 20:21
Re: Oracle and Postgresql Scott Marlowe 20:21
Problem with trigger function Mira Dimitrijevic 21:12
Re: Postgres does not start, gives no error Raymond O'Donnell 21:53
Re: Postgres does not start, gives no error Akhtar Yasmin-B05532 21:58
Re: Problem with trigger function Stephan Szabo 21:59
Re: Postgres does not start, gives no error Joshua Drake 22:12
Re: Postgres does not start, gives no error Akhtar Yasmin-B05532 22:19
Re: Postgres does not start, gives no error Joshua Drake 22:25
Re: Postgres does not start, gives no error Akhtar Yasmin-B05532 22:34
Re: Postgres does not start, gives no error Joshua Drake 22:44
Re: Postgres does not start, gives no error Akhtar Yasmin-B05532 22:47
Compiling C Trigger function pw 23:02
Re: Postgres does not start, gives no error Tom Lane 23:13
Re: Postgres does not start, gives no error Akhtar Yasmin-B05532 23:22
Re: Postgres does not start, gives no error Tom Lane 23:33

Sept. 4, 2008

Thread Author Time
Re: Oracle and Postgresql Artacus 02:21
a performence question Rafal Pietrak 06:30
Getting affected rows in pgplsql Artacus 09:07
Re: Getting affected rows in pgplsql Blazej 11:08
Re: Getting affected rows in pgplsql hubert depesz lubaczewski 11:08
Re: Oracle and Postgresql Roberts, Jon 12:30
Changes for version 8.4 paul tilles 12:42
xml2 vs XMLFunctions Tobias Anstett 13:15
xpath_bool_ns() and xml2 Tobias Anstett 13:21
Re: Changes for version 8.4 Alvaro Herrera 14:09
Re: Changes for version 8.4 Joao Ferreira gmail 14:41
Re: Changes for version 8.4 Alvaro Herrera 14:45
You need to rebuild PostgreSQL using --with-libxml. Ricardo Antonio Yepez Jimenez 14:48
Re: You need to rebuild PostgreSQL using --with-libxml. Devrim GÜNDÜZ 16:04
Re: Changes for version 8.4 Devrim GÜNDÜZ 16:06
Re: Oracle and Postgresql Lars Haugseth 17:57
Re: Postgres does not start, gives no error Lennin Caro 18:30
Re: Postgres does not start, gives no error Lennin Caro 18:32
Re: Postgres does not start, gives no error Akhtar Yasmin-B05532 18:34
Re: Postgres does not start, gives no error Akhtar Yasmin-B05532 18:53
How to test something using ROLLBACK TRANSACTION William Garrison 19:17
Re: How to test something using ROLLBACK TRANSACTION Scott Marlowe 19:28
Re: How to test something using ROLLBACK TRANSACTION Richard Broersma 20:43
Full outer join? Cross product? How to blend two queries into single row? D. Dante Lorenso 20:43
Re: Postgres does not start, gives no error Scott Marlowe 21:00
Re: Full outer join? Cross product? How to blend two queries into single row? Sam Mason 21:22
Re: Full outer join? Cross product? How to blend two queries into single row? Scott Marlowe 21:26
Re: Full outer join? Cross product? How to blend two queries into single row? Richard Broersma 21:28
Java class to manage a hstore? ries van Twisk 21:44
Re: Full outer join? Cross product? How to blend two queries into single row? Sam Mason 21:54
Re: Full outer join? Cross product? How to blend two queries into single row? Richard Broersma 21:58
Re: Full outer join? Cross product? How to blend two queries into single row? Sam Mason 22:06
Re: Postgres does not start, gives no error Christophe 22:32

Sept. 5, 2008

Thread Author Time
Large Selects and cursors.. Ow Mun Heng 01:22
Re: offtopic, about subject prefix Fernando Moreno 01:30
Re: Postgres does not start, gives no error Adrian Klaver 01:50
Re: Oracle and Postgresql Robert Treat 02:40
postgres silent install bug? Mike Gagnon 02:48
Re: Oracle and Postgresql Artacus 03:37
Re: Oracle and Postgresql Artacus 03:47
Re: Getting affected rows in pgplsql Artacus 03:52
Re: Postgres does not start, gives no error Akhtar Yasmin-B05532 04:13
Re: You need to rebuild PostgreSQL using --with-libxml. Devrim GÜNDÜZ 04:15
Seeking for vacuum advise Yogesh Sharma 04:59
Cannot connect to server Paul Shapley 06:45
Prepared statements aren't working with parameters with PQexecParams Subspace god 06:52
Range Partititioning & Constraint Exclusion Oddities Ow Mun Heng 07:07
Re: Postgresql optimisator deoptimise queries sometime... Maxim Boguk 07:13
Re: Prepared statements aren't working with parameters with PQexecParams David Wilson 07:19
max_stack_depth Exceeded Ow Mun Heng 08:03
Re: max_stack_depth Exceeded Magnus Hagander 08:35
Re: max_stack_depth Exceeded Ow Mun Heng 08:58
xml queries & date format Jef Peeraer 09:39
Re: Cannot connect to server Filip Rembiałkowski 09:44
Re: max_stack_depth Exceeded Magnus Hagander 11:10
Re: Cannot connect to server Reid Thompson 11:48
large inserts and fsync Aaron Burnett 13:16
Re: a performence question Filip Rembiałkowski 15:04
Re: large inserts and fsync Sam Mason 15:10
Re: large inserts and fsync Aaron Burnett 15:19
Re: max_stack_depth Exceeded Tom Lane 15:22
Re: xml queries & date format Tom Lane 15:25
Re: large inserts and fsync Sam Mason 15:32
Re: large inserts and fsync Alan Hodgson 15:39
Re: large inserts and fsync Tom Lane 15:47
Error Installing Postgre 8.3 Silent Mod Anderson dos Santos Donda 19:52

Sept. 6, 2008

Thread Author Time
Re: max_stack_depth Exceeded Ow Mun Heng 00:13
Re: log_statement not working on pl/pgsql functions Bruce Momjian 02:25
Re: Oracle and Postgresql Greg Smith 07:49
recover in single-user backend fails Wouter Sergeyssels 08:01
Re: large inserts and fsync Greg Smith 08:45
Re: large inserts and fsync Aaron Burnett 12:37
Efficient processing of staging data Joris Dobbelsteen 16:01
PostgreSQL SSL problem Andriy Bakay 16:33
storing repeating dates / events rkmr.em@gmail.com 17:12
Re: storing repeating dates / events brian 17:21
Re: storing repeating dates / events Jorge Godoy 17:32
Re: storing repeating dates / events rkmr.em@gmail.com 17:33
Re: storing repeating dates / events rkmr.em@gmail.com 17:34
Re: Can I truncate statements in the log? Bruce Momjian 17:38
Re: storing repeating dates / events Jorge Godoy 18:25
Re: Subqueries in Check() -- Still Intentionally Omitted? Bruce Momjian 19:30
Re: recover in single-user backend fails Tom Lane 20:54
64-bit Compile Failure on Solaris 10 with OpenSSL Randal T. Rioux 22:39
Re: 64-bit Compile Failure on Solaris 10 with OpenSSL Tom Lane 23:05
Re: 64-bit Compile Failure on Solaris 10 with OpenSSL Randal T. Rioux 23:20

Sept. 7, 2008

Thread Author Time
Re: 64-bit Compile Failure on Solaris 10 with OpenSSL Tom Lane 00:21
Re: storing repeating dates / events Taras Kopets 00:39
Re: 64-bit Compile Failure on Solaris 10 with OpenSSL Randal T. Rioux 03:59
Re: 64-bit Compile Failure on Solaris 10 with OpenSSL Tom Lane 04:47
Re: recover in single-user backend fails Gregory Stark 09:50
A challenge for the SQL gurus out there... Uwe C. Schroeder 09:53
Re: A challenge for the SQL gurus out there... Gregory Stark 10:09
New shapshot RPMs (Sep 7 2008) are ready for testing Devrim GÜNDÜZ 12:00
Re: a performence question Rafal Pietrak 12:46
Re: A challenge for the SQL gurus out there... Harald Fuchs 13:35
Re: [HACKERS] New shapshot RPMs (Sep 7 2008) are ready for testing Andrew Dunstan 15:01
Re: [HACKERS] New shapshot RPMs (Sep 7 2008) are ready for testing Devrim GÜNDÜZ 15:09
Re: [HACKERS] New shapshot RPMs (Sep 7 2008) are ready for testing Joshua D. Drake 16:18
Re: [HACKERS] New shapshot RPMs (Sep 7 2008) are ready for testing Tom Lane 16:19
Re: [HACKERS] New shapshot RPMs (Sep 7 2008) are ready for testing Andrew Dunstan 17:39
Re: A challenge for the SQL gurus out there... Uwe C. Schroeder 19:31
secure connections c k 20:32
PostgreSQL 📎 Mickey Shekdar 20:52
Re: Efficient processing of staging data Asko Oja 23:18

Sept. 8, 2008

Thread Author Time
Re: [GENERAL] secure connections Filip Rembiałkowski 00:27
psql scripting tutorials Artacus 01:35
Re: 64-bit Compile Failure on Solaris 10 with OpenSSL Randal T. Rioux 02:49
weekday from timestamp? ..::rDk::.. 03:08
Very weird problem of "order by" in postgresql Peter Cai 03:51
varchar vs Text & TOAST Ow Mun Heng 03:58
Re: 64-bit Compile Failure on Solaris 10 with OpenSSL Tom Lane 04:06
Re: Very weird problem of "order by" in postgresql Justin Graf 04:39
Re: varchar vs Text & TOAST Craig Ringer 04:50
8.3 on FreeBSD 6.3, sudden performance degradations Ivan Zolotukhin 09:46
Re: recover in single-user backend fails Wouter Sergeyssels 10:34
Re: Very weird problem of "order by" in postgresql Peter Cai 10:38
Re: Very weird problem of "order by" in postgresql Peter Cai 10:44
Re: [HACKERS] New shapshot RPMs (Sep 7 2008) are ready for testing Devrim GÜNDÜZ 11:28
Re: Very weird problem of "order by" in postgresql Tom Lane 12:34
ERROR: cache lookup failed for relation joe speigle 12:54
Possible limit on transaction size? bbeyer 13:17
Re: 64-bit Compile Failure on Solaris 10 with OpenSSL Randal T. Rioux 13:38
Postgres 8.3.1 RowExclusiveLock With JDBC XA Urciolo, Kevin 15:20
Re: [GENERAL] secure connections Alejandro D. Burne 16:04
Getting rows in a very specific order Gordon 16:29
Re: recover in single-user backend fails Scott Marlowe 16:36
Suspected bug: outer WHERE reordered before inner WHERE -> input syntax ERROR John Keith Hohm 17:05
Re: Suspected bug: outer WHERE reordered before inner WHERE -> input syntax ERROR Alvaro Herrera 17:09
Automated Backup On Windows justin 17:32
How to check what is current postgres version Markova, Nina 17:40
Re: Suspected bug: outer WHERE reordered before inner WHERE -> input syntax ERROR Tom Lane 17:53
Re: How to check what is current postgres version justin 17:53
Re: How to check what is current postgres version Markova, Nina 17:55
Re: How to check what is current postgres version Scott Marlowe 17:57
Postgres in a solaris zone - patch 125077-02 needed Markova, Nina 18:03
Re: Suspected bug: outer WHERE reordered before inner WHERE -> input syntax ERROR Sam Mason 18:34
Re: Suspected bug: outer WHERE reordered before inner WHERE -> input syntax ERROR John Keith Hohm 18:36
Postgres 8.3.1 RowExclusiveLock With JDBC XA Urciolo, Kevin 19:16
Re: Suspected bug: outer WHERE reordered before inner WHERE -> input syntax ERROR Tom Lane 19:46
Re: Suspected bug: outer WHERE reordered before inner WHERE -> input syntax ERROR Tom Lane 19:48
Install Postgres on a SAN volume? William Garrison 22:18
Re: Install Postgres on a SAN volume? Greg Smith 22:42

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