Re: Posgres bug report

There is a problem with mac osx in regard to locale. A
bug report was submitted to apple, they (apple)
acknowledged the bug and said it would be addressed in
a future version.

End result... when you initdb you need to use locale =
C. I forgot the exact syntax just look at the docs.

initdb --locale=C

Hope this helps.

Ted

--- Claudio Sartori <claudio.sartori@unibo.it> wrote:
>
========================================================================
>
> ====
>                          POSTGRESQL BUG REPORT
> TEMPLATE
>
========================================================================
>
> ====
>
>
> Your name               :       Claudio Sartori
> Your email address      :
> claudio.sartori@unibo.it
>
>
> System Configuration
> ---------------------
>    Architecture (example: Intel Pentium)         :
> Apple PowerMac G4
> dual 1.o GHz
>    Operating System (example: Linux 2.0.26 ELF)  :
> Apple Mac OS X
> 10.2.6, main language Italian
>
>    PostgreSQL version (example: PostgreSQL-6.5.1):
> PostgreSQL-7.3.3
>
> Please enter a FULL description of your problem:
> ------------------------------------------------
> I followed exactly the update instructions in
> http://www.entropy.ch/software/macosx/postgresql/
> everything seems to work fine, but after the pg_ctl
> start command the
> log file contains the line
>
> FATAL:  invalid value for option 'LC_TIME': 'it_IT'
>
> and the system is not started.
>
> Before I had 7.2.3 perfectly working (and at present
> I switched back to
> it)
>
> Regards
>
> --
> Claudio Sartori
> Dipartimento di Elettronica, Informatica e
> Sistemistica
> Universita' di Bologna
> Viale Risorgimento, 2
> I-40136 BOLOGNA
> ITALY
> Tel (direct): +39 051 20 93554
> Tel (operator): +39 051 20 93548  - 93001
> Fax : +39 051 20 93540
> Mobile: +39 335 690 8250
> http://www-db.deis.unibo.it/sartori/
>
> --
> Claudio Sartori
> Dipartimento di Elettronica, Informatica e
> Sistemistica
> Universita' di Bologna
> Viale Risorgimento, 2
> I-40136 BOLOGNA
> ITALY
> Tel (direct): +39 051 20 93554
> Tel (operator): +39 051 20 93548  - 93001
> Fax : +39 051 20 93540
> Mobile: +39 335 690 8250
> http://www-db.deis.unibo.it/sartori/
>
> --
> Claudio Sartori
> Dipartimento di Elettronica, Informatica e
> Sistemistica
> Universita' di Bologna
> Viale Risorgimento, 2
> I-40136 BOLOGNA
> ITALY
> Tel (direct): +39 051 20 93554
> Tel (operator): +39 051 20 93548  - 93001
> Fax : +39 051 20 93540
> Mobile: +39 335 690 8250
> http://www-db.deis.unibo.it/sartori/
>
> --
> Claudio Sartori
> Dipartimento di Elettronica, Informatica e
> Sistemistica
> Universita' di Bologna
> Viale Risorgimento, 2
> I-40136 BOLOGNA
> ITALY
> Tel (direct): +39 051 20 93554
> Tel (operator): +39 051 20 93548  - 93001
> Fax : +39 051 20 93540
> Mobile: +39 335 690 8250
> http://www-db.deis.unibo.it/sartori/
>
> --
> Claudio Sartori
> Dipartimento di Elettronica, Informatica e
> Sistemistica
> Universita' di Bologna
> Viale Risorgimento, 2
> I-40136 BOLOGNA
> ITALY
> Tel (direct): +39 051 20 93554
> Tel (operator): +39 051 20 93548  - 93001
> Fax : +39 051 20 93540
> Mobile: +39 335 690 8250
> http://www-db.deis.unibo.it/sartori/
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose
> an index scan if your
>       joining column's datatypes do not match

__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com