Re: [GENERAL] PL/java?

2001-09-04 Thread Randal L. Schwartz
> "Alex" == Alex Knight <[EMAIL PROTECTED]> writes: Alex> You did not read what I wrote very well. First, I said that mod_perl was Alex> slower than "most any j2ee application". If you knew what j2ee was, Alex> you'd know that it's generally limited to server-side internet apps Alex> like ser

Re: [GENERAL] [WAY OT] Re: PL/java?

2001-09-04 Thread Alex Knight
I'm interested to see the results, Cheers. -Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 9:16 AM To: Lincoln Yeoh Cc: Gunnar Ronning; Alex Knight; Alex Pilosov; [EMAIL PROTECTED] Subject: Re: [GENERAL] [WAY OT] Re: PL/java? This is

Re: [GENERAL] PL/java?

2001-09-04 Thread Alex Knight
Python is a great language too. For scripts, I tend to write more python scripts than perl these days, simply because python better suits my needs and the base class library seems larger than perl's after install, not that adding libs aren't easy. But I can write compact scripts without cryptoblin

Re: [GENERAL] PL/java?

2001-09-04 Thread Alex Knight
Hi Gilles, You did not read what I wrote very well. First, I said that mod_perl was slower than "most any j2ee application". If you knew what j2ee was, you'd know that it's generally limited to server-side internet apps like servlets, jsps, etc... Not to mention, I do try to give perl credit wher

Re: [GENERAL] upgrade from 7.1.2 to 7.1.3 and uh, where are my

2001-09-04 Thread Tom Lane
Jerry Asher <[EMAIL PROTECTED]> writes: > How do I tell postgres where to find my databases? A -D switch when starting the postmaster is sufficient. If you are not using one then the configure-time default is assumed. Is it possible that you built 7.1.3 with a different default than 7.1.2 had,

Re: [GENERAL] upgrade from 7.1.2 to 7.1.3 and uh, where are my databases?

2001-09-04 Thread Tom Lane
Jerry Asher <[EMAIL PROTECTED]> writes: > I upgraded from 7.1.2 to 7.1.3. Upon starting 7.1.3, I tried to use psql > to access my databases. But whether I use psql -U foo, or psql -d foo, I > am told that: >psql: FATAL 1: Database "foo" does not exist in the system catalog. Hm. What doe

[GENERAL] internet week article

2001-09-04 Thread Eric Kolve
http://www.internetweek.com/reviews01/rev090301.htm I would be most interested to here this lists response to the following paragraph. Though much of the specifics of the benchmark are left out, so tuning could very much of been an issue. Database performance is a key issue for most busines

[GENERAL] many junction tables

2001-09-04 Thread Eric Kolve
I was wondering if anyone has a solution to the following problem. I have a few tables similar to the following. person_table city_table company_table If I want to associate a person with a one or more cities. I need to create a city_persons table that contains just the primary keys of bo

Re: [GENERAL] upgrade from 7.1.2 to 7.1.3 and uh, where are my

2001-09-04 Thread Jerry Asher
At 07:17 AM 9/4/01, you wrote: >i upgraded from 7.1.2 to 7.1.3. upon starting 7.1.3, i tried to use psql >to access my databases. but whether i use psql -u foo, or psql -d foo, i >am told that: > > psql: fatal 1: database "foo" does not exist in the system catalog. > >when i examine /usr/loc

Re: [GENERAL] how do functional indices work?

2001-09-04 Thread Tom Lane
hubert depesz lubaczewski <[EMAIL PROTECTED]> writes: > let's assume i have table users which is (id int4, person_id int4) - pkey'ed > on id with index on person_id. > next i have table people (id int4, fullname text) with pkey on id. > there is a foreign key between the two tables on users.person

Re: [GENERAL] Unexpected Behavior Using a Rule With Multiple Actions (Long)

