Fw: [GENERAL] Future of PostgreSQL

1999-12-27 Thread Nikolay Mijaylov
  --The reboots are for hardware upgrades!"www.nmmm.nu"; <[EMAIL PROTECTED]> - Original Message - From: Nikolay Mijaylov To: pgsql-general Sent: ÐÏÎÅÄÅÌÎÉË, äÅËÅÍ×ÒÉ 27, 1999 03:27 Subject: Re: [GENERAL] Future of PostgreSQ

Re: [GENERAL] Future of PostgreSQL

1999-12-27 Thread Adriaan Joubert
Hi, Yes, I think reliability needs more work. I've had quite a few problems with system indexes getting corrupted (number of tuples incorrect and some other bizarre problems). Very hard to pin down as I haven't been able to reproduce any of these cases. I've got the feeling that there may be

Re: [GENERAL] Future of PostgreSQL

1999-12-27 Thread Adriaan Joubert
john huttley wrote: > > I believe we are adding Oracle compatibility as possible. We are > > working on write-ahead log, long tuples, foreign keys, and outer joins. > > Anything else? > > Yes, earlier in the year I was trying to migrate from Pervasive SQL to > posgtres and > came to a screaming

Re: [GENERAL] Future of PostgreSQL

1999-12-27 Thread Karel Zak - Zakkr
On Sun, 26 Dec 1999, Howie wrote: > On Sat, 25 Dec 1999, Bruce Momjian wrote: > > > > > > > > > > On Sat, 25 Dec 1999, Bruce Momjian wrote: > > > > My big question is, what new challenges will we face as > > > > we become more popular? > > > > > > Plug-in Oracle 7 compatibility. > > > > I

Re: [GENERAL] Future of PostgreSQL

1999-12-27 Thread Karel Zak - Zakkr
On Sun, 26 Dec 1999, Bruce Momjian wrote: > > - A dump program that can dump/restore large objects. > > > > Don't get me wrong. I'm not complaining, and we work with PostgreSQL a lot > > without any big problems. Just some ideas to make it easier for the > > administrator. > > We are going to

Re: [GENERAL] compile problem

1999-12-27 Thread Mike Mascari
Toomas Tamme wrote: > > hi > > source version postgresql-6.5.3 > gcc --version > 2.95.2 > sparc-sun-solaris2.6 > > gives error like this: > > gcc -I../../include -I../../backend-Wall -Wmissing-prototypes -DFRONTEND > -fPIC -c pqsignal.c -o pqsignal.o > ar crs libpq.a fe-auth.o fe-connect

[GENERAL] compile problem

1999-12-27 Thread Toomas Tamme
hi source version postgresql-6.5.3 gcc --version 2.95.2 sparc-sun-solaris2.6 gives error like this: gcc -I../../include -I../../backend-Wall -Wmissing-prototypes -DFRONTEND -fPIC -c pqsignal.c -o pqsignal.o ar crs libpq.a fe-auth.o fe-connect.o fe-exec.o fe-misc.o fe-print.o fe-lobj.o

Re: [GENERAL] pgsql 7.x...

1999-12-27 Thread Mike Mascari
Howie wrote: > ...[other stuff]... > > ircbot=> select now(),'now'::datetime,now()::datetime; > now |?column?|datetime > --++ > 1999-12-27 04:25:35-05|Mon Dec 27 04:25:35 1999 EST|Mo

Re: [GENERAL] pgsql 7.x...

1999-12-27 Thread Howie
On Sun, 26 Dec 1999, Mike Mascari wrote: > Howie wrote: > > > will this function/index problem be fixed in 7.x ? > > > > ircbot=> explain select * from logins where dttime = NOW(); > [SNIP] > emptoris=> explain select * from sales where saledate = 'now'::datetime; > NOTICE: QUERY PLAN: > > Ind

Re: [GENERAL] Future of PostgreSQL

1999-12-27 Thread franck
Well, I like to see replication, at least snapshot type, and later merge type... Snapshot should allow load balancing while querying db, and allow distributed web/db server. The replication should work over LAN/WAN and snailmail. The replication shouldn't be dependent of a transport/network confi