From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Cannot dump 8.4.8 database using later versions |
Date: | 2011-11-14 23:11:23 |
Message-ID: | 4EC1A01B.6000802@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Severity: normal
Versions tested: 9.0.4 and 9.1.1
Installed from packages on Ubuntu
Reproduceability: 100% on this server
have not tried a test case yet
Steps:
1. large running 8.4.8 PostgreSQL database
2. /usr/lib/postgresql/9.1/bin/pg_dump -Fc -v -f test.dump dbname
3. dumps all table etc definitions correctly. then:
pg_dump: saving database definition
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: NEW used in query that is
not in a rule
LINE 1: ...END AS min_value, cache_value, is_cycled, is_called from new
^
pg_dump: The command was: SELECT sequence_name, start_value, last_value,
increment_by, CASE WHEN increment_by > 0 AND max_value =
9223372036854775807 THEN NULL WHEN increment_by < 0 AND max_value =
-1 THEN NULL ELSE max_value END AS max_value, CASE WHEN
increment_by > 0 AND min_value = 1 THEN NULL WHEN increment_by < 0
AND min_value = -9223372036854775807 THEN NULL ELSE min_value END
AS min_value, cache_value, is_cycled, is_called from new
(yes, that is the entire query, I checked the logs)
... somehow the query to dump the sequences is getting mangled. Any
clue how?
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2011-11-14 23:13:40 | Re: Cannot dump 8.4.8 database using later versions |
Previous Message | David Pinheiro | 2011-11-14 16:31:02 | BUG #6292: java.sql.PreparedStatement.setNull() throws PSQLException |