2001-09-04 Thread Tom Lane
"James F. Hranicky" <[EMAIL PROTECTED]> writes: > What I'd really like to do is this: > create rule homes_update as on update to homes where OLD.fspath != > NEW.fspath do instead > ( > update homes_table set record_expired = now() where fsname > = OLD.fsn

[GENERAL] upgrade from 7.1.2 to 7.1.3 and uh, where are my databases?

2001-09-04 Thread Jerry Asher
I upgraded from 7.1.2 to 7.1.3. Upon starting 7.1.3, I tried to use psql to access my databases. But whether I use psql -U foo, or psql -d foo, I am told that: psql: FATAL 1: Database "foo" does not exist in the system catalog. When I examine /usr/local/pgsql/data, it certainly looks as t

Re: [GENERAL] nested SQL with SPI

2001-09-04 Thread Tom Lane
Markus Wagner <[EMAIL PROTECTED]> writes: > this would mean that all result tables are kept in memory until the trigger > function exits? Until you do SPI_freetuptable or SPI_finish, yes, an SPI result sticks around. > What do you mean with "copy it and associated globals into locals", just the

Re: [GENERAL] Is it possible to default all number data to numeric type?

2001-09-04 Thread Jan Wieck
Pls Help Me wrote: > My company had a old program with written by Powerbuilder. It work > fine in MSSQL 6.5. > Now, my boss required to use another SQL server. Someone told me > PostgreSQL is totally free and powerful. I installed it in a Linux > machine (RedHat 7 + PostgreSQL 7.1.2), and transf

[GENERAL] Book "PostgreSQL" to be released in November 2001

2001-09-04 Thread Hartwig Jens
Dear colleagues and friens of PostgreSQL, I am pleased to be able to indicate to you the fact that I finished my book "PostgreSQL". The planned release date for the book is November this year. The book represents a comprehensive work manual about PostgreSQL. It treats all topics, important for t

Re: [GENERAL] Problem with numeric and operators

2001-09-04 Thread Oliver Elphick
DaVinci wrote: > Hi all. > > I have a problem with data type 'numeric'. If I have a field of type > 'numeric' (in this case 'foo') and execute next query: > > select * from table_example where foo > 2.45 > > I get error: > > ERROR: Unable to identify an operator '>' fo

[GENERAL] Problem with numeric and operators

2001-09-04 Thread DaVinci
Hi all. I have a problem with data type 'numeric'. If I have a field of type 'numeric' (in this case 'foo') and execute next query: select * from table_example where foo > 2.45 I get error: ERROR: Unable to identify an operator '>' for types 'numeric' and 'float8'

Re: [GENERAL] PL/java?

2001-09-04 Thread Adam Manock
After having seen this Perl / Java debate go back and forth... I can't help myself... The answer is Python !!! For the best middleware you're ever likely to integrate with Postgresql : http://www.zope.org To see its "enterprise scalability": http://www.zope.org/About To see it taking LOTS of h

Re: [GENERAL] PL/java?

2001-09-04 Thread Gilles DAROLD
Hi Alex, Saying that mod_perl is slower than any java apps is purely marketing for java. An other guy told me that one day, I just bench it to show him how java developper just talk marketing. So the result was that with small users the performance was the same and with many user mod_perl is real

[GENERAL] FOREIGN KEY: difference between NOT DEFERRABLE and INITIALLY IMMEDIATE

2001-09-04 Thread Gabriel Fernandez
Hi, What's the difference between NOT DEFERRABLE and INITIALLY IMMEDIATE for a FOREIGN KEY specification ? It seems they are both defining the same: the moment the constraint will be checked: the instant the statement is processed or the end of transaction. Thanks, Gabi :-)

Re: [GENERAL] SHOW

2001-09-04 Thread Stephan Bergmann
Hi Joe. > > Start up psql with the -E on the command line. Then do \d TABLE. This will > show you the actual SQL commands used by psql. Doesn't change nothing. > See the psql man page for more details. No hints to find there respective to the libpq's PQexec. Greetings Steve ---

[GENERAL] (no subject)

2001-09-04 Thread Giorgio Volpe
remove ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]