[EMAIL PROTECTED] writes: > I've reinitdb (on 7.4b) with LANG=C and it worked. > So I reinitDB with LANG=FR and used LANG=C to psql -f xxx.sql template1 to > recreate the db and it worked too...
That's weird. I don't understand why an initdb in the same locale would make the problem go away. > I did'nt initdb between cvs changes, maybe that's why. If you had only seen the problem in 7.4b then I could believe that theory, but since you also saw it in the stable 7.3 installation, I don't. > would LANG=C psql -c"reindex table blah" db would help? No, the LANG environment of psql wouldn't make the slightest difference here. I don't think you told us your platform? (OS version, kernel, compiler, etc) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster