thanks for your help.
Seems as if the problem was related to our locale settings.
We are running PostgreSQL on QNX and did not set any specific locale when
creating the database.
Now when we explicitely use LOCALE C on database creation everything works
"Christian Enklaar" <christian(dot)enklaar(at)mbs-software(dot)de> schrieb im
> we are using a table with a primary key of type varchar.
> If we try to find entries with select * from <table> where <table.key> =
> entries with a key length of more than 32 characters are not found.
> Entries with a shorter key are found. Using "Like" instead of "=" works
> varchar keys with length > 32 as well.
> Does anybody know about this Problem ?
> (We use PostgresQL 7.4.1)
> Thanks in advance,
> Christian Enklaar.
In response to
pgsql-general by date
|Next:||From: Sebastian Böck||Date: 2004-09-24 08:41:04|
|Subject: Re: How do I disable: Adding missing FROM-clause|
|Previous:||From: Karsten Hilbert||Date: 2004-09-24 07:21:17|
|Subject: Re: need ``row number``|