Re: [GENERAL] installing DBD::Pg without installing postgres

Michelle & John> Yes, that's exactly what I am trying to accomplish. I am setting up a network monitoring application for our support personnel, and I have multiple people all examining data that gets reported to a central database. So I didn't relish the idea of installing postgres on all of

[GENERAL] Problem with postgreSQL (number of backends)

Hi, i have problems with PostgreSQL 7.0.3 on a RedHat 6.2 System. Very often postgresql post me the following warning and error message. Warning: Unable to connect to PostgreSQL server: Sorry, too many clients already in /home/server/... PostgreSQL said: Unable to connect to server It seem

[GENERAL] IBM to buy Informix

IBM to buy Informix: http://news.cnet.com/news/0-1003-200-5705678.html?tag=st.it.9500.lthd -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be y

RE: [GENERAL] pg_dump failure: "handler procedure for language plpgsql not foun d"

Tom, Absolutely right! I suppose I could have figured that out if I had spent three days looking at it :-) I didn't find anything in the docs about assigning a sysid to a new user, so I just did a createuser and an UPDATE to pg_shadow to reset the sysid. If that is likely to cause a problem, plea

[GENERAL] indices are crashed after installation of rpm

hello all, we are running PostgreSQL 7.0.2 on Solaris 2.6,/x86 compiled by gcc 2.8.1. For installation Postgres on 70 Solaris-2.6 server we built packages (SVR4-style). The first time we installed Postgres everything was ok. But after a new installation of the package ( - same Postgres version!

[GENERAL] Performance: sql functions v. plpgsql v. plperl

Last night, I was doing some amateurish benchmarking and found that, contrary to my (admittedly uninformed) expectation, sql functions seem *slower* than plsql functions. Even for very simple things, like 'SELECT CASE WHEN $1 RETURN $1 ELSE $2 END' were slower than the plsql begin if $1 then

[GENERAL] Re: Re: BETWEEN clause

On Tue, 24 Apr 2001, Paul Tomblin wrote: > Quoting will trillich ([EMAIL PROTECTED]): > > > test=# create view its_really_the_same_thing as select true where 1 > > > between 1 and 3; > > > > > > test=# \d its_really_the_same_thing > > > ... > > > View definition: SELECT 't'::bool WHERE ((1 >= 1)

[GENERAL] Converting queries to upper case

Another question I am submitting my JDBC queries via HTML form. Is it best to convert the query to UPPER CASE with java script in the form when submitting it? Cheers Tony Grant -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html ---(end of

[GENERAL] Strange locale goings on

Hello, I am querying my French language data via JDBC. Accented caracters do not get returned. When I query via Webmin (Perl???) accents are just fine. Quid??? Cheers Tony Grant -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html ---(end

Re: [GENERAL] Re: BETWEEN clause

Quoting will trillich ([EMAIL PROTECTED]): > > test=# create view its_really_the_same_thing as select true where 1 > > between 1 and 3; > > > > test=# \d its_really_the_same_thing > > ... > > View definition: SELECT 't'::bool WHERE ((1 >= 1) AND (1 <= 3)); > > > > > > HTH, > > -- > > Joel Burt

Re: [GENERAL] Re: BETWEEN clause

On Tue, Apr 24, 2001 at 12:07:41AM -0400, Joel Burton wrote: > On Mon, 23 Apr 2001, Paul Tomblin wrote: > > > Is the "BETWEEN" clause inclusive or exclusive? ie if I say "WHERE > > latitude BETWEEN 45 and 55", will I get examples where the latitude equals > > 45 or not? Also, is "latitude BETWE

Re: [GENERAL] Var substitution in SELECT statements

On Mon, Apr 23, 2001 at 09:41:51PM -0400, Randall Perry wrote: > on 4/23/01 9:20 PM, Randall Perry at [EMAIL PROTECTED] wrote: > > > This works: > > $res = $conn->exec("select cust, contact, user_name, email from $t where > > user_name = a1a"); > > > > This doesn't: > > $c = "a1a"; > > $res =