Peripheral Links

• Home
• About
• Download
• Documentation
• Community
• Developers
• Support
• Your account

pgsql-general - February 2004

Feb. 1, 2004

• Re: PostgreSQL 7.4.1 and pgdb.py Manuel Tejada (00:01)
• Re: Problem with API (libpq) - detailed error codes Tom Lane (00:18)
• Re: Unicode vs SQL_ASCII DBs Culley Harrelson (00:51)
• Re: Problem with function Tom Lane (01:53)
• Re: Very slow query - why? Eric Ridge (01:56)
• Re: select ... distinct performance Martijn van Oosterhout (02:08)
• Re: Help: System requirements for postgresql 7.4.1 Martijn van Oosterhout (02:15)
• Re: select ... distinct performance Don Bowman (02:34)
• Re: Incorrect Results From Select When Using Non-English Characters Tom Lane (03:52)
• pg_generate_sequence and info_schema patch (Was: SELECT Question) Joe Conway (04:31)
• Re: Are there commands to enquire about table structure? Doug McNaught (04:41)
• Re: pg_generate_sequence and info_schema patch (Was: SELECT Question) Tom Lane (05:00)
• Does SET STATISTICS lock the table? Joseph Shraibman (05:56)
• Search across multiple sources Merrall, Graeme (06:33)
• Re: Does SET STATISTICS lock the table? Tom Lane (06:56)
• Re: Search across multiple sources Oleg Bartunov (09:58)
• partial indexes Unregistered (12:14)
• Re: Functions in CHECK constraint not getting dumped before Rajesh Kumar Mallah (20:36)
• Re: Search across multiple sources Merrall, Graeme (20:38)
• Re: pg_generate_sequence and info_schema patch (Was: SELECT Joe Conway (20:54)
• Re: pg_generate_sequence and info_schema patch (Was: SELECT Question) Tom Lane (21:12)
• Functions in CHECK constraint not getting dumped before tables. Rajesh Kumar Mallah (21:13)
• Re: PostgreSQL 7.4.1 and pgdb.py Gaetano Mendola (21:48)
• Re: PostgreSQL 7.4.1 and pgdb.py Gaetano Mendola (21:58)
• Re: Functions in CHECK constraint not getting dumped before tables. Tom Lane (22:34)

Feb. 2, 2004

• Re: PostgreSQL 7.4.1 and pgdb.py Manuel Tejada (01:24)
• Re: PostgreSQL 7.4.1 and pgdb.py Gaetano Mendola (01:26)
• Re: partial indexes Tom Lane (03:53)
• Error with pg_restore (parse error at or near "BY" at character 144 nednieuws | charles (04:05)
• Re: Error with pg_restore (parse error at or near "BY" at character 144 Tom Lane (05:15)
• Re: I can't upgrade to PostgreSQL 7.4 in RedHat 9.0 Stephen Robert Norris (05:22)
• Re: pg_generate_sequence and info_schema patch (Was: SELECT Joe Conway (06:02)
• Re: pg_generate_sequence and info_schema patch (Was: SELECT Question) Tom Lane (06:44)
• Re: Very slow query - why? Richard Schilling (06:52)
• Re: Problem with API (libpq) - detailed error codes Adam Bukla (07:30)
• Re: pg_generate_sequence and info_schema patch (Was: SELECT Question) Tom Lane (07:31)
• How to kick out automatically stuck in queries Együd Csaba (08:29)
• Array in stored procedure Michal Hlavac (08:37)
• Re: How to kick out automatically stuck in queries Kris Jurka (09:13)
• Re: How to kick out automatically stuck in queries Együd Csaba (09:29)
• Re: Search across multiple sources Bernd Helmle (09:46)
• Re: Unicode vs SQL_ASCII DBs John Sidney-Woollett (09:57)
• Re: Unicode vs SQL_ASCII DBs Kris Jurka (10:27)
• Re: Unicode vs SQL_ASCII DBs John Sidney-Woollett (11:08)
• Re: I can't upgrade to PostgreSQL 7.4 in RedHat 9.0 Alvaro Herrera (11:11)
• Re: I can't upgrade to PostgreSQL 7.4 in RedHat 9.0 Stephen Robert Norris (11:42)
• isolating users from each other Christian Rank (12:12)
• Postgresql 7.3 And Redhat Enterprise 3 Remi (14:03)
• Re: Problem with function Rich Hall (14:20)
• Return Value of a Function Terry Lee Tucker (14:36)
• Re: Very slow query - why? Tom Lane (14:53)
• Re: Array in stored procedure Tom Lane (14:56)
• Re: I can't upgrade to PostgreSQL 7.4 in RedHat 9.0 Alvaro Herrera (14:59)
• Re: I can't upgrade to PostgreSQL 7.4 in RedHat 9.0 Martin Marques (15:04)
• Re: Unicode vs SQL_ASCII DBs Tom Lane (15:11)
• Re: business references for postgresql Keith C. Perry (15:13)
• Select Question Alex (15:22)
• Re: DB cache size strategies Jan Wieck (15:24)
• cannot extend error harjan (15:35)
• Re: Return Value of a Function Richard Huxton (15:36)
• Re: Are there commands to enquire about table structure? Ben (16:35)
• Re: Return Value of a Function Tom Lane (16:42)
• Re: Return Value of a Function Terry Lee Tucker (16:53)
• Re: Return Value of a Function Tom Lane (16:58)
• Re: About Privileges Bruno Wolff III (17:32)
• Re: Return Value of a Function Joe Conway (17:47)
• Re: I can't upgrade to PostgreSQL 7.4 in RedHat 9.0 Alvaro Herrera (17:47)
• Re: Return Value of a Function Tom Lane (18:02)
• Re: I can't upgrade to PostgreSQL 7.4 in RedHat 9.0 Martín Marqués (18:10)
• Re: Very slow query - why? Ben (18:20)
• Re: Return Value of a Function Joe Conway (18:55)
• Re: Return Value of a Function Tom Lane (18:58)
• Re: Select Question Martijn van Oosterhout (19:06)
• Re: Return Value of a Function Terry Lee Tucker (19:31)
• Re: Select Question Jeff Eckermann (19:38)
• Transfer database tables to a schema Peter Darley (19:47)
• Re: Select Question Richard Huxton (20:43)
• Re: Postgresql 7.3 And Redhat Enterprise 3 Alvaro Herrera (21:23)
• Re: Postgresql 7.3 And Redhat Enterprise 3 Matt Davies (21:49)
• recursive query? CSN (21:54)
• Re: Are there commands to enquire about table structure? Doug McNaught (22:45)
• Re: Are there commands to enquire about table structure? Ben (23:32)

Feb. 3, 2004

• Before ship 7.4.2 Gaetano Mendola (00:31)
• Re: recursive query? Andrew Rawnsley (01:44)
• Re: cannot extend error Tom Lane (02:47)
• Re: Are there commands to enquire about table structure? Tom Lane (02:57)
• Re: Before ship 7.4.2 Tom Lane (03:54)
• Re: pg_generate_sequence and info_schema patch (Was: SELECT Joe Conway (08:38)
• BLOB problem Rens Admiraal (11:24)
• BLOB problem Rens Admiraal (11:28)
• Re: BLOB problem Doug McNaught (13:54)
• Copy and xml files C G (14:16)
• large crontab database design David Garamond (14:52)
• Multicolumn Indexing using R-Tree Marcio Caetano (14:52)
• Specifying a index Marcio Caetano (15:04)
• Re: large crontab database design Csaba Nagy (15:34)
• problem with jdbc connection to postgesql Phil Campaigne (15:45)
• Anyone has nls activated on Mac OS X? Francois Suter (16:02)
• Re: Copy and xml files Chris Gamache (16:29)
• Re: problem with jdbc connection to postgesql Dirk Försterling (17:41)
• Re: Pl/tcl auto-load problem Craig Addleman (18:16)
• Re: problem with jdbc connection to postgesql Paul Thomas (18:37)
• Re: Anyone has nls activated on Mac OS X? Peter Eisentraut (18:52)
• Re: Before ship 7.4.2 Lamar Owen (19:10)
• Re: Before ship 7.4.2 Gaetano Mendola (19:20)
• Re: Are there commands to enquire about table structure? Gregory Wood (22:42)
• Re: Are there commands to enquire about table structure? Tom Lane (23:29)
• Re: BLOB problem Tom Lane (23:31)
• Re: Specifying a index Tom Lane (23:33)

Feb. 4, 2004

• Re: BLOB problem scott.marlowe (00:09)
• application developers list?? or report engine using postgres? Klint Gore (01:08)
• Re: BLOB problem Cornelia Boenigk (02:31)
• Re: Transfer database tables to a schema Chris Travers (04:40)
• Re: large crontab database design David Garamond (04:41)
• Re: application developers list?? or report engine using postgres? Steve Atkins (04:46)
• Aggregation question Dilip Angal (05:27)
• Re: Transfer database tables to a schema Tom Lane (05:47)
• Re: pg_generate_sequence and info_schema patch (Was: SELECT Joe Conway (05:57)
• Re: recursive query? CSN (05:59)
• Re: pg_generate_sequence and info_schema patch (Was: SELECT Question) Tom Lane (06:21)
• RETURN NEXT and reversing order CSN (06:24)
• Re: pg_generate_sequence and info_schema patch (Was: SELECT Christopher Kings-Lynne (07:10)
• Re: BLOB problem Nigel J. Andrews (07:23)
• Re: postmaster growing to consume all memory Lincoln Yeoh (07:50)
• Re: Transfer database tables to a schema Shridhar Daithankar (08:18)
• Re: RETURN NEXT and reversing order Richard Huxton (09:53)
• Transaction end on error Christian Traber (09:54)
• Re: BLOB problem Rod K (11:58)
• Re: Transaction end on error Richard Huxton (13:18)
• Re: Anyone has nls activated on Mac OS X? Francois Suter (13:38)
• Re: pg_generate_sequence and info_schema patch (Was: SELECT Christopher Browne (14:33)
• Resize varchar column John Sidney-Woollett (14:45)
• Re: Resize varchar column Bruno Wolff III (15:08)
• Re: Anyone has nls activated on Mac OS X? Tom Lane (15:52)
• Re: Resize varchar column John Sidney-Woollett (16:00)
• Re: Resize varchar column Dirk Försterling (16:31)
• Re: Anyone has nls activated on Mac OS X? Francois Suter (16:33)
• Re: Transfer database tables to a schema Peter Darley (16:47)
• Re: Resize varchar column scott.marlowe (16:48)
• Re: Anyone has nls activated on Mac OS X? John Sidney-Woollett (16:49)
• Re: Resize varchar column Richard Huxton (17:07)
• Re: Resize varchar column John Sidney-Woollett (17:11)
• Re: Copy and xml files Guy Fraser (17:54)
• Predictive or scoring solution for PostgreSQL ? Hervé Piedvache (20:45)
• Re: pg_generate_sequence and info_schema patch (Was: SELECT Joe Conway (22:56)
• Improving performance with a Function instead of a View Hadley Willan (23:07)

Feb. 5, 2004

• dblink: rollback transaction Oleg Lebedev (00:08)
• Re: pg_generate_sequence and info_schema patch (Was: SELECT Gaetano Mendola (00:20)
• Re: Improving performance with a Function instead of a Mike Mascari (00:31)
• Re: Predictive or scoring solution for PostgreSQL ? Marc A. Leith (02:21)
• Re: Predictive or scoring solution for PostgreSQL ? Mike Mascari (03:31)
• Re: pg_generate_sequence and info_schema patch (Was: SELECT Joe Conway (04:57)
• Re: Predictive or scoring solution for PostgreSQL ? Joe Conway (05:08)
• Re: Predictive or scoring solution for PostgreSQL ? Marc A. Leith (05:20)
• Re: Improving performance with a Function instead of a Hadley Willan (05:49)
• Re: dblink: rollback transaction John Sidney-Woollett (07:49)
• Can LIKE use indexes or not? David Garamond (08:30)
• Re: Improving performance with a Function instead of a Kris Jurka (08:41)
• Re: Can LIKE use indexes or not? John Sidney-Woollett (08:58)
• Re: Can LIKE use indexes or not? John Sidney-Woollett (09:20)
• Re: Can LIKE use indexes or not? Jan Poslusny (09:22)
• Re: Can LIKE use indexes or not? Lincoln Yeoh (09:43)
• Proper tool to display graphics? Carlos Ojea Castro (09:48)
• Re: Can LIKE use indexes or not? David Garamond (10:25)
• size of mailing lists? David Garamond (10:28)
• Re: Can LIKE use indexes or not? Richard Huxton (11:14)
• Re: size of mailing lists? Richard Huxton (11:20)
• Re: Can LIKE use indexes or not? David Garamond (11:42)
• Re: size of mailing lists? David Garamond (11:50)
• Re: Anyone has nls activated on Mac OS X? Francois Suter (12:45)
• Re: Predictive or scoring solution for PostgreSQL ? Mike Mascari (12:45)
• Re: size of mailing lists? Karsten Hilbert (13:20)
• Re: Predictive or scoring solution for PostgreSQL ? Marc A. Leith (13:29)
• pg_restore and large files Mike Charnoky (14:23)
• dblink - custom datatypes don't work Mark Gibson (14:46)
• ERROR: column 'xxx' does not exist (under v. 7.4.1) Iker Arizmendi (15:00)
• Re: ERROR: column 'xxx' does not exist (under v. 7.4.1) Mark Gibson (15:17)
• Re: ERROR: column 'xxx' does not exist (under v. 7.4.1) Karsten Hilbert (15:22)
• Re: ERROR: column 'xxx' does not exist (under v. 7.4.1) Mark Gibson (15:23)
• : Proper tool to display graphics? Carlos Ojea Castro (15:24)
• Re: pg_restore and large files Tom Lane (15:33)
• Re: dblink: rollback transaction Oleg Lebedev (15:34)
• Re: dblink: rollback transaction John Sidney-Woollett (16:00)
• Re: size of mailing lists? Marc G. Fournier (16:05)
• Re: Functions in CHECK constraint not getting dumped before Rajesh Kumar Mallah (16:09)
• Re: Proper tool to display graphics? scott.marlowe (16:27)
• Re: performance difference: multiple db vs single db John Liu (17:09)
• Re: size of mailing lists? Tom Lane (17:15)
• Re: Proper tool to display graphics? Steve Crawford (17:16)
• functional index "real world" uses David Garamond (17:27)
• Re: dblink: rollback transaction Joe Conway (17:27)
• functional index "real world" uses David Garamond (17:29)
• Re: Proper tool to display graphics? Carlos Ojea Castro (17:31)
• Re: performance difference: multiple db vs single db John Sidney-Woollett (17:32)
• Re: dblink: rollback transaction Oleg Lebedev (17:39)
• Re: pg_restore and large files Mike Charnoky (17:41)
• Re: pg_restore and large files Mike Charnoky (18:12)
• Re: dblink: rollback transaction Joe Conway (18:49)
• Re: dblink - custom datatypes don't work Joe Conway (18:57)
• Re: Functions in CHECK constraint not getting dumped before Rajesh Kumar Mallah (19:06)