Query problem

Поиск
Список
Период
Сортировка
От Lukasz Brodziak
Тема Query problem
Дата
Msg-id CAGWYGjWYbE5C4AVCTzbUCrb3Jmy+gVr1a9N9D--HCDCu-5fddA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Query problem  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-admin
Hello,

I have two DBs from the same user. When I run a query: SELECT wer_sys||'.'||wer_int||'.'||wer_wew FROM ver WHERE code = '1243' on a boken DB I get an error:  ERROR:  array value must start with "{" or dimension information but when I try to run the query on a "healthy" DB I don't have the error. Can anyone please guide me where to look for the problem. Already tried restoring the table I run the query on from the non-broken DB but t didn't work. While updating the database with our client program I get psql error: out of memory. The pg version is 8.2 (yes it's old but we are migrating to 9.0).
--
Łukasz Brodziak
"Do you bury me when I'm gone
Do you teach me while I'm here
Just as soon I belong
Then it's time I disappear"

В списке pgsql-admin по дате отправления:

Предыдущее
От: "marvin.deoliveira"
Дата:
Сообщение: Can't create a new database from dump
Следующее
От: "Al-Salami, Adel"
Дата:
Сообщение: Warm standby Service doesn't startup