[GENERAL] Re: [PHP-DB] Re: [SQL] a script that queries database periodically

2000-12-03 Thread Roberto Mello
Jason wrote: > > aolserver is a web/application server. PHP is a server-side scripting > language. Why exactly *should* it have a job scheduler? > > Some (such as myself) might also ask why should a web server have a job > scheduler, but that's a thread for a different list :) Because

[GENERAL] Re: [PHP-DB] Re: [SQL] a script that queries database periodically

2000-12-03 Thread Jason
On Mon, Nov 27, 2000 at 02:56:59PM -0700, Roberto Mello wrote: > > PHP does not have a scheduling facility? AOLserver (the web/application > server that powers AOL) has had such facility (and many many others for > db-backed websites) since 1995. ns_schedule_proc. > http://www.aolserv

[GENERAL] Re: a script that queries db periodically

2000-12-03 Thread Bernie Huang
Thank you for all your response. Not only do I benefit from your response, but hopefully others benefit as well. Thanks again. - Bernie begin:vcard n:Huang;Bernie tel;fax:(604)664-9195 tel;work:(604)664-9172 x-mozilla-html:TRUE org:Environment Canada;Standards and Technology Services adr:;;700

AW: [HACKERS] Re: [GENERAL] is it a bug?

2000-12-03 Thread Zeugswetter Andreas SB
> lpad and rpad never truncate, they only pad. > > Perhaps they *should* truncate if the specified length is less than > the original string length. Does Oracle do that? Yes, it truncates, same as Informix. Andreas

[GENERAL] Re: [HACKERS] is it a bug?

2000-12-03 Thread Thomas Lockhart
> ... it seems the "lpad", "rpad" don't work, > when I type: > select lpad('laser', 4, 'a'); > in psql, the result is still > 'laser', the same with 'rpad', > Is it a bug or I'm mis-understaning the lpad and/or rpad functions? A simple misunderstanding. The length argument is for the *total* leng

[GENERAL] Re: [HACKERS] Indexing for geographic objects?

2000-12-03 Thread selkovjr
Franck Martin wrote: > I have already created geographical objects which contains MBR(Minimum > Bounding Rectangle) in their structure, so it is a question of rewriting > your code to change the access to the cube structure to the MBR structure > inside my geoobject. (cf http://fmaps.sourceforge.n

[GENERAL] Failed regression tests with 7.0.3 on Windows NT 4.0

2000-12-03 Thread Christian Ullrich
Hello! I've just gotten PostgreSQL 7.0.3 to build and actually run under WinNT 4.0, and the regression tests show two problems: one probably minor in horology (I suppose there's a wrong time zone somewhere), and one probably major in alter_table. I attached the diff output. I'm not very pleased

[GENERAL] AW: [HACKERS] is it a bug?

2000-12-03 Thread Zeugswetter Andreas SB
> > ... it seems the "lpad", "rpad" don't work, > > when I type: > > select lpad('laser', 4, 'a'); > > in psql, the result is still > > 'laser', the same with 'rpad', > > Is it a bug or I'm mis-understaning the lpad and/or rpad functions? > > A simple misunderstanding. The length argument is for

[GENERAL] Re: Why PostgreSQL is not that popular as MySQL?

2000-12-03 Thread Mike Kenney
Raymond Chui <[EMAIL PROTECTED]> writes: > I am just start look at PostgreSQL for our Redhat Linux. > I am wonder why most of people choose MySQL in Linux > world rather than PostgreSQL? PostgreSQL has 15 years > history (I never know that before) which is much longer > than MySQL. Also PostgreSQ

Re: [HACKERS] Re: [GENERAL] PHPBuilder article -- Postgres vsMySQL

2000-12-03 Thread Don Baccus
At 12:39 PM 12/1/00 +0100, Frank Joerdens wrote: >Don Baccus wrote: >> >[ . . . ] >> Well, meanwhile I've gotten confirmation from folks in the PHP world >> (via an openacs forum) > >Which forum is that? I'm asking because I am currently trying to migrate >from PHP to Openacs, or integrate the t

[GENERAL] Re: [SQL] a script that queries database periodically

2000-12-03 Thread Roberto Mello
"Poul L. Christiansen" wrote: > > I was thinking of writing up a PHP script and put into crontab, which is > > somehow easier than a shell script, but PHP is an apache module, so I > > cannot execute PHP under crontab (it has to be executed in a browser > > right?). I guess a shell script is nec

[GENERAL] postgresql and Mandrake: no gist support?

2000-12-03 Thread Franck Martin
I'm using Mandrake 7.2 and I cannot find the files gist.h and rtree.h in the postgres-devel rpm. Does anyone knows where are they ? Cheers. Franck Martin Database Development Officer SOPAC South Pacific Applied Geoscience Commission Fiji E-mail: [EMAIL PROTECTED] Web site: http://www.sopac.org/

