pgsql-general since 2001-04-30 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)

Browse Archives

Prev | Next

April 30, 2001

Thread Author Time
Why do things slow down without a VACUUM? Lincoln Yeoh 01:14
Re: Why do things slow down without a VACUUM? GH 02:17
Re: Why do things slow down without a VACUUM? Lincoln Yeoh 03:23
Re: Why do things slow down without a VACUUM? GH 03:38
Re: Why do things slow down without a VACUUM? Bruce Momjian 03:48
Re: Re: SQL Where Like - Range it?! Tom Lane 05:11
Rebuilding database from table files Mark Lawrence 05:15
Postgresql CVSup server down? Alfred Perlstein 05:29
Re: Returning tuple(s) from C-Functions Tom Lane 05:31
Re: PostgreSQL and mySQL database size question Tom Lane 05:39
Data type money. How to use? Lark 06:01
CREATE USER Jesus Aneiros 07:05
Re: CREATE USER Peter Eisentraut 09:01
Performance of c, pl/perl, pl/pgsql Einar Karttunen 09:14
Getting a list of fields in a table... Rich Henry 10:38
vacuum analyze error Christian Bucanac 11:48
Trying to get jdbc to work Mark Muffett 11:52
Re: Run a create object script ??? Atul 12:23
System catalogues Zak McGregor 12:42
Re: Performance of c, pl/perl, pl/pgsql Joel Burton 13:23
how to close idle connection created with php's pg_pconnect() Torsten Krmer 13:28
Re: Rebuilding database from table files Tom Lane 14:06
How to install on Windows? Erick Papadakis 14:16
Re: running pgaccess on localhost Eric G. Miller 14:46
Re: Help, I dropped a system datatype, and now I'm .... Tom Lane 14:48
Re: Regex select ~ with ^ not using index on char field or text; Locale bug? Tom Lane 14:51
Re: Regex select ~ with ^ not using index on char field or text; Locale bug? Greg Maxwell 14:52
RE: PostgreSQL and mySQL database size question Fred Ingham 14:54
Re: Help, I dropped a system datatype, and now I'm .... Dave Cramer 15:14
Re: SQL Server -> Postgres migration: Stored Procedure replacement? Tom Lane 15:28
PHPPgAdmin or MS Access Randall Perry 15:52
Re: System catalogues Peter Eisentraut 16:16
Re: Help, I dropped a system datatype, and now I'm .... Tom Lane 16:23
do functions cache views? Thomas F. O'Connell 16:26
Re: PostgreSQL and mySQL database size question Tom Lane 16:41
Dynamic Queries in pl/pgsql [w/variable substitution] Dan Wilson 16:45
Re: do functions cache views? Tom Lane 17:59
chr() command in PG7.03? Dr. Evil 18:31
Locking a database Jose Norberto 18:37
RE: PostgreSQL and mySQL database size question Fred Ingham 18:40
Re: Locking a database Michelle Murrain 18:44
Re: do functions cache views? Thomas F. O'Connell 18:46
wierd problems with DBI/DBD::pg? Michelle Murrain 18:50
Re: Locking a database Tom Lane 19:08
Re: Performance with Large Volumes of Data John Coers 19:12
Re: PostgreSQL and mySQL database size question Tom Lane 19:17
datetime arithmatic Stuart 19:18
Problem installing Postgresql Al 19:35
Re: wierd problems with DBI/DBD::pg? Gilles DAROLD 19:54
Re: Problem installing Postgresql Gilles DAROLD 20:09
referencial conlumn contraints and inheritance Stuart 20:16
Re: Problem installing Postgresql Tom Lane 20:21
Re: wierd problems with DBI/DBD::pg? Tom Lane 20:23
Re: Problem installing Postgresql mike 20:41
More src install probs... David Pieper 20:45
Problem with restore on upgrading to 7.1 Joseph Shraibman 20:46
Primary Keys Brian Z 21:20
Re: Problem with restore on upgrading to 7.1 Tom Lane 21:27
Re: More src install probs... Lamar Owen 21:41
Copy John Coers 21:53
Re: More src install probs... David Pieper 22:14
Re: Copy Tom Lane 22:16
Re: Problem with restore on upgrading to 7.1 Joseph Shraibman 22:17
DBI/AutoCommit/Postgres Fran Fabrizio 22:40
Re: PHPPgAdmin or MS Access Joel Burton 22:57
Re: DBI/AutoCommit/Postgres Tom Lane 23:21
TRUNCATE and INDEXes Eugene Lee 23:27

