Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

1998-07-22 Thread Kevin Cousins
>> Oracle now comes along and says that it is going to have a >> Linux-binary distribution available. So? How much is that binary >> going to cost? And what sort of licensing is provided? JohnDz> What version of Linux? What Platform ? Full featured? I was asking myself the same question.

[GENERAL] Re: [INTERFACES] ODBC Driver

1998-07-22 Thread Byron Nikolaidis
Bruce Tong wrote: > > I knew I needed to check my work before bringing the ODBC driver problems > out in the open. Here's what I've found. > > I was designing a simple query using MS-Access having already defined > an external data source to a PostgreSQL database just to make sure > things work

[GENERAL] NEW ODBC DRIVER v.0248

1998-07-22 Thread Byron Nikolaidis
Hello, A new odbc driver is available at our web site http://www.insightdist.com/psqlodbc. Regards, Byron version.txt date: 7/22/98 version: 06.30.0248 - This file describes changes and or fixes since

Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

1998-07-22 Thread Ken McGlothlen
[EMAIL PROTECTED] (The Hermit Hacker) writes: | Alot of good points here, and some not so good...last I checked, vacuum was | still required for Oracle, no? Does Oracle even have a vacuum? There's the COELESCE command, but it's hardly *necessary*. | As for 'front end and report designers'...th

[GENERAL] Re: [ANNOUNCE] Revamp'd Web Site...

1998-07-22 Thread Hugo van der Kooij
On Wed, 22 Jul 1998, The Hermit Hacker wrote: > > I just did a relatively major cleanup of the WWW site, and am > looking for feedback. > > Bsically, I was growing tired of looking at the site, and > constantly reloading the same data over and over again (the 'index' on the > left,

Steps to build extensions -- Was: "Re: [GENERAL] Postgres superuser priviledges"

1998-07-22 Thread Gene Selkov, Jr.
Sorry I could not keep up with your progress -- I am grossly overcommited :( Konstantinos Vassiliadis wrote: > > Thanks in advance for your help. > I had a look at your defined type. I have some questions: > a) I don't really understand the syntax of the Makefile. I understand it > is required t

[GENERAL] Re: [MIRRORS] Revamp'd Web Site...

1998-07-22 Thread Aleksey Dashevsky
hi! Did you rename start page of PostgreSQL site from index.shtml to index.html by an accident or with some special purpose? It is very important to maintainers of mirrors,'cause we used to begin mirroring from www.postgresql.org/index.shtml -- URL www.postgresql.org automatically throws to your n

[GENERAL] RE: [ANNOUNCE] Revamp'd Web Site...

1998-07-22 Thread Jackson, DeJuan
Fix: http://www.postgresql.org/docs/todo.shtml > I just did a relatively major cleanup of the WWW site, and am > looking for feedback. > > Bsically, I was growing tired of looking at the site, and > constantly reloading the same data over and over again (the 'index' on > the

[GENERAL] Revamp'd Web Site...

1998-07-22 Thread The Hermit Hacker
I just did a relatively major cleanup of the WWW site, and am looking for feedback. Bsically, I was growing tired of looking at the site, and constantly reloading the same data over and over again (the 'index' on the left, for starters). I think the new format looks okay

Re: [GENERAL] Postgres vs commercial products

1998-07-22 Thread The Hermit Hacker
On Wed, 22 Jul 1998, Bruce Momjian wrote: > > On Wed, 22 Jul 1998, Brett W. McCoy wrote: > > > > > On Wed, 22 Jul 1998, Amos Hayes wrote: > > > > > > > Has there ever been any discussion about a new name? It doesn't matter to > > > > me but it would seem that with the current discussions about

Re: [GENERAL] Postgres vs commercial products

1998-07-22 Thread Bruce Momjian
> On Wed, 22 Jul 1998, Brett W. McCoy wrote: > > > On Wed, 22 Jul 1998, Amos Hayes wrote: > > > > > Has there ever been any discussion about a new name? It doesn't matter to > > > me but it would seem that with the current discussions about promotion and > > > competition, it might help to have

Re: [GENERAL] Postgres vs commercial products

1998-07-22 Thread Brett W. McCoy
On Wed, 22 Jul 1998, Bruce Momjian wrote: > University Ingres was first, then commercial Ingres was a split-off. > PostgreSQL is based on University Ingres. That's what I thought... Brett W. McCoy http://www.lan2wan.com/~bmccoy --

Re: [GENERAL] Postgres vs commercial products

1998-07-22 Thread The Hermit Hacker
On Wed, 22 Jul 1998, Brett W. McCoy wrote: > On Wed, 22 Jul 1998, Amos Hayes wrote: > > > Has there ever been any discussion about a new name? It doesn't matter to > > me but it would seem that with the current discussions about promotion and > > competition, it might help to have a more "public

[GENERAL] Moving Databases

1998-07-22 Thread Jeffrey Napolitano
The pg_dump command does not work properly on my data because I have \'s in it. Therefore, to back up my database, I was thinking of doing the following: mv $PGDATA/base/ / Would it work if I then move back to $PGDATA/base ? Or are there dependencies that could affect this? -

Re: [GENERAL] Postgres vs commercial products

1998-07-22 Thread Brett W. McCoy
On Wed, 22 Jul 1998, Amos Hayes wrote: > Has there ever been any discussion about a new name? It doesn't matter to > me but it would seem that with the current discussions about promotion and > competition, it might help to have a more "public friendly" name. It is > not obvious to me what a "pos

[GENERAL] ODBC Driver

1998-07-22 Thread Bruce Tong
I knew I needed to check my work before bringing the ODBC driver problems out in the open. Here's what I've found. I was designing a simple query using MS-Access having already defined an external data source to a PostgreSQL database just to make sure things work as I expected. The database is bi

Re: [GENERAL] Postgres vs commercial products

1998-07-22 Thread The Hermit Hacker
On Wed, 22 Jul 1998, Amos Hayes wrote: > On Tue, 21 Jul 1998, Steve Logue wrote: > > > > postgres willing to create a logo a la apache, powered by postgresql? > > > it'll be up on my site in no time at all. > > > > Since I last made a batch of logo's to prompt comments, I've been meaning to > >

Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

1998-07-22 Thread Bruce Tong
> > > > What does Oracle's ODBC driver offer that ours currently doesn't? > > > > > > I just tried it for the first time last week. It failed to perform a > > > simple query. I need to double check my work yet. The Oracle ODBC driver > > > has _probably_ been around for a while and has _probably_

Re: [GENERAL] Postgres vs commercial products

1998-07-22 Thread Amos Hayes
On Wed, 22 Jul 1998, Brett W. McCoy wrote: > On Wed, 22 Jul 1998, Amos Hayes wrote: > > > I almost hate to ask, and really, it's not a big deal to me personally, > > but why is it called "PostgreSQL"? > > Originally it was just Postgres, and didn't support any SQL. When it was > redesigned wit

Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

1998-07-22 Thread Bruce Momjian
> On Wed, 22 Jul 1998, James Olin Oden wrote: > > As far as documentation goes, I think that for the most part what is there is > > good. Sometimes (and I realize I need to be more specific) it seems the very > > thing you are looking for you can't find; in the end that generally has been an > >

Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

1998-07-22 Thread Byron Nikolaidis
The Hermit Hacker wrote: > > On Wed, 22 Jul 1998, Bruce Tong wrote: > > > My comments are driven by perceptions. I admit they're uninformed. The > > topic is advertising PostgreSQL, so my perceptions are relevant. Educate > > me and the masses about your product. I'm hear because I think Postgre

Re: [GENERAL] Postgres vs commercial products

1998-07-22 Thread Brett W. McCoy
On Wed, 22 Jul 1998, Amos Hayes wrote: > I almost hate to ask, and really, it's not a big deal to me personally, > but why is it called "PostgreSQL"? Originally it was just Postgres, and didn't support any SQL. When it was redesigned with SQL support, that's when the SQL postfix came about. Ac

Re: [GENERAL] Postgres vs commercial products

1998-07-22 Thread Amos Hayes
On Tue, 21 Jul 1998, Steve Logue wrote: > > postgres willing to create a logo a la apache, powered by postgresql? > > it'll be up on my site in no time at all. > > Since I last made a batch of logo's to prompt comments, I've been meaning to > make a "serious" attempt again but keep getting side

Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

1998-07-22 Thread Brett W. McCoy
On Wed, 22 Jul 1998, The Hermit Hacker wrote: > Oracle now comes along and says that it is going to have a > Linux-binary distribution available. So? How much is that binary going > to cost? And what sort of licensing is provided? I think PostgreSQL will continue on as much as before, j

Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

1998-07-22 Thread Dan Delaney
On Wed, 22 Jul 1998, James Olin Oden wrote: > As far as documentation goes, I think that for the most part what is there is > good. Sometimes (and I realize I need to be more specific) it seems the very > thing you are looking for you can't find; in the end that generally has been an > issue of i

Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

1998-07-22 Thread Bruce Tong
> Sometimes (and I realize I need to be more specific) it seems the very > thing you are looking for you can't find; in the end that generally has > been an issue of inexperience with SQL. Exactly. I'm learning SQL and PostgreSQL at the same time and it is sometimes difficult for me to correctly

Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

1998-07-22 Thread Bruce Tong
> > > What does Oracle's ODBC driver offer that ours currently doesn't? > > > > I just tried it for the first time last week. It failed to perform a > > simple query. I need to double check my work yet. The Oracle ODBC driver > > has _probably_ been around for a while and has _probably_ been bet

Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

1998-07-22 Thread James Olin Oden
> > My experience with paid support vs mailings lists tends to have me > > much preferring mailing lists. At least on a mailing list, you have a > > good chance of finding someone that has already hit that same problem. > > Actually, I tend to end up supporting the product for which I am

Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

1998-07-22 Thread Herve Lefebvre
---Bruce Tong <[EMAIL PROTECTED]> wrote: > > features != ANSI SQL compliance, right? > > I suppose ANSI SQL is the heart of it. > > > Again, what are we missing that Oracle currently has...? > Stored procedures with tuples resultset: SELECT F1,F2,F3 FROM TABL1 And Multi-resultsets stored-pro

Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

1998-07-22 Thread Maarten Boekhold
> MPSQL: http://troubador.com/~keidav/images/screenshots/sot.jpg > MPMGR: http://troubador.com/~keidav/mpmgr.html > - if nobody has checked out the screenshots on this, > check it out This one is looking *sooo* cool. Anybody knows of a good toolkit the

Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

1998-07-22 Thread The Hermit Hacker
On Wed, 22 Jul 1998, Bruce Tong wrote: > My comments are driven by perceptions. I admit they're uninformed. The > topic is advertising PostgreSQL, so my perceptions are relevant. Educate > me and the masses about your product. I'm hear because I think PostgreSQL > is a useful tool. Perce

Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

1998-07-22 Thread Herve Lefebvre
---The Hermit Hacker <[EMAIL PROTECTED]> wrote: > > On Tue, 21 Jul 1998, Bruce Momjian wrote: > > > We clearly are the most advanced "open source" database around. We now > > have "closed source" competition. How do we meet that challenge? > > You want an honest answer? We don't. Or, a

Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

1998-07-22 Thread Bruce Tong
My comments are driven by perceptions. I admit they're uninformed. The topic is advertising PostgreSQL, so my perceptions are relevant. Educate me and the masses about your product. I'm hear because I think PostgreSQL is a useful tool. > > I say this with these (mostly uninformed) assumptions in

Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

1998-07-22 Thread JohnDz
> > Oracle now comes along and says that it is going to have a > Linux-binary distribution available. So? How much is that binary going > to cost? And what sort of licensing is provided? -- What version of Linux? What Platform ? Full featured? Don't kid yourselves about Oracle. Tak

Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

1998-07-22 Thread The Hermit Hacker
On Tue, 21 Jul 1998, Bruce Momjian wrote: > We clearly are the most advanced "open source" database around. We now > have "closed source" competition. How do we meet that challenge? You want an honest answer? We don't. Or, at least, we don't think of it as meeting a challenge.

Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

1998-07-22 Thread The Hermit Hacker
On Tue, 21 Jul 1998, Ken McGlothlen wrote: > There are a wide array of other issues, too; the simplistic security, > view limitations, administrational problems (eventually, for example, > vacuum should be unnecessary), analysis issues, replication issues, > cross-server database issues, index li

[GENERAL] Compiling/Loading C function

1998-07-22 Thread Konstantinos Vassiliadis
Hello I am desperately trying to use a type I have created. PostgreSQL runs under SunOS 4.1.x. I followed the documentation's example on this platform % cc -I$PGROOT/include -I$PGROOT/src/include -PIC -c phone.c gives too many errors in header files... Then, I used gcc (following docu

Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

1998-07-22 Thread The Hermit Hacker
On Tue, 21 Jul 1998, Bruce Tong wrote: > I say this with these (mostly uninformed) assumptions in mind. Oracle's > ODBC driver is probably more complete. Oracle is better documented. Oracle > has a lot of related tools. Oracle offers training. What does Oracle's ODBC driver offer that ou

Re: [GENERAL] Postgres vs commercial products

1998-07-22 Thread Herouth Maoz
At 23:36 +0300 on 21/7/98, Steve Doliov wrote: > in commercial enterprises such as Oracle, INnformix and Sybase, whether to > implement a feature or part of a standard gets boiled down to a business > decision/question -- will adding this or that create more profit for the > company? if the ans

Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

1998-07-22 Thread Roberto Joao Lopes Garcia
That is my case: We have an Sun Ultra Sparc acting as a server for ~ 90 Pc runing M$ Dos or Windows, almost all playing with a CAD program. I and a few other people take care of the whole thing. We need a SQL server but it is very hard for us to have approved a budget of thousands of dollars to

Re: [GENERAL] returning oid of last insert?

1998-07-22 Thread Bruce Momjian
> Thanks for the help. I checked libpq, and just to follow up, it is quite > easy to get the oid of the last insert using the routine oidStatus. > > On Sun, 19 Jul 1998, Peter T Mount wrote: > > > On Sat, 18 Jul 1998, Matt McClure wrote: > > > > > Is there a way to return the oid of the last

[GENERAL] Re: Source code archive location

1998-07-22 Thread J Christopher Bower
>On Fri, 17 Jul 1998, J. Christopher Bower wrote: > I am looking for Postgresql Version 6.2, can you tell me where I can > find it. I need the pg_Dump utility to dump a 6.1database. > Thanks in advance for your help. strange. you should

[GENERAL] PostgreSQL on Rhapsody?

1998-07-22 Thread Dan Delaney
Is anyone running PostgreSQL on Rhapsody (aka Mac OS X Server) yet? And, if so, did you have any problems getting it up and running? Thanks. --Dan --- Daniel G. DelaneyThe Louisville Times Chorus [EMAIL

Re: [GENERAL] Postgres vs commercial products

1998-07-22 Thread Steve Logue
Steve Doliov wrote:Postgres offered banner ads for a while. SPeaking of promoting it, is > postgres willing to create a logo a la apache, powered by postgresql? > it'll be up on my site in no time at all. Since I last made a batch of logo's to prompt comments, I've been meaning to make a "serio

Re: [GENERAL] Postgres superuser priviledges

1998-07-22 Thread Gene Selkov, Jr.
Konstantinos Vassiliadis wrote: > > Hi > I am new to Postgres. I am trying to load a C function in Postgres under > Red Hat Linux. > I compile using > gcc -I$PGROOT -I$PGROOT/include -I$PGROOT/src/include -c phone.c > to produce the object file 'phone.o' > Then I link using > ld -Bdynamic -o ph

Re: [GENERAL] returning oid of last insert?

1998-07-22 Thread Matt McClure
Thanks for the help. I checked libpq, and just to follow up, it is quite easy to get the oid of the last insert using the routine oidStatus. On Sun, 19 Jul 1998, Peter T Mount wrote: > On Sat, 18 Jul 1998, Matt McClure wrote: > > > Is there a way to return the oid of the last insert command?

[GENERAL] Online Marketing

1998-07-22 Thread copa
ONLINE MARKETING - THE NEXT GENERATION OF ADVERTISING/MARKETING Complete Online Marketing Solutions: At Estroco Technologies, we provide all the tools necessary to promote your business/organization. Whether your goal is to have people come to your website, or to prospect for orders of produc

[GENERAL] Online Marketing

1998-07-22 Thread dp3000
ONLINE MARKETING - THE NEXT GENERATION OF ADVERTISING/MARKETING Complete Online Marketing Solutions: At Estroco Technologies, we provide all the tools necessary to promote your business/organization. Whether your goal is to have people come to your website, or to prospect for orders of produc

Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

1998-07-22 Thread Ken McGlothlen
Bruce Momjian <[EMAIL PROTECTED]> writes: | OK, let's discuss this. How does this affect us? [...] | Certain people will be tempted by a commercial SQL server, while others | will prefer us because of: | | features Sorry, but I just don't buy this at the moment, for several reasons. Do

[GENERAL] Encrypting Data Requests (& returns)?

1998-07-22 Thread Doug Younger
Hello, I currently have Postgres running on one of our web servers, so all transactions are local. I wish to move Postgres to a dedicated server and access the data remotely from at least 4 web servers. My dilemma is that I want all data requests & returns to and from the Postgres server to b

[GENERAL] Running version 6.3.2 pg_dump on a 6.1 database

1998-07-22 Thread J Christopher Bower
Hello, I am trying to upgrade to postgres 6.3.2 from 6.1. I am having problems dumping the 6.1 database with 6.1 pg_dump. I was told that the 6.3.2 pg_dump will dump a 6.1 database. I get the following error: be_recvauth: unrecognized message type: 65536

Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

1998-07-22 Thread Ken McGlothlen
[EMAIL PROTECTED] (Bruce Momjian) writes: | Consider what we are doing. Commercial database vendors have teams of | full-time programmers, adding features to their databases, while we have a | volunteer group of part-time developers. Oh! I'd never *dream* of maligning the coders working on Pos

[GENERAL] Postgres vs commercial products

1998-07-22 Thread Steve Doliov
As long as postgres is open source and free, postgres never has to worry about the commercial competition (in my eyes). i have far more faith in the postgresql developers to implement features and standards than i do in the commercial vendors of similar systems. in commercial enterprises such as