Re: pg_dump in 7.2.4 with trigger functions

Steve Wampler <swampler(at)noao(dot)edu> writes:
> In fact, now that I look more at the dump file, it's kinda interesting.
> Near the top are the lines:

> \connect "atst.logdb" atst

> SET client_encoding = 'SQL_ASCII';
> SET check_function_bodies = false;

> SET SESSION AUTHORIZATION 'sbw';

> ('sbw' is a superuser, 'atst' was not. The restore was run by
> [Linux] user 'sbw'.)

Yeah, this is a bug in pg_dump --- it's failing to consider that doing
the \connect that way might lose superuser privileges. More recent
versions of pg_dump avoid that problem, but as long as you're on 7.4
the best advice may be to not rely on the -C switch.

regards, tom lane