May 1, 2001

Thread Author Time
Minor documentation bug Joseph Shraibman 01:52
fsync on 7.1 Joseph Shraibman 02:01
Re: fsync on 7.1 Tom Lane 02:39
Re: fsync on 7.1 Joseph Shraibman 02:45
Re: Minor documentation bug Tom Lane 03:05
Re: Minor documentation bug Bruce Momjian 03:23
plpgsql function Diana Cionoiu 03:48
When DST occurs Justin Clift 05:36
Improve a query... Eric G. Miller 09:03
Re: How to install on Windows? WT Medewerker 09:40
Re: Minor documentation bug Vince Vielhaber 09:51
Re: wierd problems with DBI/DBD::pg? pmh 10:27
Re: wierd problems with DBI/DBD::pg? pmh 11:18
Newbie Question Clay & Judi Kinney 12:34
Re: wierd problems with DBI/DBD::pg? Michelle Murrain 13:42
Re: Report Writer for PostgreSQL Aaron Watters 13:50
Re: Locking a database Lincoln Yeoh 14:35
Re: Primary Keys Thomas F. O'Connell 15:13
Re: Copy John Coers 15:49
making with ssl support Chris Hayner 16:39
Multicolumn index - is there a limit? Fran Fabrizio 16:51
Stranger than fiction... Fran Fabrizio 17:05
Re: Re: SQL Where Like - Range it?! will trillich 17:44
Serial Type Christian Marschalek 17:44
Ideal hardware configuration for pgsql 📎 Ryan Mahoney 17:56
disk usage advice needed newsreader 18:26
non-timezoned timestamp column? Vivek Khera 18:31
how to start postgresql server ( or postmaster ) automatically Hualin Yip 19:03
Re: Copy John Coers 22:05
Ideal hardware configuration for pgsql 📎 Ryan Mahoney 22:35
readline-support Peter Pilsl 22:35
Re: do functions cache views? Thomas F. O'Connell 22:59
underlying structure: varchar vs. text pnews 23:00
do views cache functions? (was Re: do functions cache views?) Thomas F. O'Connell 23:05

May 2, 2001

