pgsql-general - October 2007

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

Oct. 1, 2007

Thread Author Time
using COPY, .CSV and ¿catalog? pere roca ristol 07:53
COPY for .CSV files problem pere roca 08:20
Re: more problems with count(*) on large table Alban Hertroys 08:26
Re: more problems with count(*) on large table Alban Hertroys 08:37
Re: 3 tables join update Alban Hertroys 08:53
Partitioned table limitation Goboxe 09:17
Re: COPY for .CSV files problem Jorge Godoy 09:35
ERROR: invalid byte sequence from psql - Works perfectly from pgAdmin III query window Anoo Sivadasan Pillai 10:02
Re: more problems with count(*) on large table Gregory Stark 10:04
Re: more problems with count(*) on large table Albe Laurenz 10:05
Re: ERROR: invalid byte sequence from psql - Works perfectly from pgAdmin III query window Richard Huxton 10:12
Re: windows and pg 8.2 (change database to another server) Magnus Hagander 10:32
Query problem Naz Gassiep 10:56
Re: It's time to support GRANT SELECT, UPDATE, ..., ..., ... ON database.* to username Ben Trewern 11:28
Re: ERROR: invalid byte sequence from psql - Works perfectly from pgAdmin III query window Albe Laurenz 11:43
Re: Query problem Albe Laurenz 12:02
Re: ERROR: invalid byte sequence from psql - Works perfectly from pgAdmin III query window Nis Jørgensen 12:07
Re: usage of indexes for inner joins Ben Trewern 12:41
Re: more problems with count(*) on large table Alban Hertroys 12:58
Re: Inheritance fixing timeline? (Was "Inherited FK Indexing") Scott Ribe 13:41
Dump of table structure is not consistent Poul Møller Hansen 13:51
sha1 function Martin Marques 14:00
Re: Normalized Tables & SELECT [was: Find "smallest common year"] Stefan Schwarzer 14:13
Re: Normalized Tables & SELECT [was: Find "smallest common year"] Stefan Schwarzer 14:17
Re: Normalized Tables & SELECT [was: Find "smallest common year"] Stefan Schwarzer 14:28
Re: sha1 function Richard Huxton 14:35
Re: Normalized Tables & SELECT [was: Find "smallest common year"] Alban Hertroys 14:37
Re: more problems with count(*) on large table Mike Charnoky 14:59
Re: Normalized Tables & SELECT [was: Find "smallest common year"] Stefan Schwarzer 15:06
Re: more problems with count(*) on large table Gregory Stark 15:16
Re: usage of indexes for inner joins Scott Marlowe 15:16
Re: Normalized Tables & SELECT [was: Find "smallest common year"] Alban Hertroys 15:31
Inheritance problem when restoring db Sebastjan Trepca 16:00
Re: Inheritance problem when restoring db Tom Lane 16:14
Re: Inheritance fixing timeline? (Was "Inherited FK Indexing") Alvaro Herrera 16:33
Re: row->ARRAY or row->table casting? Nico Sabbi 16:34
Find out encoding of data joynes 16:56
Re: more problems with count(*) on large table Mike Charnoky 17:00
Re: more problems with count(*) on large table Alan Hodgson 17:12
Find clusters containing a schema? Josh Trutwin 17:14
Strange behavior of TRIGGER Nurlan Mukhanov 17:19
Upgrading PG Gauthier, Dave 17:26
Re: using COPY, .CSV and ¿catalog? Andrej Ricnik-Bay 17:27
Re: more problems with count(*) on large table Alvaro Herrera 17:33
Re: more problems with count(*) on large table Bill Moran 17:34
Re: Partitioned table limitation paul rivers 17:38
Re: Upgrading PG Alan Hodgson 17:42
Re: more problems with count(*) on large table Gregory Stark 17:43
Re: Upgrading PG Joshua D. Drake 17:45
Re: Upgrading PG Erik Jones 17:49
Re: It's time to support GRANT SELECT, UPDATE, ..., ..., ... ON database.* to username MrKrinkle 17:52
Select too many ids.. Abandoned 18:06
Re: usage of indexes for inner joins Scott Marlowe 18:13
PostgreSQL Conference Fall 2007, final schedule Joshua D. Drake 18:15
Feature Request - Defining default table space for Indexes in Conf file S Sharma 18:22
Re: Partitioned table limitation Goboxe 18:26
Re: usage of indexes for inner joins Jan Theodore Galkowski 18:35
Re: PostgreSQL Conference Fall 2007, final schedule Matthew T. O'Connor 19:13
Re: [GENERAL] PostgreSQL Conference Fall 2007, final schedule Joshua D. Drake 19:24
Re: importing large files Dimitri Fontaine 19:30
Re: Data cube in PostgreSQL Dimitri Fontaine 19:39
Porting Schema from MySQL Farhan Khan 19:54
Re: Find clusters containing a schema? Alvaro Herrera 20:02
Re: It's time to support GRANT SELECT, UPDATE, ..., ..., ... ON database.* to username Scott Marlowe 20:14
Re: Porting Schema from MySQL Michael Glaesemann 20:17
Re: Partitioned table limitation Scott Marlowe 20:22
Re: sha1 function Phoenix Kiula 20:30
Re: Dump of table structure is not consistent Poul Møller Hansen 21:08
Re: windows and pg 8.2 (change database to another server) Terry Yapt 21:38
pgcrypto digest_exists replacement? Nasby Jim 23:33
Strange discrepancy in query performance... Jason L. Buberel 23:47