[GENERAL] Re: [SQL] a script that queries database periodically

2000-12-03 Thread Mathijs Brands
On Mon, Nov 27, 2000 at 10:44:39PM +0100, Poul L. Christiansen allegedly wrote: > I have a bash script in crontab with the following line: > "lynx -dump > http://127.0.0.1/postgres/myPhpFile.php>${currentDir}php_output.html" > > You can also just put that line directly into crontab. > > Poul L.

[GENERAL] large tuple

2000-12-03 Thread Kenneth Been
I set BLCKSZ to 32768, as described in FAQ question 4.6, and recompiled and reinstalled the system, and I am still getting the error "Tuple is too big: size 9588, max size 8140". Any ideas why that would be? Is there also something else I need to do? Thank you. Ken

[GENERAL] Your RDBMS Survey ...

2000-12-03 Thread The Hermit Hacker
A couple of days ago, one of our brethren noticed and pointed us to your survey asking which RDBMS we prefered/were using ... pride in our choice prompted alot of us to pop over to your site and register our vote ... when I put mine in, the results were at something like 1461 for PgSQL and now th

Re: Re[2]: [[GENERAL] Please vote for postgresql!!!]

2000-12-03 Thread The Hermit Hacker
we could all email them asking why they keep resetting it in favor of MySQL? :) On Sun, 3 Dec 2000, GH wrote: > On Mon, Dec 04, 2000 at 02:19:36PM +1100, some SMTP stream spewed forth: > > On Sun, Dec 03, 2000 at 09:20:51PM -0400, The Hermit Hacker wrote: > > > > > > just re-submit'd my vote

Re: Re[2]: [[GENERAL] Please vote for postgresql!!!]

2000-12-03 Thread GH
On Mon, Dec 04, 2000 at 02:19:36PM +1100, some SMTP stream spewed forth: > On Sun, Dec 03, 2000 at 09:20:51PM -0400, The Hermit Hacker wrote: > > > > just re-submit'd my vote ... maybe mycgiserver already has mysql installed > > and is only doing the vote to satisfy some ppl, but don't really wa

Re: Re[2]: [[GENERAL] Please vote for postgresql!!!]

2000-12-03 Thread Matt Beauregard
On Sun, Dec 03, 2000 at 09:20:51PM -0400, The Hermit Hacker wrote: > > just re-submit'd my vote ... maybe mycgiserver already has mysql installed > and is only doing the vote to satisfy some ppl, but don't really want to > install PgSQL? *raised eyebrow* The counter was reset to 450ish twice jus

Re: Re[2]: [[GENERAL] Please vote for postgresql!!!]

2000-12-03 Thread The Hermit Hacker
just re-submit'd my vote ... maybe mycgiserver already has mysql installed and is only doing the vote to satisfy some ppl, but don't really want to install PgSQL? *raised eyebrow* On Sun, 3 Dec 2000, GH wrote: > On Sun, Dec 03, 2000 at 04:14:48PM -0600, some SMTP stream spewed forth: > > looks

Re: [GENERAL] how to determine what a process is doing

2000-12-03 Thread Jan Wieck
Tom Lane wrote: > Alex Howansky <[EMAIL PROTECTED]> writes: > > Is there any way to determine exactly what a postgres process is > > doing at any time? The output from the ps command only shows "INSERT" or > > "SELECT", and not the full query string. > > There isn't any really nice solution at the

Re: [GENERAL] Unanswered questions about Postgre

2000-12-03 Thread Jan Wieck
Joe Kislo wrote: >Yes. There are certainly times when a transaction needs to be > ABORTed. However, there are many reasons why the database should not > abort a transaction if it does not need to. There is obviously no > reason why a transaction needs to be aborted for syntax errors. There

Re: Re[2]: [[GENERAL] Please vote for postgresql!!!]

2000-12-03 Thread GH
On Sun, Dec 03, 2000 at 04:14:48PM -0600, some SMTP stream spewed forth: > looks like it backfired...they've reset the graph Sheesh! Apparently *everybody* wants a recount. gh > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED]]On Behalf Of Bruno Dickhof

RE: Re[2]: [[GENERAL] Please vote for postgresql!!!]

2000-12-03 Thread R.Munden
looks like it backfired...they've reset the graph > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Bruno Dickhoff > Sent: Sunday, December 03, 2000 3:11 PM > To: Bill Barnes > Cc: [EMAIL PROTECTED] > Subject: Re[2]: [[GENERAL] Please vote for postgre

Re[2]: [[GENERAL] Please vote for postgresql!!!]

2000-12-03 Thread Bruno Dickhoff
Hello Bill, Sunday, December 03, 2000, 9:18:12 PM, you wrote: BB> Thanks for the tip. Looked good enough to sign up for an account. BB> The numbers I saw gave postgesql a significant lead. So, my appeal for voting did it's job! Before I posted the mail, mysql was leading at 1200 to 450 (and 430