Thread Author Time
Timestamp bug WAS: Problem with restore on upgrading to 7.1 Joseph Shraibman 01:47
Re: Re: function with multi-values Harry Yau 02:10
Re: Multicolumn index - is there a limit? Tom Lane 04:28
Re: making with ssl support Justin Clift 04:29
Re: readline-support Tom Lane 04:31
Technical Suggestion Pl. Clarrify. sathya 04:36
Re: Serial Type Justin Clift 05:02
Re: Improve a query... Tom Lane 05:17
Re: Re: do functions cache views? Tom Lane 05:22
RE: Ideal hardware configuration for pgsql Christian Marschalek 05:28
Re: Improve a query... Eric G. Miller 06:10
RE: Ideal hardware configuration for pgsql Willis, Ian (Ento, Canberra) 07:02
Re: how to start postgresql server ( or postmaster ) automatically Lark 08:07
delete with cascade Martín Marqués 08:14
update ... from where id in (..) question Feite Brekeveld 08:30
Re: chr() command in PG7.03? Karel Zak 08:35
multiple INSERT Renaud Thonnart 09:03
RE: Ideal hardware configuration for pgsql mkb 10:23
Thread or not threads? 📎 Raymond Chui 11:17
Re: Thread or not threads? AV 11:54
Re: Thread or not threads? Carl Rosenberger 13:40
Test Message (No Reply Necessary) Roderick A. Anderson 14:33
Re: Thread or not threads? Per Schrder 14:34
Re: Stranger than fiction... Gregory Wood 14:40
Re: disk usage advice needed Bruce Momjian 14:45
best way to implement producer/consumer in Perl Vivek Khera 14:47
RE: Improve a query... Jeff Eckermann 14:48
RE: Joining more than 2 tables Jeff Meeks 14:58
Re: Thread or not threads? 📎 Raymond Chui 15:17
Re: Stranger than fiction - EXPLAIN results Fran Fabrizio 15:24
Re: Thread or not threads? Per Schrder 15:46
Re: disk usage advice needed newsreader 15:54
Update Triggers & NULLs Gregory Wood 16:52
Re: Serial Type Peter Eisentraut 17:26
Re: Improve a query... Peter Eisentraut 17:30
RE: Joining more than 2 tables Joel Burton 17:43
Re: Ideal hardware configuration for pgsql 📎 Ryan Mahoney 19:07
PL/Perl documentation ... Adam Walczykiewicz 19:18
big pg 6.5 and 7.1 problem in simple application Aaron Brashears 19:23
RE: update ... from where id in (..) question Mike Mascari 19:26
Re: Update Triggers & NULLs Doug McNaught 19:33
Re: update ... from where id in (..) question Gregory Wood 19:34
Re: Re: Stranger than fiction - EXPLAIN results Doug McNaught 19:38
DROP TABLE wildcard Andy Koch 19:52
Strange SERIAL / Sequence error Christian Marschalek 19:53
RPM won't install Doug Ostgard 19:55
Cannot build PL/Perl ... Adam Walczykiewicz 19:59
RE: Ideal hardware configuration for pgsql Albertson, Chris 20:01
Multi Procerssor 📎 Ryan Mahoney 20:12
Re: best way to implement producer/consumer in Perl Joel Burton 20:21
Re: big pg 6.5 and 7.1 problem in simple application Doug McNaught 20:22
"group by" is quite expensive Albertson, Chris 20:41
Security and performance pgsql 21:10
Tuple Max Size on 7.1 David Scholes 21:14
Re: Cannot build PL/Perl ... Andy Koch 21:20
View permissions in 7.1 Lieven Van Acker 21:33
Re: DROP TABLE wildcard Joel Burton 21:50
Re: multiple INSERT Joel Burton 21:55
Tuple Max Size on 7.1 David Scholes 21:57
Re: update ... from where id in (..) question Joel Burton 21:57
Re: Security and performance Joel Burton 21:59
Re: DROP TABLE wildcard Andy Koch 22:08
Re: Strange SERIAL / Sequence error Tom Lane 22:10
Re: update ... from where id in (..) question Tom Lane 22:25
Re: Tuple Max Size on 7.1 Joel Burton 22:28
Re: Re: DROP TABLE wildcard Tom Lane 22:42
Re: Tuple Max Size on 7.1 Tom Lane 22:44
Re: Tuple Max Size on 7.1 David Scholes 22:48
Re: "group by" is quite expensive Tom Lane 22:51
RE: SQL Server -> Postgres migration: Stored Procedure replacement? Eliel Mamousette 22:57
Re: Security and performance Bruce Richardson 23:22
Re: Tuple Max Size on 7.1 Doug McNaught 23:36
Re: Ideal hardware configuration for pgsql GH 23:52
Unique or Primary Key? pgsql 23:58

May 3, 2001

Thread Author Time
Re: Ideal hardware configuration for pgsql Doug McNaught 00:29
Re: Ideal hardware configuration for pgsql Dominic J. Eidson 00:50
RE: Security and performance jeff.fitzmyers 00:50
Re: Ideal hardware configuration for pgsql Bruce Momjian 00:52
Re: Ideal hardware configuration for pgsql GH 00:53
Re: Improve a query... Eric G. Miller 01:04
Not make guard 01:14
Re: Tuple Max Size on 7.1 Tom Lane 01:35
Re: Re: update ... from where id in (..) question Tom Lane 01:36
Re: big pg 6.5 and 7.1 problem in simple application Eric G. Miller 01:37
Re: Multi Procerssor Bruce Momjian 01:46
Re: Unique or Primary Key? Eric G. Miller 01:50
Re: Multi Procerssor Mitch Vincent 01:53
Re: View permissions in 7.1 Tom Lane 02:00
Re: Ideal hardware configuration for pgsql Dave Cramer 02:06
Re: View permissions in 7.1 Tom Lane 02:15
DB Getting Slower and Slower and Slower.... Othman Laraki 02:17
Re: Unique or Primary Key? GH 02:29
RE: Ideal hardware configuration for pgsql Willis, Ian (Ento, Canberra) 02:35
Re: Ideal hardware configuration for pgsql Sean Chittenden 02:37
Re: Tuple Max Size on 7.1 David Scholes 02:53
Re: Multiple INSERT Diana Cionoiu 03:20
Perl Scope problem Randall Perry 03:27
Re: [MacPerl] Perl Scope problem hciR nellA 03:55
Daylight savings Justin Clift 07:03

Browse Archives

Prev | Next