PostgreSQL RC4 Command prompt functions on Windows (Windows 2000
Professional - Spanish with SP4) still displays a message in the format:
could not find a "functionname" to execute when executing a psql, pg_dump,
createdb, createuser and some other functions. They work and do the required
job, but display that message first. Psql even displays it twice.

Another bug is in the ODBC driver included, which has been since the first
beta releases of PostgreSQL 8 and it's that it doesn't handle correctly
Spanish/European characters. The database stores them perfectly, but the
ODBC driver doesn't read them, displaying a "?" mark where an accented
work
or a letter ñ should be, and truncating such word in that place.

When updating, creating or deleting a recordset (through the ODBC driver),
the following error is displayed:
Insufficient base table information for updating or refreshing.
# -2147467259

Elvis E. Henríquez A.


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

On Tue, Jan 11, 2005 at 07:27:44AM -0400, Elvis E. Henriquez A. wrote:
Hmm ... I'm not sure I understand the problem here. Please copy & paste
the exact message and commands executed.

Most likely, it's an encoding problem. Do you have client_encoding
correctly set? Is the database using the correct server-side encoding?


Please be aware that a there is a high quality spanish list
(pgsql-es-ayuda); feel free to report there, with details added.

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
Y dijo Dios: "Que sea Satanás, para que la gente no me culpe de todo a mí."
"Y que hayan abogados, para que la gente no culpe de todo a Satanás"

---------------------------(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

On Fri, Jan 14, 2005 at 09:50:32PM -0400, Elvis E. Henriquez A. wrote:

Hi,

Please keep the copy to the list when replying.

Now that's weird. But I don't think it's a Postgres problem; maybe your
shell is playing some games on you. I don't know a lot about Hasefroch
command line utilities to help you more here.


I think that's exactly the problem. With SQL_ASCII you should limit
yourself to (7 bit) ASCII characters, or be bitten by Postgres' recoding
capabilities. If you want to use non-ascii characters, you should
declare your database as LATIN1 or LATIN9, or if it's a Hasefroch server
maybe win125x, cp850, whatever. And your client_encoding should be set
to the correct value, so that if there is gonna be character conversion,
the results are what you expect.

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"La primera ley de las demostraciones en vivo es: no trate de usar el sistema.
Escriba un guión que no toque nada para no causar daños." (Jakob Nielsen)

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

황수진 wrote:
While your report is appreciated, it's not going to tell anybody much
without knowing what Pg version you're using, what OS you're using, what
version of that OS you're using, etc.

--
Craig Ringer

--
Sent via pgsql-bugs mailing list (pgsql-bugs (AT) postgresql (DOT) org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs