pgsql-general - January 2008

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, 2008

Thread Author Time
Problem with index when using function D. Dante Lorenso 04:15
Re: Problem with index when using function D. Dante Lorenso 04:21
timestamptz & 'infinity' & date Richard Broersma Jr 06:11
Re: timestamptz & 'infinity' & date Tom Lane 07:11
Hinting the planner Reg Me Please 09:38
Re: Hinting the planner Shane Ambler 13:45
Re: CREATE TYPE and pgAdmin III Raymond O'Donnell 14:11
Re: Hinting the planner Martin Gainty 16:27
Re: Hinting the planner Scott Marlowe 16:45
Re: basic questions: Postgres with yum on CentOS 5.1 Tomasz Ostrowski 17:05
Re: basic questions: Postgres with yum on CentOS 5.1 Andrew Sullivan 17:29
Re: basic questions: Postgres with yum on CentOS 5.1 Andrew Sullivan 17:40
A counter argument about DISTINCT and GROUP BY in PostgreSQL dterrors 19:33

Jan. 2, 2008

Thread Author Time
Need help requiring uniqueness in text columns Matthew Wilson 01:00
Re: Need help requiring uniqueness in text columns Stuart Bishop 02:43
Re: basic questions: Postgres with yum on CentOS 5.1 Chuck 02:49
Re: basic questions: Postgres with yum on CentOS 5.1 Joshua D. Drake 03:04
Re: basic questions: Postgres with yum on CentOS 5.1 Greg Smith 04:59
visibility rules for AFTER UPDATE Constraint Triggers Function Richard Broersma Jr 05:25
Re: basic questions: Postgres with yum on CentOS 5.1 Tom Lane 05:35
Re: visibility rules for AFTER UPDATE Constraint Triggers Function Tom Lane 05:36
Re: Can't make backup Albe Laurenz 07:48
group by and count(*) behaviour in 8.3 Edoardo Panfili 09:20
Re: Need help requiring uniqueness in text columns Pavel Stehule 09:23
Re: group by and count(*) behaviour in 8.3 Pavel Stehule 11:39
Re: group by and count(*) behaviour in 8.3 Edoardo Panfili 12:54
Re: group by and count(*) behaviour in 8.3 Pavel Stehule 13:19
Re: visibility rules for AFTER UPDATE Constraint Triggers Function 📎 Richard Broersma Jr 13:44
Fwd: [ADMIN] Shutting down warm standby server? " Glyn Astill 13:47
Creating XML/KML documents from single tables William Temperley 14:17
Re: Need help requiring uniqueness in text columns Matthew Wilson 15:11
Re: Need help requiring uniqueness in text columns Pavel Stehule 15:23
Re: Creating XML/KML documents from single tables Pavel Stehule 15:25
Slow count(*) Abraham, Danny 15:29
Re: basic questions: Postgres with yum on CentOS 5.1 Andrew Sullivan 15:32
Re: Slow count(*) Pavel Stehule 15:47
Re: Slow count(*) A. Kretschmer 15:50
Re: Slow count(*) Andrew Sullivan 16:25
Table auditing / Pg/tcl help Glyn Astill 16:32
Re: Any big slony and WAL shipping users? Andrew Sullivan 16:40
Re: [HACKERS] Slow count(*) Pavel Stehule 16:42
tablefunc and crosstab Vincent Bernat 16:56
tsearch2 headline options Jan Sunavec 17:03
Re: Hinting the planner Chris Browne 17:19
Re: visibility rules for AFTER UPDATE Constraint Triggers Function Tom Lane 18:00
Re: Slow count(*) Simon Riggs 18:12
PG is in different timezone than the OS Fernando Hevia 18:43
Re: Fwd: [ADMIN] Shutting down warm standby server? " Erik Jones 19:04
Re: PG is in different timezone than the OS Scott Marlowe 20:06
Re: Argentinian timezone change at the last moment. How to change pgsql tz db? Scott Marlowe 20:18
Re: PG is in different timezone than the OS Scott Marlowe 20:27
Re: [SQL] PG is in different timezone than the OS Scott Marlowe 20:31
Re: visibility rules for AFTER UPDATE Constraint Triggers Function Richard Broersma Jr 20:48
Re: Argentinian timezone change at the last moment. How to change pgsql tz db? Joe 20:49
PITR - filter by database? Martin Langhoff 21:27
Re: Argentinian timezone change at the last moment. How to change pgsql tz db? Scott Marlowe 23:29
Re: Argentinian timezone change at the last moment. How to change pgsql tz db? Tom Lane 23:45

Jan. 3, 2008

Thread Author Time
Re: PITR - filter by database? Usama Dar 00:41
Re: replication in Postgres Ow Mun Heng 01:02
Re: Read-only availability of a standby server? Ow Mun Heng 01:04
[OT] Slony (initial) Replication - Slow Ow Mun Heng 03:15
Re: Patch for Statement.getGeneratedKeys() Ken Johanson 06:22
Using syslog on pg for Windows Goboxe 07:17
[OT] Slony (initial) Replication - Slow Ow Mun Heng 09:26
Re: Can't make backup Sebastián Baioni 11:59
Re: Argentinian timezone change at the last moment. How to change pgsql tz db? Fernando Hevia 12:27
array as arguments of pg functions and php Ivan Sergio Borgonovo 13:31
Re: basic questions: Postgres with yum on CentOS 5.1 Tomasz Ostrowski 13:38
Re: Table auditing / Pg/tcl help 📎 Glyn Astill 13:47
Re: [OT] Slony (initial) Replication - Slow Bill Moran 14:20
Re: Slow count(*) Kevin Grittner 15:15
Re: Can't make backup Erik Jones 15:28
C-Extenions for PostgreSQL, Call Convention Version 0 Harald Armin Massa 15:30
Re: Table auditing / Pg/tcl help Glyn Astill 15:32
Re: Slow count(*) Brian Hurt 15:37
Re: Can't make backup Albe Laurenz 15:45
Re: C-Extenions for PostgreSQL, Call Convention Version 0 Pavel Stehule 16:10
Feature request: NOTIFY enhancement CN 16:11
Re: Feature request: NOTIFY enhancement Bruce Momjian 16:21
Re: C-Extenions for PostgreSQL, Call Convention Version 0 Tom Lane 16:27
Re: Can't make backup Sebastián Baioni 16:35
Re: Feature request: NOTIFY enhancement Andreas 'ads' Scherbaum 16:42
Re: Feature request: NOTIFY enhancement Bruce Momjian 16:51
Re: Feature request: NOTIFY enhancement Alvaro Herrera 18:06
Re: Feature request: NOTIFY enhancement Bruce Momjian 18:47
Re: Feature request: NOTIFY enhancement Chris Browne 19:20
CentOS-5 PostgreSQL 8.1.9 server instrumentation James B. Byrne 21:57
negative duration times in query logs George Pavlov 22:14

Jan. 4, 2008

Thread Author Time
Re: [OT] Slony (initial) Replication - Slow Geoffrey 00:17
SQLSTATE code for duplicate constraint Dan Langille 00:35
Re: negative duration times in query logs Tom Lane 00:35
Re: SQLSTATE code for duplicate constraint Tom Lane 00:52
Re: [OT] Slony (initial) Replication - Slow Ow Mun Heng 02:44
Re: [SQL] Argentinian timezone change at the last moment. How to change pgsql tz db? Fernando Hevia 03:57
Re: [SQL] Argentinian timezone change at the last moment. How to change pgsql tz db? Tom Lane 04:37
Re: Can't make backup Albe Laurenz 08:20
Re: Feature request: NOTIFY enhancement Marko Kreen 08:35
implicit vs. explicit RETURN when OUT is used Ivan Sergio Borgonovo 08:38
server process (PID 27884) was terminated by signal 4 (SIGILL) mljv 08:44
Re: server process (PID 27884) was terminated by signal 4 (SIGILL) Steve Atkins 09:03
Re: Updating a production database schema from dev server mljv 09:08
Solution: implicit vs. explicit RETURN when OUT is used Ivan Sergio Borgonovo 09:31
Re: server process (PID 27884) was terminated by signal 4 (SIGILL) mljv 09:36
TCL Glyn Astill 09:44
Re: Feature request: NOTIFY enhancement CN 12:44
Re: Feature request: NOTIFY enhancement Marko Kreen 13:42
Re: [SQL] Argentinian timezone change at the last moment. How to change pgsql tz db? Fernando Hevia 14:01
Re: How to handle 'not a number' in postgresql Martijn van Oosterhout 14:29
Re: Mandatory AS keyword in SELECT statements Bruce Momjian 14:31
Re: Using syslog on pg for Windows Magnus Hagander 14:33
Re: How to handle 'not a number' in postgresql Rich Shepard 14:35
Re: How to handle 'not a number' in postgresql Michael Glaesemann 14:46
Re: How to handle 'not a number' in postgresql Rich Shepard 15:00
Re: Best free open source ER diagram generator? Ivan Sergio Borgonovo 15:02
Connect to SQL Server via ODBC from Postgresql Afewtips.com 15:08
Re: How to handle 'not a number' in postgresql Michael Glaesemann 15:13
Re: TCL Joshua D. Drake 15:17
Re: Using syslog on pg for Windows Jeff Larsen 15:22
Re: Mandatory AS keyword in SELECT statements Martijn van Oosterhout 15:52
Re: tsearch2 headline options Oleg Bartunov 15:54
Re: Mandatory AS keyword in SELECT statements Bruce Momjian 15:58
Re: ERROR: catalog is missing 9 attribute(s) for relid 10297 Tom Lane 15:59
Hash Indexes Naz Gassiep 16:20
Fail to connect after server crash Kyle Wilcox 16:26
Re: Hash Indexes Martijn van Oosterhout 16:42
Re: Fail to connect after server crash Jonathan Ballet 16:44
Re: A counter argument about DISTINCT and GROUP BY in PostgreSQL Gregory Stark 16:48
Re: A counter argument about DISTINCT and GROUP BY in PostgreSQL Alvaro Herrera 16:50
Re: Connect to SQL Server via ODBC from Postgresql Afewtips.com 16:51
data volume resizing and large objects beer@cmu.edu 17:06
Re: Fail to connect after server crash Scott Marlowe 17:09
deadlock priority? Sergei Shelukhin 17:27
Re: Fail to connect after server crash Kyle Wilcox 17:46
Problem with pg_dump? Ken Winter 17:54
Re: [OT] Slony (initial) Replication - Slow Andrew Sullivan 18:08
Re: Fail to connect after server crash Scott Marlowe 18:41
Re: ERROR: catalog is missing 9 attribute(s) for relid 10297 O'Shea, Brendan 18:42
Re: tsearch2 headline options Jan Sunavec 18:49
Re: ERROR: catalog is missing 9 attribute(s) for relid 10297 Tom Lane 19:02
postgres 8.3 betat 1 version download SHARMILA JOTHIRAJAH 19:10
Re: [OT] Slony (initial) Replication - Slow Chris Browne 19:39
Re: ERROR: catalog is missing 9 attribute(s) for relid 10297 O'Shea, Brendan 19:50
Re: postgres 8.3 betat 1 version download Tom Lane 19:57
Concurrent modification of plpgsql function body Alex Vinogradovs 20:10
Re: Problem with pg_dump? Tom Lane 20:34
Re: Concurrent modification of plpgsql function body Tom Lane 20:36
Re: data volume resizing and large objects Tom Lane 20:42
Re: [OT] Slony (initial) Replication - Slow Alvaro Herrera 21:11
Re: data volume resizing and large objects beer@cmu.edu 21:12
Re: [OT] Slony (initial) Replication - Slow Andrew Sullivan 21:18
Re: data volume resizing and large objects Tom Lane 21:20
Re: data volume resizing and large objects Alvaro Herrera 21:21
Suggest Index Oliver Kohll 21:33
Re: data volume resizing and large objects beer@cmu.edu 21:47
Re: Problem with pg_dump? Ken Winter 22:29
Getting process id of a connection? Webb Sprague 22:59
Re: Getting process id of a connection? Joshua D. Drake 23:06
Re: Getting process id of a connection? Bricklen Anderson 23:08
Re: Getting process id of a connection? Colin Wetherbee 23:11
Re: Getting process id of a connection? Webb Sprague 23:17

