Re: Use of Serial Datatype and Sequence Issue

Keary Suska <hierophant@pcisys.net> writes:
> On a separate issue, in 7.0.3, the \connect lines would fail because the
> passwords for the root user and the database owner are different, so I would
> have to dump and reload as root user, otherwise the pg_class updates would
> fail. Has this been solved in 7.1.3?

I believe that 7.1 psql will prompt for passwords as necessary, so this
works, but it's awfully tedious.  Better to arrange things so that you
don't need to give a password.

There is support in 7.2 (not sure if it was in 7.1) for the ownership
changes to be executed via "SET current_userid" style commands, so that
as long as you connect as superuser to start with (to be allowed to do
this SET) you shouldn't need to answer password prompts for individual
ownership changes.  But in a pg_dumpall script you'll probably still
have to answer once per database ...

            regards, tom lane