Re: pg_dump and grants to PUBLIC

Blair Lowe <postgresql@zedemail.ca> writes:
> On Mon, 2006-08-05 at 16:32 -0700, Joshua D. Drake wrote:
>> What version of PostgreSQL is this that you are using? Because it

> ]# rpm -qi postgresql
> Name        : postgresql                   Relocations: (not
> relocateable)
> Version     : 7.3.4                             Vendor: Red Hat, Inc.
                ^^^^^

That does not square with this:

>> postgres@scratch:~$ psql -U test2 test2;
>> Welcome to psql 8.1.3, the PostgreSQL interactive terminal.
                   ^^^^^

and the psql session is talking to test2 but you're dumping an
unrelated database:

>> postgres@scratch:~$ pg_dump test1;

I see no evidence here that test1 didn't already have "foo" in it.

            regards, tom lane