Jan. 5, 2008

Thread Author Time
large table vacuum issues Ed L. 00:38
Performance problem. Could it be related to 8.3-beta4? Clodoaldo 00:45
Re: TCL ljb 00:47
Create Index (Hash) on a Large Table Taking Days... ProfKheel 00:54
Re: large table vacuum issues Scott Marlowe 01:21
Re: large table vacuum issues Ed L. 01:29
Re: large table vacuum issues Ed L. 01:41
Cannot connect to PgPool Christopher M Siwy 01:42
Re: Performance problem. Could it be related to 8.3-beta4? Tom Lane 01:47
Re: large table vacuum issues Scott Marlowe 02:03
Re: large table vacuum issues Joshua D. Drake 03:21
Need efficient way to do comparison with NULL as an option D. Dante Lorenso 04:06
Re: Performance problem. Could it be related to 8.3-beta4? Greg Smith 04:09
Re: Need efficient way to do comparison with NULL as an option D. Dante Lorenso 04:15
Re: Need efficient way to do comparison with NULL as an option Tom Lane 04:19
Re: Need efficient way to do comparison with NULL as an option D. Dante Lorenso 04:57
Re: Need efficient way to do comparison with NULL as an option D. Dante Lorenso 05:23
Re: large table vacuum issues Scott Marlowe 05:29
Re: Need efficient way to do comparison with NULL as an option Joshua D. Drake 05:39
Re: Need efficient way to do comparison with NULL as an option Tom Lane 05:59
Re: large table vacuum issues Bill Moran 13:18
PostgreSQL - XML Joana G. Malaverri 13:56
Setting variables equal to elements from an Array cdecarlo 14:10
Re: Performance problem. Could it be related to 8.3-beta4? Clodoaldo 14:34
Re: Performance problem. Could it be related to 8.3-beta4? Clodoaldo 14:40
Insert returning Npgsql 📎 Cesar Alvarez 15:07
Re: Need efficient way to do comparison with NULL as an option Lew 15:51
Re: Performance problem. Could it be related to 8.3-beta4? Tom Lane 17:42
Re: Performance problem. Could it be related to 8.3-beta4? Greg Smith 19:15
Re: Performance problem. Could it be related to 8.3-beta4? Scott Marlowe 21:12

Jan. 6, 2008

Thread Author Time
Re: implicit vs. explicit RETURN when OUT is used Tom Lane 07:47
Re: Performance problem. Could it be related to 8.3-beta4? Clodoaldo 11:06
Re: implicit vs. explicit RETURN when OUT is used Ivan Sergio Borgonovo 11:08
8.3-beta4, analyze and db owner Clodoaldo 11:26
Re: 8.3-beta4, analyze and db owner Magnus Hagander 11:35
Re: 8.3-beta4, analyze and db owner Clodoaldo 11:48
Re: large table vacuum issues Usama Dar 12:55
Re: Performance problem. Could it be related to 8.3-beta4? Scott Marlowe 14:51
Re: Using syslog on pg for Windows Goboxe 18:58
Index trouble with 8.3b4 Hannes Dorbath 19: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 31