Re: [GENERAL] Postgres logo, copyrights, etc...

1999-03-25 Thread The Hermit Hacker
On Thu, 25 Mar 1999, Peter Blazso wrote: > Hi all, > > I'd like to know if there is any 'postgresql-powered' (or sg. like that) > logo available on the net. I have checked a few ftp and web sites and > been searching for it but without success. (I just want to use it on a > website which is 'pos

RE: [GENERAL] info on people running postgre

1999-03-25 Thread The Hermit Hacker
On Thu, 25 Mar 1999, Juan Alvarez Ferrando wrote: > Hi, > > We have tryed PostgreSQL as the backend of a Java application used to > collect orders and other information. Everything would have been fine but > for the lack of row-level locking, and some problems with processes that go > hanged whe

Re: [GENERAL] FATAL 1:btree: BTP_CHAIN flag was expected (vacuumcommand)

1999-03-25 Thread The Hermit Hacker
On Thu, 25 Mar 1999, Jay W. Summet wrote: > When I try to vacuum, or vacuum analyze my database, I get the > following error: > FATAL 1:btree: BTP_CHAIN flag was expected > > I've tried the following two commands: > /usr/local/pgsql/bin/psql -c "vacuum analyze;" billing > and > /usr/local/pgsql

Re: [GENERAL] Re: [SQL] sql 92 support in postgres

1999-03-25 Thread Jim Jennis
At 14:59 3/25/99 -0500, you wrote: >I second the opinion that postgreSQL implements a very flexible and >extensive set of SQL functionality. > >$2000 is chump change if the application is a mission critical one. The >Costs of losing the data or downtime of the database easily exceed $2000 (in >pr

[GENERAL] Postgres logo, copyrights, etc...

1999-03-25 Thread Peter Blazso
Hi all, I'd like to know if there is any 'postgresql-powered' (or sg. like that) logo available on the net. I have checked a few ftp and web sites and been searching for it but without success. (I just want to use it on a website which is 'postgres-powered' really!) My other problem/question is

RE: [GENERAL] info on people running postgre

1999-03-25 Thread James Thompson
On Thu, 25 Mar 1999, Juan Alvarez Ferrando wrote: > > collect orders and other information. Everything would have been fine but > for the lack of row-level locking, and some problems with processes that go > I'm not yet doing anything in a production environment yet, but the next version of pos

[GENERAL] V6.4.2 port to SCO Openserver 5.0.5

1999-03-25 Thread John Boris, Sr.
Is there a binary for this port? Or is there a HOW-TO to compile this. I have seen some threads on 6.3 but I am trying to compile 6.4.2 and it is failing with an error 2 and a few other errors in the make. TIA -- "Mr. Scott ..One to Beam up!" John J. Boris, Sr. JEN-A-Sys Administrator Archdi

Re: [GENERAL] Re: [SQL] sql 92 support in postgres

1999-03-25 Thread K.T.
I second the opinion that postgreSQL implements a very flexible and extensive set of SQL functionality. $2000 is chump change if the application is a mission critical one. The Costs of losing the data or downtime of the database easily exceed $2000 (in probably the first minutes of downtime). I

[GENERAL] Re: [SQL] sql 92 support in postgres

1999-03-25 Thread Ross J. Reedstrom
Eric - I've redirected your question to the general list, since it seems to fit in there better than the sql list. I think you're confusing mySQL's limitations with those of PostgreSQL (PG from here on) - PG does in fact support views, has for quite a while. They're even updateable. With each rel

[GENERAL] macaddr

1999-03-25 Thread Patrick Welche
Is there some documentation on the macaddr type anywhere? Cheers, Patrick

RE: [GENERAL] info on people running postgre

1999-03-25 Thread Juan Alvarez Ferrando
Hi, We have tryed PostgreSQL as the backend of a Java application used to collect orders and other information. Everything would have been fine but for the lack of row-level locking, and some problems with processes that go hanged when locked for to long. Also we have experienced a couple of corr

[GENERAL] FATAL 1:btree: BTP_CHAIN flag was expected (vacuum command)

1999-03-25 Thread Jay W. Summet
When I try to vacuum, or vacuum analyze my database, I get the following error: FATAL 1:btree: BTP_CHAIN flag was expected I've tried the following two commands: /usr/local/pgsql/bin/psql -c "vacuum analyze;" billing and /usr/local/pgsql/bin/psql -c "vacuum;" billing The top command used to wor

[GENERAL] 8000 photos in a database

1999-03-25 Thread Oleg Broytmann
Hi! http://oslo.clickwalk.no/ http://lwn.net/1999/0325/a/clickwalk.html 8000 photos in PostgreSQL database. RedHat linux, Apache httpd, Java serlets. Oleg. Oleg Broytmann http://members.xoom.com/phd2/ [EMAIL PROTECTED] Programmers don't die, they just GOSUB

Re: [GENERAL] info on people running postgre

1999-03-25 Thread K.T.
Personally, I find PostgreSQL to be good for non mission critical databases. I have used it for many commercial sites, but none that are "heavy" usage, zero down time. PostgreSQL is a fine database with many features, but there are database recovery/space usage issues that, I think, keep it from

[GENERAL] pg_dumpall error!

1999-03-25 Thread Valerio Santinelli
I'm getting the following error when running a pg_dumpall -z >db.out failed sanity check, opr with oid 67473 was not found How can I trace what oid 67473 is ? -- C'ya! Valerio Santinelli a.k.a. TANiS [[EMAIL PROTECTED]]+:+[http://www.mediacom.it/~tanis]

[GENERAL] info on people running postgre

1999-03-25 Thread Eric Enockson
hi, I am going to be implementing an online database and was considering oracle on an ultra, until i checked the price and 2,000 dollars, no way. I have used mSQL and looked at mySQL and now am aware of postgres and have heard that it is the most robust and well used of the free