Re: [GENERAL] Record order change after update

2004-03-02 Thread Matt Davies
My understanding of RDBMs: you will get all information as indicated by the query in an unsorted order. Sometimes you get the same order; sometimes you do not. To ensure expected ordering you must use the ORDER keyword. Quoting Josué Maldonado [EMAIL PROTECTED]: Hello list, After

Re: [GENERAL] Postgresql 7.3 And Redhat Enterprise 3

2004-02-02 Thread Matt Davies
Would you attach your startup script? 2 other questions? 1. Are all the binaries you are calling using the full paths? 2. Are you calling the pg_ctl as user postgres(or other user) (i.e. su - postgres -c 'pg_ctl .' Quoting Remi [EMAIL PROTECTED]: Hello, I've installed redhat

Re: [GENERAL] Postgress and MYSQL

2004-01-14 Thread Matt Davies
I have to agree. In my experience the average database user out there does not need the entire functionality of something like Oracle. It is because of this that I have used MySQL for many years now. In this light (please accept my confession as to being a more prolific MySQL user), I am

Re: [GENERAL] Postgress and MYSQL

2004-01-14 Thread Matt Davies
Quoting Joshua D. Drake [EMAIL PROTECTED]: Replication exists in multiple manners for PostgreSQL. There is Mammoth replicator (our product), ErServer (pgsql.com's product), dbmirror, Rserv, and pgCluster. What I meant was integrated replication. When adding more layers to the database

Re: [GENERAL] Postgress and MYSQL

2004-01-14 Thread Matt Davies
Quoting Ben [EMAIL PROTECTED]: Yes, I don't understand why people seem to keep complaining about Postgres' documentation - it is by far the best reference documentation I've ever come across. Maybe it's that there isn't much tutorial content in the documentation - for somebody trying to

Re: [GENERAL] Postgress and MYSQL

2004-01-14 Thread Matt Davies
Quoting Martin Marques [EMAIL PROTECTED]: Oh, please! I have never seen such a better community then this one (well, some exceptions come to mind right now, but it's still within the best). I have personally found GREAT replys from the developers (Tom Lane comes to mind, saving me lots of