Re: [GENERAL] v7.4 Beta 1 Bundle Available for Testing ...

2003-08-10 Thread Robert Treat
On Wed, 2003-08-06 at 11:17, scott.marlowe wrote: > On 6 Aug 2003, Robert Treat wrote: > > > On Tue, 2003-08-05 at 20:18, Dann Corbit wrote: > > > > For me, I can only find these directories: > > > ftp://ftp8.us.postgresql.org/pub/pgsql/source/v7.4/ > > > ftp://ftp8.us.postgresql.org/pub/postgres

Re: [GENERAL] 7.3.3 behaving differently on OS X 10.2.6 and FreeBSD 4.8-STABLE

2003-08-10 Thread culley harrelson
That's a guess that doesn't really explain why it'd work under one OS and not under another. Are the two versions of Postgres configured the same? I suppose they could be configured differently. I don't know how to investigate this. It isn't really a problem for me-- just strange. culley --

[GENERAL] Moving from MySQL

2003-08-10 Thread Simon Windsor
Hi   I am sorry for mailing this list directly, but I am planning to migrate a web application from MySQL to Postgres. I am aware of a number of applications to help in this process, ie my2pg, etc. The biggest stumbling block I face is replication.   What facilities exist within Postgres to r

[GENERAL] dumbheaded SQL question (probably join or subselect) - longish

2003-08-10 Thread Karsten Hilbert
Dear all, for some reason I just cannot get my brain wrapped around the required syntax for the following. I think I need to either use a join or subselect(s): Situation: -- I have two tables (simplified here) for an international medical office application (www.gnumed.org): create table

[GENERAL] Nesting Groups

2003-08-10 Thread Raymond
Utilizing Postgres 7.3.3 on RH80. Unable to nest groups; attempting the following: ALTER GROUP "}" ADD USER ""; ALTER GROUP "}" ADD GROUP ""; ALTER GROUP "}" ADD ""; Any work-around or something I am missing? Raymond ---(end of broadcast)--

Re: [GENERAL] postmaster(s) have high load average

2003-08-10 Thread Martijn van Oosterhout
Have you run VACUUM and/or VACUUM FULL and/or ANALYZE recently? On Thu, Aug 07, 2003 at 05:44:05PM -0600, Chris Webster wrote: > I have one process which writes a single float into 300 columns once per > second. I then run 4 process, from remote computers, to query a small > subset of the lates

[GENERAL] postgres+daemontools

2003-08-10 Thread Kolus Maximiliano
Title: postgres+daemontools     I'm about to install postgres on a box that has daemontools on it and I would like to use it. Is there anybody here already running postgres from daemontools? Is it advisable? Do you have any problems or issues I should took care before trying it?    

Re: [GENERAL] unexpected chunk number

2003-08-10 Thread Eric Anderson Vianet SAO
I tried setting enable_indexcan off and got same error: dump the contents of table tbdmovimento pg_dump: dumping out triggers pg_dump: dumping out rules pg_dump: creating TABLE tbdmovimento pg_dump: restoring data for table tbdmovimento pg_dump: dumping out the contents of table tbdmovimento

Re: [GENERAL] dumbheaded SQL question (probably join or subselect)

2003-08-10 Thread Karsten Hilbert
UNION. Duh. I knew why I wrote to this list :-) Thanks Mike. Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? ht

Re: [GENERAL] Anomaly with SUM().

2003-08-10 Thread Dann Corbit
/* ** ** Not a surprise, to them that knows: ** */ #include #include #include #define A_LEN 500 static float foo[A_LEN]; static double bar[A_LEN]; int main (void) { long i; double d; float f; srand((unsigned)(double)time(NULL)); for (i = 0; i < A_LEN; i++) { d = rand ()