On Wed, 28 Dec 2005, Josh King wrote:
I've seen a few posts here with people using Postgres over MySQL. Anyone using the latest CVS for such a setup?
Yes, I'm using it right now. Somethings, like cache, don't work well with postgres, but it has to do with programming issues (RC tries to insert a value that is to big for the field definition, while MySQL just truncates the value).
There was another DB error if I recall related to a bad comparision in the where clause (something like comparing an integer with a boolean).
The real problem is that MySQL does really strange things with values that don't fit the field definition (for example, inserting NULLs in a NOT NULL field). In all those cases, PG will give an error, which is the correct thing to do.
How about a migration from MySQL to Postgres? Looks very straightforward, but I figured why not ask first just in case.
Never had to do that. :-)
-- 07:50:03 up 6 days, 19:02, 1 user, load average: 0.62, 0.81, 1.73
Lic. Martín Marqués | SELECT 'mmarques' || Centro de Telemática | '@' || 'unl.edu.ar'; Universidad Nacional | DBA, Programador, del Litoral | Administrador