Oct. 2, 2007

Thread Author Time
Re: Strange discrepancy in query performance... Tom Lane 00:01
Re: Partitioned table limitation Goboxe 00:28
Re: Strange discrepancy in query performance... Jason L. Buberel 05:32
Re: Find out encoding of data Albe Laurenz 07:13
Re: how to ignore invalid byte sequence for encoding without using sql_ascii? Martijn van Oosterhout 07:30
Re: more problems with count(*) on large table Tomasz Ostrowski 07:42
Re: more problems with count(*) on large table Martijn van Oosterhout 07:47
Re: windows and pg 8.2 (change database to another server) Magnus Hagander 08:34
Re: Find out encoding of data joynes 09:34
Execution plan caching Philippe Lang 13:19
Find min year and min value Stefan Schwarzer 13:26
Re: Find min year and min value Richard Huxton 13:40
Re: Execution plan caching Richard Huxton 13:45
Re: Find min year and min value Stefan Schwarzer 13:48
Re: Find min year and min value Richard Huxton 13:56
Re: Execution plan caching Douglas McNaught 14:10
Re: Strange discrepancy in query performance... Tom Lane 14:13
Re: Find min year and min value Stefan Schwarzer 14:29
Re: Find min year and min value Richard Huxton 14:53
Re: Find min year and min value Michael Glaesemann 14:53
Re: Strange discrepancy in query performance... Jason L. Buberel 15:33
Re: It's time to support GRANT SELECT, UPDATE, ..., ..., ... ON database.* to username Chris Browne 16:06
Re: It's time to support GRANT SELECT, UPDATE, ..., ..., ... ON database.* to username Scott Marlowe 16:08
Re: Find min year and min value Steve Crawford 16:10
Re: Feature Request - Defining default table space for Indexes in Conf file Ron Johnson 16:26
create visual query in web applications Ottavio Campana 16:30
Re: Select too many ids.. Scott Marlowe 16:31
Re: Select too many ids.. Rodrigo De León 16:31
Re: more problems with count(*) on large table Mike Charnoky 16:48
Re: Find min year and min value hubert depesz lubaczewski 17:37
Re: more problems with count(*) on large table Bill Moran 18:01
Re: Find min year and min value Michael Glaesemann 18:10
Re: Strange behavior of TRIGGER Jeff Davis 18:43
Re: It's time to support GRANT SELECT,UPDATE,...,...,... ON database.* to username Jeff Davis 19:12
Re: It's time to support GRANT SELECT,UPDATE,...,...,... ON database.* to username Jeff Davis 19:14
Re: It's time to support GRANT SELECT, UPDATE, ..., ..., ... ON database.* to username dterrors 19:42
Re: It's time to support GRANT SELECT,UPDATE,...,...,... ON database.* to username Joshua D. Drake 19:56
Re: Partitioned table limitation paul rivers 20:00
PITR and Compressed WALS Brian Wipf 20:36
Finding number of rows deleted in a stored procedure Ross Bagley 20:41
Re: Finding number of rows deleted in a stored procedure Alvaro Herrera 20:48
Re: Finding number of rows deleted in a stored procedure Joshua D. Drake 20:52
Can't access Cluster Ralph Smith 21:14
Re: Finding number of rows deleted in a stored procedure Ross Bagley 21:32
Re: Finding number of rows deleted in a stored procedure Ross Bagley 21:32
pg_dump Bob Pawley 22:19
Re: pg_dump Joshua D. Drake 22:26
Re: pg_dump Bob Pawley 22:37
PITR Recovery and out-of-sync indexes Brian Wipf 23:11

Oct. 3, 2007

