Re: pg_dump: query to get data of sequence "blahblahthis" returned name "blahblahthat"

"Robert John Shepherd" <robert@reviewer.co.uk> writes:
> When trying to do a pg_dumpall I get:
> dumping database "Reviewer"...
> pg_dump: query to get data of sequence "intartistmemberindex_key"
> returned name "tblartistsmembers_intartistmemb"
> pg_dump failed on Reviewer, exiting

> Having googled around a bit I've discovered this is because I have
> renamed a few sequences.

Yup.

> is there any known fix to work around this problem?

Sure, remove the test in pg_dump that looks at the sequence_name field
of the sequence.  We decided that was a dumb idea and diked it out for
7.3 ...

            regards, tom lane