Peripheral Links

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

pgsql-general - March 2002

March 1, 2002

• bulk insertions in PL/pgsql functions Richard Emberson (00:30)
• Re: SQL statement : list table details Neil Conway (00:58)
• Re: SQL statement : list table details Samik Raychauhduri (00:59)
• Re: SQL statement : list table details Booth, Robert (01:05)
• Re: SQL statement : list table details Stephan Szabo (01:08)
• Replication George Osvald (01:55)
• Newbie question re SQL John (02:53)
• libcrypt.so.2 Gtrica (08:40)
• Re: Replication Holger Marzen (09:13)
• Re: SQL statement : list table details Marc Polatschek (09:54)
• Re: PostgreSQL Licence: GNU/GPL Nevermind (10:32)
• Re: PostgreSQL Licence: GNU/GPL Jean-Michel POURE (11:07)
• Re: Sql basic Query Tommi Maekitalo (13:17)
• Pg_dump very large database Nikolay Mihaylov (13:38)
• check sql progress Johnson, Shaunn (14:00)
• Re: About vacuuming Jason Priebe (14:24)
• VACUUM query news.apexsc.com (15:17)
• Re: terminal with horizontal scrollbar Andrew Sullivan (15:20)
• Re: check sql progress Tom Lane (15:49)
• appending from table to table Johnson, Shaunn (15:52)
• Re: check sql progress Johnson, Shaunn (16:04)
• Aborting transaction on error Mark Rae (16:14)
• LIMIT and OFFSET Samuel J. Sutjiono (16:24)
• Clues about tables fileformat Miguel A. =?ISO-8859-1?Q?Ar=E9valo?= (16:29)
• passwd / pg_hba.conf Patrick Welche (18:53)
• Question to CREATE FUNCTION Cornelia Boenigk (19:08)
• Re: passwd / pg_hba.conf Tom Lane (20:02)
• improving performance of UNION and ORDER BY Chris Gamache (20:37)
• Index doesn't appear to be working. John Oakes (20:41)
• Qestion about CREATE FUNCTION Cornelia Boenigk (21:10)
• Re: improving performance of UNION and ORDER BY Jean-Luc Lachance (21:33)
• Re: Qestion about CREATE FUNCTION Tom Lane (21:41)
• Shared buffers vs large files Francisco Reyes (21:48)
• Is vacuum full lock like old's vacuum's lock? Francisco Reyes (21:50)
• Re: Is vacuum full lock like old's vacuum's lock? Doug McNaught (21:51)
• storing intermediate results in recursive plpgsql functions Fran Fabrizio (21:55)
• Networking support for postgres isn't working. Antonio Gennarini (22:01)
• Re: Is vacuum full lock like old's vacuum's lock? Francisco Reyes (22:21)
• Re: Shared buffers vs large files Francisco Reyes (22:23)
• Re: storing intermediate results in recursive plpgsql functions Tom Lane (22:24)
• Running under Cygwin... Randy Widell (22:52)
• PostgreSQL favicon.ico Greg Sabino Mullane (23:26)
• Re: terminal with horizontal scrollbar Manuel Sugawara (23:46)
• Re: Shared buffers vs large files Glen Parker (23:57)

March 2, 2002

• PostgreSQL profiling tools Martin Dillard (00:10)
• oids vs. serial question Alex Rice (00:10)
• Re: Shared buffers vs large files Neil Conway (00:13)
• Re: Newbie question re SQL Lee Harr (00:38)
• Re: pg documentation paul simdars (00:59)
• Re: PostgreSQl or BerkeleyDB ?? Jeff Davis (01:34)
• UPDATE with value from another table Thomas T. Thai (05:08)
• Re: UPDATE with value from another table Oliver Elphick (06:20)
• Re: Is vacuum full lock like old's vacuum's lock? Francisco Reyes (06:23)
• Re: UPDATE with value from another table Thomas T. Thai (06:29)
• Defined C function gives nondeterministic results Patrick L. Nolan (07:55)
• ERD or UML tool thiemo (08:27)
• alter table question Medi Montaseri (08:43)
• Which administration software to use W. Luijk (10:41)
• where is my bottleneck? Ben (11:01)
• Re: Shared buffers vs large files Holger Marzen (11:15)
• Re: Newbie question re SQL john (12:52)
• Re: where is my bottleneck? Jeff Fitzmyers (14:44)
• Re: Aborting transaction on error Greg Sabino Mullane (14:52)
• Re: PostgreSQL favicon.ico Justin Clift (15:01)
• ERROR: Conditional NOTIFY is not implemented Davi Leal (15:30)
• HELP!.. "semget(key=2, num=17, 03600) failed: No space left on device" Serkan Bektaş (15:55)
• Re: ERROR: Conditional NOTIFY is not implemented Tom Lane (17:29)
• Re: [GENERAL] where is my bottleneck? Ben (17:40)
• Re: passwd / pg_hba.conf Bruce Momjian (17:40)
• Re: Clues about tables fileformat Bruce Momjian (18:18)
• Re: Is vacuum full lock like old's vacuum's lock? Andrew Sullivan (18:20)
• Re: Is vacuum full lock like old's vacuum's lock? Tom Lane (18:55)
• Re: help with getting index scan Masaru Sugawara (22:28)
• Help with JDBC and OID Campano, Troy (23:19)
• Multiple DB Servers on 1 machine Campano, Troy (23:21)

