char(xx) problem
| От | Nikolay Mijaylov |
|---|---|
| Тема | char(xx) problem |
| Дата | |
| Msg-id | 002801bf47d5$6aebaee0$ce2a18c3@skillbrokers.bg обсуждение исходный текст |
| Ответы |
Re: [GENERAL] char(xx) problem
|
| Список | pgsql-general |
Hi
we have two servers with installed Linux and PostGreSQL. They are quite
same. One is for development (Linux 2.2.9; 128 MB RAM; very overloaded with
processes), another for real HTTP serving in Internet (Linux 2.2.9; 64 MB
RAM; only http and pgsql)
In one of projects we had two tables:
create table a(
x char(2)
);
create table b(
y char(3)
);
When we try to execute SQL like this:
select * from a, b
where a.x = b.y;
one of servers selects 5-6 records (e.g. all mached records)
another selects empty table.
The database is one and same.
Why happen this?
PgSQL version 6.4, do i need to reinstall PgSQL, reinstall `db space' , or
how to fix it???
(I fix them with making chars with one and same length, and this is right
solution, but i want to have an idea why this difference exists)
--------------------------------------------------------------
The reboots are for hardware upgrades!
"http://www.nmmm.nu; <nmmm@nmmm.nu>
В списке pgsql-general по дате отправления: