| From: | Lukasz Brodziak <lukasz(dot)brodziak(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Query problem |
| Date: | 2011-09-05 19:00:40 |
| Message-ID: | CAGWYGjWYbE5C4AVCTzbUCrb3Jmy+gVr1a9N9D--HCDCu-5fddA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Al-Salami, Adel | 2011-09-06 12:12:07 | Warm standby Service doesn't startup |
| Previous Message | marvin.deoliveira | 2011-09-05 18:07:42 | Can't create a new database from dump |