[GENERAL] Installing pl/pgsql under Irix 5.3

1999-05-19 Thread Stuart Rison
Dear all, I'm having trouble installing PL/pgSQL under Irix 5.3. at first gmake gave me the following error message: merlin::postgres 52% gmake cc -I../../../include -I../../../backend -I../../../interfaces/libpq -I../../../include -I../../../backend -c -o pl_parse.o pl_gram.c cfe: Error: g

[GENERAL] For data based web site, which RDBMS is better & why ?

1999-05-19 Thread ralli
Hi, I am new on this list. I am in a process of Outsourcing for Development of a data based web site for Real Estate. Some database experts have informed me that PostgreSQL is the best. My web developer says MySQL is ideal for my requirement,( may be he doesn't know PostgreSQL ). Here

[GENERAL] Looking for Mr. Autonum

1999-05-19 Thread E Westfield
Greetings Looking for how to build a table with a built in unique sequential numeric key (primary optional) and then copy from a flat file to that same field. Can not see on the _CREATE TABLE_ nor the _TYPE_ how to do so. Is the OID mentioned in the _COPY_ a possible. I wish to have a new uniqu

Re: [GENERAL] For data based web site, which RDBMS is better & why ?

1999-05-19 Thread Bruce Momjian
> Hi, > > I am new on this list. > > I am in a process of Outsourcing for Development of a data based > web site for Real Estate. > > Some database experts have informed me that PostgreSQL is the best. > > My web developer says MySQL is ideal for my requirement,( may be he > doesn't kno

RE: [GENERAL] For data based web site, which RDBMS is better & why ?

1999-05-19 Thread Jackson, DeJuan
The problem here is to find impartial comparisons. The question between MySQL and PostgreSQL usually come down to Do I care most about speed? - usually true for purely Web Apps. or Do I need transaction and the other features PostgreSQL offers? - which tends to only be true if y

Re: [GENERAL] For data based web site, which RDBMS is better & why ?

1999-05-19 Thread Lincoln Spiteri
Hello, I have deployed Postgres on Linux for such an application (Real estate). I have a java app for data input and PHP interfaces for searching and all other sorts of things. Its been running for a year now. No complaints with speed, I run linux in text mode so it is very lightly loaded. To boo