Re: [GENERAL] Random via Subselect or Temporary Table

2003-08-08 Thread Tom Lane
"Thomas T. Thai" <[EMAIL PROTECTED]> writes: > CREATE TEMPORARY TABLE t1 AS SELECT catnum, title, random() AS r FROM > randtest; > CREATE TEMPORARY TABLE t2 AS SELECT catnum, max(r) AS mr FROM t1 GROUP BY > catnum; > SELECT t1.catnum, t1.title, t1.r FROM t1, t2 WHERE t1.catnum = t2.catnum > AND t1.

Re: [GENERAL] crashing Xeon?

2003-08-08 Thread Hubert Fröhlich
Hi Joshua What version of the kernel? If you are not running 2.4.20 or above you could have issues. There is issues with certain ethernet cards where the system will "go to sleep". There are also issues with the EXT3 filesystem that can cause ugly things. umm, 2.4-19, as distributed by SuSE 8.1.

Re: [GENERAL] Could not receive data from server

2003-08-08 Thread Amin Abdulghani
Compiling postgres client with -D_REENTRANT seems to remove this problem. It seems to have been a thread issue with webware (and more specfically errno associated the pqReadData). On a side note, I noticed that the configure.in for 7.2.1 doesnt seem to have any option for compiling with the ab

Re: [GENERAL] One table in two different databases

2003-08-08 Thread Gregory S. Williamson
Perhaps: dblink - Allows remote query execution by Joe Conway <[EMAIL PROTECTED]> This is under the contrib directory in your source distribution. I haven't done much with it, but it seems to allow access to tables not in the current database. HTH, Greg Williamson -Origina

Re: [GENERAL] [ADMIN] Call to undefined function: pg_connect()

2003-08-08 Thread Gregory S. Williamson
I don't have a clue about which is which, but I bet providing some dates (ls -l) would help figuring out which is the most recent vs. oldest) ... might provide helpful information to people who know more about compiling this beast. Greg Williamson -Original Message- From: shreedhar [

Re: [GENERAL] [webmaster] Database Infos

2003-08-08 Thread Bruce Momjian
See the documentation section "Monitoring Disk Space". Also, you are better off asking in one of the mailing lists. --- =?iso-8859-1?Q? Markus=20Sch=FCler ?= wrote: [ text/html is unsupported, treating like TEXT/PLAIN ] >