March 3, 2002

• Solaris x86 vs Linux vs *BSD for PostgreSQL? Trapper (01:14)
• Error with JDBC after drop table Troy.Campano (02:10)
• Re: Error with JDBC after drop table Troy.Campano (02:24)
• Maximum size of identifiers names ? fhallais (07:18)
• pg_restore ignore existing function Thomas T. Thai (07:53)
• Re: Maximum size of identifiers names ? Martijn van Oosterhout (11:06)
• PostgreSQL under Cygwin... Randy Widell (15:41)
• How do I pass the -i option during boot time? geotronix (16:44)
• Optimizing Pl/PGSQL stored proc (nested conditionals)... Sean Chittenden (18:09)
• Re: oids vs. serial question Patrick Welche (18:32)
• Explain SQL feature Regis (18:39)
• Re: Newbie question re SQL Lee Harr (20:07)
• error montfort (20:08)
• Re: oids vs. serial question knut.suebert (22:28)
• Re: install psql 7.1.3 - rh6.2 - libreadline.so.4 Ernesto E. Gutierrez (22:33)
• PGSTAT Error from Postmaster Tim Finch, FosterFinch Ltd (22:35)
• April 1 Andrew Bartley (22:57)

March 4, 2002

• Re: Clues about tables fileformat Miguel A. Arévalo (00:12)
• Re: Clues about tables fileformat Bruce Momjian (00:18)
• April 1 Andrew Bartley (01:05)
• Conditional Statement Samik Raychauhduri (01:13)
• Re: April 1 Tom Lane (02:20)
• Re: Conditional Statement Samik Raychaudhuri (03:08)
• Re: Conditional Statement Medi Montaseri (03:27)
• Re: Conditional Statement Doug McNaught (04:33)
• Re: help with getting index scan Thomas T. Thai (06:33)
• Re: ERD or UML tool Gavin M. Roy (07:31)
• copying database? hubert depesz lubaczewski (11:05)
• Re: Aborting transaction on error Mark Rae (11:28)
• Arrays in pgsql Martina Mostert (11:28)
• Re: April 1 Raymond O'Donnell (11:35)
• Re: copying database? hubert depesz lubaczewski (11:55)
• postgre performance question Ioannis (11:57)
• Re: alter table question Gregory Wood (12:21)
• Re: oids vs. serial question Gregory Wood (12:32)
• Re: SQL question - duplicate records from join Raymond O'Donnell (12:51)
• Re: Arrays in pgsql Gregory Wood (12:52)
• Re: copying database? Holger Marzen (13:26)
• Re: postgre performance question Doug McNaught (13:46)
• Re: postgre performance question Ioannis Kappas (13:56)
• Re: postgre performance question Ioannis (14:07)
• Re: improving performance of UNION and ORDER BY Chris Gamache (14:21)
• backend closed Charles (14:25)
• Re: postgre performance question Doug McNaught (14:35)
• Re: Arrays in pgsql Martina Mostert (14:57)
• Re: postgre performance question Ioannis Kappas (14:58)
• Re: Arrays in pgsql Tom Lane (15:18)
• Re: descending index Tom Lane (15:28)
• Re: postgre performance question Doug McNaught (15:34)
• Re: backend closed Doug McNaught (15:37)
• Re: improving performance of UNION and ORDER BY Darren Ferguson (15:37)
• Allow all users with password Troy.Campano (15:41)
• Re: backend closed Tom Lane (15:45)
• Re: [GENERAL] Which trigger execute which function? Tom Lane (15:51)
• counting words in a text or char varying field Thomas T. Thai (15:59)
• Re: SQL question - duplicate records from join Stephan Szabo (16:22)
• mail tony (16:22)
• Re: improving performance of UNION and ORDER BY Stephan Szabo (16:25)
• Re: Which trigger execute which function? Stephan Szabo (16:26)
• Re: passwd / pg_hba.conf Patrick Welche (16:49)
• Re: descending index Jean-Michel POURE (16:59)
• FREE ERD TOOL for POSTGRES ??? Eric Webber (17:01)
• Re: Networking support for postgres isn't working. Luciano Miguel Ferreira Rocha (17:07)
• Re: PostgreSQL favicon.ico Luciano Miguel Ferreira Rocha (17:11)
• Migration problem - serial fields Rick (17:24)
• Re: [GENERAL] Which trigger execute which function? Joe Conway (17:28)
• Re: vsnprintf and 64-bit Solaris 7 (was: abnormal exits) Tom Lane (17:53)
• Re: pgaccess Oliver Elphick (18:05)
• Migration problem - serial fields Rick Anderson (19:07)
• Re: SQL question - duplicate records from join Jeff Eckermann (20:27)
• PL/pgSQL Syntax Problem Hubert Palme (20:34)
• Re: storing intermediate results in recursive plpgsql functions Fran Fabrizio (20:39)
• Re: Help with SET TRANSACTION in a function Stephan Szabo (20:45)
• Temp Tables mdb (20:48)
• trying to upgrade and keep large object IDs intact... Ron Snyder (20:49)
• Re: SQL statement : list table details Dino Hoboloney (21:23)
• Re: Help with SET TRANSACTION in a function Oliver Elphick (21:35)
• Re: libcrypt.so.2 Luciano Miguel Ferreira Rocha (21:38)
• Changes to NOW() in 7.2? Hunter Hillegas (21:41)
• lo_open problems James Leigh (21:42)
• Validating Whole Numbers Krog, Kenneth (21:44)
• Re: libcrypt.so.2 Darren Ferguson (21:46)
• Re: storing intermediate results in recursive Culley Harrelson (21:50)
• Listing Numbers Brian Avis (22:07)
• Re: postgre performance question Andrew Bartley (22:19)
• index item size 4496 exceeds maximum 2713 Jon Hassen (22:19)
• Re: SQL statement : list table details Oliver Elphick (22:30)
• Re: Validating Whole Numbers Jean-Luc Lachance (22:31)
• Re: counting words in a text or char varying field Greg Sabino Mullane (22:50)
• What are functional indices good for? Patrick L. Nolan (22:51)
• Re: Listing Numbers Jean-Luc Lachance (22:56)
• Re: trying to upgrade and keep large object IDs intact... Tom Lane (23:01)
• Re: [INTERFACES] PL/pgSQL Syntax Problem Tom Lane (23:03)
• Re: storing intermediate results in recursive plpgsql functions Tom Lane (23:05)
• Re: lo_open problems Tom Lane (23:10)
• Fast, indexed bulk inserts Steve Atkins (23:18)
• Re: Changes to NOW() in 7.2? Tom Lane (23:22)

