Re: [GENERAL] USA Disaster

2001-09-11 Thread Lamar Owen
On Tuesday 11 September 2001 02:47 pm, Bruce Momjian wrote: > Tom Lane is somewhere away from home in the US so he is already affected > because he can't return home. He was supposed to return tomorrow, but > that is now uncertain. I call his home and left a message. Well, the PostgreSQL projec

Re: [GENERAL] Ridicolus Postgresql review

2001-09-11 Thread Alex Pilosov
On 11 Sep 2001, Gunnar [iso-8859-1] Rønning wrote: > * Peter Eisentraut <[EMAIL PROTECTED]> wrote: > > | server. PostgreSQL supports both of these things just fine. A whole > | 'nother thing is the ability to return result sets from functions. > | > | OK, other vendors may call the latter for

Re: Fwd: Re: [GENERAL] unicode in 7.1

2001-09-11 Thread Culley Harrelson
Ack! I guess I am hitting this problem I had my database rebuilt to use UNICODE encoding. Data now appears correctly in pgsql but not when filtered through JDBC. Unfortunately Im using the open source DbConnectionBroker connection pooling object and I have to dig into this to apply the

Re: [GENERAL] USA Disaster

2001-09-11 Thread Lamar Owen
On Tuesday 11 September 2001 01:51 pm, Manuel Cabido wrote: > Can you give us a brief of what really happened out there? How many > people have died? What is now the prevailing condition of the place? Had > there been leads as to the motive of the attacks? See www.cnn.com, www.msnbc.com, www.

Re: [GENERAL] Ridicolus Postgresql review

2001-09-11 Thread Mitch Vincent
> That's not nonsense at all, you can't just go around and redefine the > language used in the database world at your own whims. "Stored Procedure".. Hmm, that seems to me that the definition of that would be "a procedure that's stored somewhere". When talking about stored procedures and database

Re: [GENERAL] USA Disaster

2001-09-11 Thread Hunter Hillegas
The short answer is that most of your questions are still unknowns. Both of the World Trade Center towers have collapsed after being hit by hijacked passenger aircraft. 50,000 people work in the towers but there is no estimated casualty figures. Another hijacked passenger plane crashed into the

Re: [GENERAL] Ridicolus Postgresql review

2001-09-11 Thread Gunnar Rønning
* Peter Eisentraut <[EMAIL PROTECTED]> wrote: | server. PostgreSQL supports both of these things just fine. A whole | 'nother thing is the ability to return result sets from functions. | | OK, other vendors may call the latter for "stored procedures", but that is | terminological nonsense. An

Re: [GENERAL] USA Disaster

2001-09-11 Thread Lamar Owen
On Tuesday 11 September 2001 12:15 pm, Carlos Felipe Zirbes wrote: > Hope none of us in this list has been affected by that terrorist act. Unfortunately, everyone in the US will be directly affected by this. Some are just more directly affected than others. :-( Hopefully no one on this list wi

Re: Fwd: Re: [GENERAL] unicode in 7.1

2001-09-11 Thread Barry Lind
Culley, With out more details of your setup, I can't give you a complete answer. But check out the info at: http://lab.applinet.nl/postgresql-jdbc/#CharacterEncoding for a brief discussion of what I believe is your problem. There has also been a number of discussions on this on the pgsql-j

[GENERAL] Installation location of Perl and Python modules

2001-09-11 Thread Peter Eisentraut
I need a user poll regarding a PostgreSQL 7.2 development issue. In what follows I only speak of Perl, but you may substitute Python almost everywhere. There have been complaints that the Perl module automatically installs itself under /usr/lib/perl5, even if the installer is not the root user a

Re: [GENERAL] How to make a REALLY FAST db server?

2001-09-11 Thread Steve Wolfe
> Tunning is somewhat of a black art to get the right balance. If you have to > make a choice, buy fewer processors, faster disks, and as much RAM as the > board will handle. Wow. I'd buy more RAM and processors, and maybe skimp a *little* on the disks. The RAID array in my machine is made u

Re: [GENERAL] Ridicolus Postgresql review

2001-09-11 Thread Peter Eisentraut
Gunnar Rønning writes: > I can't find anything in the documentation in PostgreSQL on how to make > a stored procedure return a result set. AFAIK it cannot and then it is not > really fair to claim that pgsql has stored procedures. There seems to be a rather narrow view of what a stored procedure

Re: [GENERAL] Ridicolus Postgresql review

2001-09-11 Thread Gunnar Rønning
* "Andrea Aime" <[EMAIL PROTECTED]> wrote: | | If you want to get angry, take a look at: | " However, unlike most commercial databases, users do not have | the ability to create their own stored procedures" (what?) I can't find anything in the documentation in PostgreSQL on how to make a sto

Re: [GENERAL] a plpgsql documentation and samples

2001-09-11 Thread J.H.M. Dassen (Ray)
Dr. Evil <[EMAIL PROTECTED]> wrote: > pl/pgsql doesn't seem to be very well documented. It would be cool if it > were better documented, or if there were a tutorial. Have you had a look at the materials at http://www.brasileiro.net/postgres/' ? Ray -- I keep pitching my epic space oper

Re: [GENERAL] How to make a REALLY FAST db server?

2001-09-11 Thread Randy Hall
Indeed, there are applications where this is true. Postgres will try to keep as much in the buffers as possible. You always have to take your application into account when tuning the database. Your case where the database may fit entirely in RAM is quite different from a server holding many gig

Re: [GENERAL] How to make a REALLY FAST db server?

2001-09-11 Thread Colin 't Hart
"Shaun Thomas" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > - Disk: SCSI Raid 1+0 > > To really eek out as much speed as possible here, you'll want 10k RPM > Ultra-160 Fibre Channel SCSI drives with a dedicated hardware raid > controller. If have more rea

Re: [GENERAL] a plpgsql documentation and samples

2001-09-11 Thread Dr. Evil
pl/pgsql doesn't seem to be very well documented. It would be cool if it were better documented, or if there were a tutorial. It would be even cooler if there were a pl/pgsql library, and also a library of C language functions that people could use. However, in the meantime, people on this lis

[GENERAL] a plpgsql documentation and samples

2001-09-11 Thread Jefim Matskin
There can I find a good/any documentation and samples for plpgsql? Thanks. Jefim Matskin - Senior SW engeneer Sphera Corporation Tel: +972.3.613.2424 Ext:104 mailto:[EMAIL PROTECTED] http://www.sphera.com/ ---(end of br