The following bug has been logged online:
Bug reference: 6292
Logged by: David Pinheiro
Email address: davidsantospinhe...@gmail.com
PostgreSQL version: 8.4
Operating system: Linux
Description:java.sql.PreparedStatement.setNull() throws
PSQLException
Details:
I'm tr
>> ... somehow the query to dump the sequences is getting mangled. Any
>> clue how?
>
> Seems you have a sequence called "new"; seems we don't handle that
> well.
So, tested this some more. For some reason, 8.4's pg_dump would
recognize NEW as a reserved word and quote it before dumping. 9.0
Josh Berkus wrote:
> 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_
> Seems you have a sequence called "new"; seems we don't handle that
> well.
Hmmm ... yes, you're correct. Idiot users.
Interestingly, the sequence is no problem until 9.0. 8.4 handled it
fine. I'd guess this is another example of where merging in plpgsql
broke something.
--
Josh Berkus
Po
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