March 5, 2002

• Re: Conditional Statement Lee Harr (00:54)
• Re: Migration problem - serial fields Lee Harr (00:57)
• Slow in VB Grid with PG PG (01:22)
• Re: Validating Whole Numbers Greg Sabino Mullane (02:31)
• Re: Help with SET TRANSACTION in a function otisg (03:05)
• FATAL 2: RelationPutHeapTuple: failed to add tuple Andrew Bartley (03:22)
• Re: Help with SET TRANSACTION in a function Stephan Szabo (04:05)
• Re: [ADMIN] password change... Sean Chittenden (04:16)
• Re: Help with SET TRANSACTION in a function Darren Ferguson (04:23)
• Re: Help with SET TRANSACTION in a function otisg (04:49)
• Re: oids vs. serial question Sean Chittenden (05:20)
• Re: oids vs. serial question Tom Lane (05:43)
• Re: oids vs. serial question Sean Chittenden (05:45)
• Re: oids vs. serial question Andrew Snow (05:48)
• Re: FATAL 2: RelationPutHeapTuple: failed to add tuple Tom Lane (05:49)
• Re: Help with SET TRANSACTION in a function Stephan Szabo (06:15)
• Compiling problems thiemo (06:33)
• Re: Slow in VB Grid with PG Jason (07:59)
• vacuum statistics Ulrich Wisser (08:02)
• The most efficient way to put this? Arsalan Zaidi (10:11)
• System Tables Query John Bell (10:44)
• Re: The most efficient way to put this? Marc Polatschek (11:23)
• FATAL 2: open of pg_clog error Bjoern Metzdorf (12:02)
• Re: The most efficient way to put this? Jean-Michel POURE (12:58)
• Re: The most efficient way to put this? rolf.ostvik (12:58)
• Re: Newbie question re SQL Bruno Wolff III (13:45)
• Re: pg_dumpall storing multiple copies of DB's? Bill McGonigle (14:25)
• SQL and parse errors Johnson, Shaunn (14:57)