Thread Author Time
Re: pg_dump Joshua D. Drake 00:39
Re: pg_dump Ron Johnson 00:57
Re: pg_dump Adrian Klaver 01:04
Re: datestyle question Diego Gil 01:56
Re: It's time to support GRANT SELECT, UPDATE, ..., ..., ... ON database.* to username dterrors 03:58
Re: datestyle question Erik Jones 05:27
Re: Find out encoding of data Albe Laurenz 05:49
Re: Can't access Cluster Albe Laurenz 06:04
Re: Find min year and min value Stefan Schwarzer 06:29
Re: PITR Recovery and out-of-sync indexes Richard Huxton 07:03
Re: Find out encoding of data joynes 08:10
pg_cancel_backend() does not work with buzz queries Sergey Konoplev 08:11
Re: Select too many ids.. Alban Hertroys 08:25
Re: pg_cancel_backend() does not work with buzz queries Sergey Konoplev 08:44
Re: pg_cancel_backend() does not work with buzz queries Richard Huxton 09:10
Re: pg_cancel_backend() does not work with buzz queries Richard Huxton 10:18
Re: datestyle question Diego Gil 10:26
Re: pg_cancel_backend() does not work with buzz queries Magnus Hagander 10:57
Re: Feature Request - Defining default table space for Indexes in Conf file Josh Tolley 11:12
Re: [GENERAL] pg_cancel_backend() does not work with buzz queries Sergey Konoplev 11:34
Re: pg_cancel_backend() does not work with buzz queries Sergey Konoplev 11:45
Re: pg_cancel_backend() does not work with buzz queries Richard Huxton 11:47
Tsearch2 Dutch snowball stemmer in PG8.1 Alban Hertroys 12:09
Re: pg_cancel_backend() does not work with buzz queries Alvaro Herrera 12:12
Re: Tsearch2 Dutch snowball stemmer in PG8.1 Oleg Bartunov 12:32
Re: reporting tools Geoffrey 12:47
Re: Find min year and min value Michael Glaesemann 12:55
Re: Tsearch2 Dutch snowball stemmer in PG8.1 Alban Hertroys 13:35
Re: Tsearch2 Dutch snowball stemmer in PG8.1 Alban Hertroys 14:05
Re: PITR Recovery and out-of-sync indexes Tom Lane 14:07
Re: pg_cancel_backend() does not work with buzz queries Tom Lane 14:20
Re: Tsearch2 Dutch snowball stemmer in PG8.1 Oleg Bartunov 15:10
Re: Tsearch2 Dutch snowball stemmer in PG8.1 Oleg Bartunov 15:12
Re: pg_cancel_backend() does not work with buzz queries Erik Jones 15:13
SLOW Remote Connection to PostgreSQL Database Matt White 15:39
Easier string concat in PL funcs? Jerry Sievers 15:47
Windows vista hafordjr 15:59
Re: Easier string concat in PL funcs? Alvaro Herrera 16:04
Generating TRUNCATE orders Laurent ROCHE 16:59
Re: Generating TRUNCATE orders Richard Huxton 17:11
Re: Generating TRUNCATE orders Scott Marlowe 17:19
Re: Easier string concat in PL funcs? hubert depesz lubaczewski 17:29
Backup single database roles and ACLs Rui Lopes 17:44
Importing MySQL dump into PostgreSQL 8.2 Jeff Lanzarotta 17:58
Re: Backup single database roles and ACLs Joshua D. Drake 18:00
Re: PITR Recovery and out-of-sync indexes Brian Wipf 18:16
Re: Generating TRUNCATE orders Erik Jones 18:16
Unexpected behavior with CASE statement Jimmy Choi 18:29
Re: PITR Recovery and out-of-sync indexes Tom Lane 18:32
Re: PITR and Compressed WALS Tom Lane 18:38
Re: Feature Request - Defining default table space for Indexes in Conf file Tom Lane 18:40
Re: PITR Recovery and out-of-sync indexes Richard Huxton 18:46
Re: PITR Recovery and out-of-sync indexes Alvaro Herrera 18:59
Re: PITR Recovery and out-of-sync indexes Brian Wipf 19:00
Re: PITR Recovery and out-of-sync indexes Richard Huxton 19:03
Unexpected behavior with CASE statement Jimmy Choi 19:05
Re: PITR and Compressed WALS Brian Wipf 19:05
Re: Unexpected behavior with CASE statement Rodrigo De León 19:56
Re: Unexpected behavior with CASE statement Jimmy Choi 20:08
Re: Unexpected behavior with CASE statement Alvaro Herrera 20:19
Re: PITR Recovery and out-of-sync indexes Tom Lane 22:17
Re: Unexpected behavior with CASE statement Tom Lane 23:15

Oct. 4, 2007

Thread Author Time
Design Question (Time Series Data) Andreas Strasser 01:07
Re: Easier string concat in PL funcs? Merlin Moncure 01:48
Re: Partitioned table limitation Goboxe 04:31
Re: Poor performance with ON DELETE CASCADE Conal 04:40
About selected data dump longlong 05:34
Partitioned tables, rules, triggers Goboxe 05:44
Re: Auto-partitioning? Goboxe 06:23
Re: About selected data dump Albe Laurenz 08:37
Re: Design Question (Time Series Data) Pavel Stehule 09:20
Re: Design Question (Time Series Data) Jorge Godoy 09:34
Postgres8: subselect and optimizer/planner Erwin Moller 09:52
Re: Postgres8: subselect and optimizer/planner Erwin Moller 10:01
Re: Design Question (Time Series Data) Pavel Stehule 10:09
multiple row insertion test tester 11:19
Re: multiple row insertion Mikko Partio 11:34
Re: Find min year and min value Stefan Schwarzer 11:41
Re: multiple row insertion Ashish Karalkar 11:42
Re: Generating TRUNCATE orders Florian Pflug 11:54

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