"Robert John Shepherd" <robert(at)reviewer(dot)co(dot)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