Re: [BUGS] Upgrade from 7.4.5 to 8.3.3
Zdenek, > Harvey, Allan AC napsal(a): > > Zdenek, > > > >> Hmm, It does not look good. Your OS does not return proper > >> information about > >> codeset. Following code is broken: > >> > >>setlocale(LC_CTYPE, ctype); > >>sys = nl_langinfo(CODESET); > >>sys = strdup(sys); > >> > >> See > >> http://www.opengroup.org/onlinepubs/009695399/functions/nl_lan > > ginfo.html > > > >> It seems you need to fix OS first. After that we can add > CODESET mapping to > >> PostgreSQL. > > > >>Zdenek > > > > I don't think this is possible. > > > > Can you give me an indication what problems I should look out for? > > Regression testing only showed some date format issues if I > remeber correctly. > > > > I think, problem could be on two places: > > 1) libc is broken and does not return correct values. > 2) locale definition does not contain CODESET information. > > Do you use system libc or glibc? You can try create own > locale by localedef and > test what happen. > > Zdenek > I think it would have to be glibc as I used the gcc loaded with the "skunkware" tools that SCO provide. To date I have had no operational problems, I guess it must be a relatively simple use of postgres. So I thank you and all the others for their time and suggest that we let this one slide unless you really want to get to the bottom of it. I have the time, just not the understanding of "locale"s and the implications and implementations. Allan The material contained in this email may be confidential, privileged or copyrighted. If you are not the intended recipient, use, disclosure or copying of this information is prohibited. If you have received this document in error, please advise the sender and delete the document. Neither OneSteel nor the sender accept responsibility for any viruses contained in this email or any attachments. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] Upgrade from 7.4.5 to 8.3.3
Zdenek, > > Hmm, It does not look good. Your OS does not return proper > information about > codeset. Following code is broken: > > setlocale(LC_CTYPE, ctype); > sys = nl_langinfo(CODESET); > sys = strdup(sys); > > See > http://www.opengroup.org/onlinepubs/009695399/functions/nl_lan ginfo.html >It seems you need to fix OS first. After that we can add CODESET mapping to >PostgreSQL. > Zdenek I don't think this is possible. Can you give me an indication what problems I should look out for? Regression testing only showed some date format issues if I remeber correctly. Allan Harvey, Allan AC napsal(a): > Zdenek > > Thanks for your reply. > >> I guess we don't have locale mapping for SCO OpenServer5.7. See >> http://doxygen.postgresql.org/chklocale_8c-source.html > > Browser Timed out. (?) > >> Could you run following code: >> http://archives.postgresql.org/pgsql-hackers/2007-09/msg01168.php >> >> and send output. >> >> Zdenek > > Output as requested: > > bash-2.05$ for LOCALE in `locale -a`; do locale_test $LOCALE; done > C_C.C ...- NO MATCH > cs_CZ.ISO8859-2 ...- NO MATCH > english_uk.ISO8859-15 ...- NO MATCH > english_uk.8859 ...- NO MATCH -- Zdenek Kotala Sun Microsystems Prague, Czech Republic http://sun.com/postgresql The material contained in this email may be confidential, privileged or copyrighted. If you are not the intended recipient, use, disclosure or copying of this information is prohibited. If you have received this document in error, please advise the sender and delete the document. Neither OneSteel nor the sender accept responsibility for any viruses contained in this email or any attachments. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] Upgrade from 7.4.5 to 8.3.3
During an upgrade from 7.4.5 to 8.3.3 the following was dumped during the restore process from psql. psql:roperydb_v7.4_20081021.dmp:49: WARNING: could not determine encoding for locale "C_C.C": codeset is "" DETAIL: Please report this to . So I am reporting it. Back ground. I am using 8.3.3 because it is the latest I have for SCO OpenServer5.7 I used "pg_dumpall -o" from the 8.3.3 release. During the "initdb" process similar errors were dumped and a suggestion of passng a locale with the -E option was used. Explicitly I used: /usr/local/pgsql/bin/initdb -E SQL_ASCII -D /usr/local/pgsql/data which allowed the process to complete. The warning above was then dumped during the restore process. The cluster seems to working OK. Should I be concerned? Thanks for your time. Allan The material contained in this email may be confidential, privileged or copyrighted. If you are not the intended recipient, use, disclosure or copying of this information is prohibited. If you have received this document in error, please advise the sender and delete the document. Neither OneSteel nor the sender accept responsibility for any viruses contained in this email or any attachments. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs