Re: [GENERAL] Mailing list defective ?

2000-03-12 Thread Geoff Russell
On Sun, 12 Mar 2000, Johann [iso-8859-1] Höchtl wrote: Hi! I subscribed to the pgsql mailing-list digest version. But since friday i don't get the digest but every single mail. For me, this is very annoying ! Ditto, Geoff Russell - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

[GENERAL] Date problem

2000-03-12 Thread edNET System Admin
Hi, I'm trying to do something with dates which is proving to be a bit tricky. I'm trying to get the current "date" and add 3 days to this. I've tried: $date = "(now::date) + ('3 days'::interval)"; DBD::Pg::st execute failed: ERROR: parser: parse error at or near "3" ... and : $date =

Re: [GENERAL] Can I use PostGreSQL on an 80 user system?

2000-03-12 Thread Tatsuo Ishii
I am planning to use PostGreSQL to upgrade an existing Foxpro system to client/server. My question is what sort of hardware will I need to get a good response time from the system ? There are around 80 PC's networked together, running Windows and I plan to run PostGreSQL on a top of the

Re: [GENERAL] Mailing list defective ?

2000-03-12 Thread Peter Ai
Me too,can anyone do something please? - Original Message - From: "Johann Höchtl" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 13, 2000 8:31 AM Subject: [GENERAL] Mailing list defective ? Hi! I subscribed to the pgsql mailing-list digest version. But since friday i

[GENERAL] RE: Stress Test Postgresql on freebsd

2000-03-12 Thread Thomas Wong
Hi, May I know how to run a stress test on the postgresql on freebsd and MS-SQL7 on WinNT. Any software (preferbably free one) can does above mentioned thing. I need data/statistic for comparison purposes. Thanks Regards, Thomas Wong __ Do You

Re: [GENERAL] Mailing list defective ?

2000-03-12 Thread Chris Linstruth
The listmanager should do this for everyone who was subscribed to the digest version, but send mail to [EMAIL PROTECTED] with the following body: set pgsql-general digest [EMAIL PROTECTED] end The fourth (email address) field is optional if your From: header is set to the address you're

[GENERAL]

2000-03-12 Thread Robert J Carter
set digest

Re: [GENERAL] Date problem

2000-03-12 Thread Ross J. Reedstrom
On Sun, Mar 12, 2000 at 09:40:43PM -0500, Alex Pilosov wrote: now() is a function, and you should use it as now() -alex also, the magic constant 'now' might work: it needs the tics as well. Ross -- Ross J. Reedstrom, Ph.D., [EMAIL PROTECTED] NSBRI Research Scientist/Programmer Computer

[GENERAL] Re: alter table

2000-03-12 Thread Raigo Lukk
Hi alter table tmp add column last text; I had this same problem, turned out that PostgreSQL don't have this feature :-( So only way is: DROP TABLE and then again CREATE TABLE with all the fields you need. Raigo