[ADMIN] Query problem

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 e

[ADMIN] Can't create a new database from dump

How can I create a entire database from a dump generated with: ./pg_dump -U postgres -F p -E UTF8 -C --inserts --column-inserts -t ... -t-v -f dumpfile.sql I could not dump the entire database because it has corrupted rows in pg_attribute. Need help. - Marcos Oliveira -- View this

Re: [ADMIN] Schema with OID 0 does not exist in pg_dump

Hi, Just managed to complete the pg_dump by replacing the broken pg_operator file with the one from non-broken database then I read what You've written. Now I can go further with the DB :-) Thanks a lot for the guidelines Tom. Regards Luke 2011/9/5 Tom Lane > Lukasz Brodziak writes: > > Ok, I'

Re: [ADMIN] Schema with OID 0 does not exist in pg_dump

Lukasz Brodziak writes: > Ok, I've found the rows theyh were placed in pg_operator table. After > deletion I get the following error in pg_dump: > pg_dump: Error message from server: ERROR: operator is not unique: smallint > <> integer > LINE 1: ...d = relowner) AS rolname, relchecks, (reltrigger

Re: [ADMIN] Schema with OID 0 does not exist in pg_dump

Ok, I've found the rows theyh were placed in pg_operator table. After deletion I get the following error in pg_dump: pg_dump: Error message from server: ERROR: operator is not unique: smallint <> integer LINE 1: ...d = relowner) AS rolname, relchecks, (reltriggers <> 0) AS r...