Re: [GENERAL] Why PostgreSQL is better than other commerial softwares?

1998-12-17 Thread Oliver Elphick
Gregory Maxwell wrote: >except they cant tell me why a Dump/Restore from 6.3>6.4 wont work fore >some people. :) There were a lot of bugs in 6.3's pg_dump If this is a real problem, I have a back-ported pg_dump.c for 6.3.2, which can be used to dump out most of the data for the upgrade to 6

Re: [GENERAL] Why PostgreSQL is better than other commerial softwares?

1998-12-17 Thread Bruce Momjian
> On Thu, 17 Dec 1998, Bruce Momjian wrote: > > > Quick mailing list support > > except they cant tell me why a Dump/Restore from 6.3>6.4 wont work fore > some people. :) Often quick mailing list support? -- Bruce Momjian| http://www.op.net/~candle [EMAIL PROT

Re: [GENERAL] Why PostgreSQL is better than other commerial softwares?

1998-12-17 Thread Gregory Maxwell
On Thu, 17 Dec 1998, Bruce Momjian wrote: > Quick mailing list support except they cant tell me why a Dump/Restore from 6.3>6.4 wont work fore some people. :) /*Pardon my typing: Just switched to dvorak*/

[GENERAL] date_part bug?

1998-12-17 Thread Tim Williams
Greetings, When I run the following set of statements in postgres v6.4 (built on Debian Linux): create table tmp (v1 date, v2 datetime); insert into tmp values ('06-01-1999', '06-01-1999'); select date_part('month', v1) as m1, date_part('month', v2) as m2 from tmp; I see the following results:

Re: [GENERAL] Why PostgreSQL is better than other commerial softwares?

1998-12-17 Thread Hal Snyder
"Albert Chen" <[EMAIL PROTECTED]> writes: > Hi, > > I'm using FreeBSD and PostgreSQL 6.4. I tell my advisor > to try PostgreSQL, but he said:"Why PostgreSQL is better > than other commercial softwares? If you could give me > ten reasons, and I will give it a try." > Would anyone tell me what's

[GENERAL] what is WaitOnLock Error

1998-12-17 Thread Bryan White
I get this error: WaitOnLock: error on wakeup - Aborting this transaction What does it mean? Background: Running Postgres 6.4 on Linux. I have a process to handle subscription requests via email. We are running QMail and it directs the mail to this 'c' program I wrote. It parses the message an

Re: [GENERAL] Why PostgreSQL is better than other commerial softwares?

1998-12-17 Thread Howie
On Thu, 17 Dec 1998, Albert Chen wrote: > Hi, > > I'm using FreeBSD and PostgreSQL 6.4. I tell my advisor > to try PostgreSQL, but he said:"Why PostgreSQL is better > than other commercial softwares? If you could give me > ten reasons, and I will give it a try." > Would anyone tell me what's re

Re: [GENERAL] Why PostgreSQL is better than other commerial softwares?

1998-12-17 Thread Bruce Momjian
> Hi, > > I'm using FreeBSD and PostgreSQL 6.4. I tell my advisor > to try PostgreSQL, but he said:"Why PostgreSQL is better > than other commercial softwares? If you could give me > ten reasons, and I will give it a try." > Would anyone tell me what's reason you like Postgres. > Because it's fr

Re: [GENERAL] Why PostgreSQL is better than other commerial softwares?

1998-12-17 Thread Clark Evans
Albert Chen wrote: > I tell my advisor to try PostgreSQL, but he said: > "Why PostgreSQL is better than other commercial softwares? > If you could give me ten reasons, and I will give it a try." I'll give you one reason: Equal access to the source code. This allows you to better learn from

[GENERAL] Why PostgreSQL is better than other commerial softwares?

1998-12-17 Thread Albert Chen
Hi, I'm using FreeBSD and PostgreSQL 6.4. I tell my advisor to try PostgreSQL, but he said:"Why PostgreSQL is better than other commercial softwares? If you could give me ten reasons, and I will give it a try." Would anyone tell me what's reason you like Postgres. Because it's free, powerful and