Re: [GENERAL] Re: Is PostgreSQL ready for ...

1999-11-22 Thread Lincoln Yeoh
At 01:18 AM 23-11-1999 -0500, Bruce Momjian wrote: >> If the priorities include stability and reliability, that's what you get. >> If the priorities are features at any cost, you get junk. >> >> Though Open Source projects are less susceptible to featuritis, they're far >> from immune. Trouble i

Re: [GENERAL] Re: Is PostgreSQL ready for ...

1999-11-22 Thread Bruce Momjian
> If the priorities include stability and reliability, that's what you get. > If the priorities are features at any cost, you get junk. > > Though Open Source projects are less susceptible to featuritis, they're far > from immune. Trouble is many PHBs only compare stuff feature by brochure > fea

Re: [GENERAL] Re: Is PostgreSQL ready for ...

1999-11-22 Thread Lincoln Yeoh
At 08:51 PM 22-11-1999 -0600, [EMAIL PROTECTED] wrote: >tracking database). S, for my part, I now put my faith in a database >whose proponents do not face financial ruin if they tell you the truth. I >much >prefer a "Not yet implemented" message from the database, or a "this is >still a litt

[GENERAL] Flexability.

1999-11-22 Thread Jason
hi, With respect to the thread about is Pg ready for prime time. It obviously is. All of the DBs have there place. We at work started with Access, and now need to move to SQL Server (postgres if I can convince them); just because the company needs a quick fix and will have no DBA once I'm done

Re: [GENERAL] Re: Is PostgreSQL ready for mission criticalapplications?

1999-11-22 Thread The Hermit Hacker
On Mon, 22 Nov 1999, Kane Tao wrote: > The reason why opinions are so varied has alot to do with the expertise of > each person in relation to PostgreSQL and Linux. Often problems that are Ack, you know the discussion is going downhill when someone mentioned Linux *sigh* *big, friendly, Daemon

Re: [GENERAL] Re: Is PostgreSQL ready for ...

1999-11-22 Thread Kane Tao
Bah, no comment on Microsofts reliability :) But Oracle I have used extensively 7.x versions. I implicitly trust its reliability...except I heard of some probs with version 8 when it came out :) Cant imagine someone using the same version of the database for 35 years tho. By that time you would

Re: [GENERAL] Re: Is PostgreSQL ready for mission criticalapplications?

1999-11-22 Thread Kane Tao
The reason why opinions are so varied has alot to do with the expertise of each person in relation to PostgreSQL and Linux. Often problems that are considered simple to resolve by some are very difficult for others. And sometimes problems are caused by actions that are done out of inexperince wi

[GENERAL] Re: Is PostgreSQL ready for ...

1999-11-22 Thread davidb
I think the problem is that nobody wants to say "Oh yeah, solid as a rock!" and then have someone die as a result of a database error. However, I have personally witnessed unrepeatable database errors in both MSSQL and Oracle. Those databases both have marketing departments widely touting them as

Re: [GENERAL] Re: Is PostgreSQL ready for mission criticalapplications?

1999-11-22 Thread The Hermit Hacker
Everyone has their own experiences, and difficulties...there are X platforms out there that PostgreSQL supports, multiply that by however many different hardware pieces that be thrown the standard box, and you'll get that many different experiences...would i use it in a mission critical box? yes

Re: [GENERAL] Re: Is PostgreSQL ready for mission critical applications?

1999-11-22 Thread The Hermit Hacker
On Mon, 22 Nov 1999, K.Tao wrote: > Well I do apologize as all my experiences are in the use of pre 6.5 > versions...I assume there have no longer been any reports of databases > having to be rebuilt or restored from tape from the way you are talking ;) > > Although I still feel that the level o

[GENERAL] performance

1999-11-22 Thread sciman-devd
i love postgresql very much and i want to use her in my application for customer but i could not know her precision performance compared with Oracle ,Sybase or Informix.who could tell me? Thanks in advance! -- »¶Ó­Ê¹Óà 21CN µç×ÓÓʼþϵͳhttp://www.21c

[GENERAL] X-Priority: 3

1999-11-22 Thread sciman-devd
i love postgresql very much and i want to use her in my application for customer but i could not know her precision performance compared with Oracle ,Sybase or Informix.who could tell me? Thanks in advance! -- »¶Ó­Ê¹Óà 21CN µç×ÓÓʼþϵͳhttp://www.21cn.

[GENERAL] Hers's one with the COPY command ...

1999-11-22 Thread The Hermit Hacker
I have a table created as: = DROP TABLE referer_raw_data; CREATE TABLE referer_raw_data ( counter_id int4, referer_url_domain varchar(256), referer_counter int4, date_added datetime default now()); = I wish to copy a stream of data to it

[GENERAL] European SANE conference needs speakers

1999-11-22 Thread Bruce Momjian
The 2nd International SANE Conference needs speakers. I was approached to give a talk on PostgreSQL, and have submitted a request to be a speaker. The conference is in Maastricht, The Netherlands. I realize many of you could also speak about PostgreSQL and are closer to the Netherlands. If you

[GENERAL] A Question about Large Object (fwd)

1999-11-22 Thread Vegeta
Hello. I'm trying to store a jpeg file into a table created as follow: CREATE TABLE vegeta ( nametext, photo oid ); I can insert a jpeg file from pgsql (locally) but I cannot do this from an application written in Visual Basic using an ODBC driver (V06-40-0006). I read p

Re: [GENERAL] Re: Is PostgreSQL ready for mission critical applications?

1999-11-22 Thread Thomas Good
On Mon, 22 Nov 1999, Stephen Birch wrote: > I have been surprised by the response to this question. I was hoping that the > responses would be more consistent, after all when software is unreliable it > is generally known by all users. Steve - I tried to post an answer earlier (and it was verb

Re: [GENERAL] Re: Is PostgreSQL ready for mission criticalapplications?

1999-11-22 Thread Stephen Birch
I have been surprised by the response to this question.  I was hoping that the responses would be more consistent, after all when software is unreliable it is generally known by all users. Although one would expect a subjective bias to the opinions, the answers provided in the thread are highly p

Fw: [GENERAL] Re: Is PostgreSQL ready for mission critical applications?

1999-11-22 Thread Kane Tao
From: K.Tao <[EMAIL PROTECTED]> To: The Hermit Hacker <[EMAIL PROTECTED]> Cc: Jochen Topf <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, November 22, 1999 12:38 PM Subject: Re: [GENERAL] Re: Is PostgreSQL ready for mission critical applications? > Well I do apologize as all my experience

Re: [GENERAL] What would be a good way to append some text to the end of a text field?

1999-11-22 Thread Wim Aarts
Sorry Ross, I replied to early, the second example covers it.Oops Wim. "Ross J. Reedstrom" wrote: > On Mon, Nov 22, 1999 at 02:45:04PM +0100, Wim Aarts wrote: > > > > Now I use php3 to read the text from the database then I append some > > text to it and finaly I do an update on the text f

Re: [GENERAL] What would be a good way to append some text to the end of a text field?

1999-11-22 Thread Wim Aarts
Thanks Ross, Sorry I didn't come with an example but I meant something like: test=> create table test_text (word_id int, words text); CREATE test=> insert into test_text values (1, 'some text'); INSERT 684150 1 test=> UPDATE test_text SET words = words + 'some more text' WHERE word_id = 1; Res

[GENERAL] Rule plan string to big, HELP!

1999-11-22 Thread J. Roeleveld
Hi, I keep running into problems with: ERROR: DefineQueryRewrite: rule plan string too big. Does anyone have any insights into this? And how to fix this? Hoping for help, Joost Roeleveld ps. I am willing to post _all_ Create-queries I use if anyone thinks he/she can fix it in my case.

Re: [GENERAL] What would be a good way to append some text to the end of a text field?

1999-11-22 Thread Ross J. Reedstrom
On Mon, Nov 22, 1999 at 02:45:04PM +0100, Wim Aarts wrote: > > Now I use php3 to read the text from the database then I append some > text to it and finaly I do an update on the text field. > Is it possible to use an SQL statement to do this directly in the > database? > Like this? test=> crea

[GENERAL] drop/rename table and transactions

1999-11-22 Thread Jaco de Groot
Hi, Every now and then I get the following error: cannot write block 0 of tablename [username] blind If this happens, all my database connections get this error when trying to access the database and I need to restart postgresql. The problem causing this error needs to be something like this:

[GENERAL] Rule plan string to big, HELP!

1999-11-22 Thread J. Roeleveld
Hi, I keep running into problems with: ERROR: DefineQueryRewrite: rule plan string too big. Does anyone have any insights into this? And how to fix this? Hoping for help, Joost Roeleveld ps. I am willing to post _all_ Create-queries I use if anyone thinks he/she can fix it in my case.

[GENERAL] What would be a good way to append some text to the end of a text field?

1999-11-22 Thread Wim Aarts
Now I use php3 to read the text from the database then I append some text to it and finaly I do an update on the text field. Is it possible to use an SQL statement to do this directly in the database? Thanks Wim. I use: Posgresql 6.5.3 Linux 5.2 PHP3 begin:vcard n:Aarts;Wim tel;cell:06-2059