[GENERAL] Non-english articles on the techdocs.postgresql.org website

2001-04-11 Thread Justin Clift
Hi all, I'm looking at the stats of the domains of the people who are visiting the techdocs website (these stats are publicly viewable at http://s3.thecounter.com/counter/2228050.vdomain) and noticing how many non-english speaking people are visiting the site's front page and then leaving. Any t

[GENERAL] PHP question

2001-04-11 Thread Michael Kretshkivsky
Hi all! I has work with WEB-DB under Linux earlier, where PHP was installed automatically and work excellent. But, at that time I must proceed to FreeBSD3.3 + Apache-1.3.9.+PHP4. Unfortunatelly, this distributive package PHP4 not support PostgreSQL. Where I can find PHP package for PostgreSQL 7.

[GENERAL] Re: personel appliactions?

2001-04-11 Thread Alessio Bragadini
Stan Brown wrote: > So, I was wandering if anyone knows wehre I could find a few small > applicationsUsing PostgreSQL as abckaends? I'm looking for. > > 1. CD/Music lirary management. gmmusic -- Alessio F. Bragadini[E

[GENERAL] memory usage and cache query

2001-04-11 Thread ochapiteau
My process in php submit about 1000 querys (in a while) like : "INSERT INTO table SELECT id from table2 where ..." This type of query for me does'nt require any memory in the php process (all to postgres process) is use pg_exec and pg_freeresult just after each query call. But when this script ru

Re: [GENERAL] JDBC and Perl compiling problems w/ postgresql-7.1rc4

2001-04-11 Thread Tony Grant
On 10 Apr 2001 16:38:28 -0700, Homayoun Yousefi'zadeh wrote: > For those of you looking for the compiled jar file > go to the bottom of following page ... Well thanks for that!!! Dreamweaver now sees the driver (placed in :Config:JDBC) and doesn't get upset when I test anymore using "Using driv

[GENERAL] Re: Very long running query

2001-04-11 Thread Konstantinos Agouros
On Tue, Apr 10, 2001 at 11:38:49AM -0400, Joel Burton wrote: > On 10 Apr 2001, Konstantinos Agouros wrote: > > > Hi, > > > > I have a query running for 97hours now and I am wondering if this can be made > > any faster. > > The Query is: > > insert into dailyreport select timestamp(date >'1-8-20

Re: [GENERAL] plpgsql -- arrays/temporary tables?

2001-04-11 Thread Anand Raman
hi I think create likeddl statements fal under the category of dynamic queries which plpgsql in its native state cant handl.. Try using EXECUTE to execute this query Hope this helps Anand On Wed, Apr 11, 2001 at 12:25:43AM -0400, Steven D. Arnold wrote: >The following function doesn't work when